MCQ's on Database Management System (DMBS)

MCQ 1:
Which of the field has width 8 bytes?

Memo
Number
Date/Time
Hyperlink

MCQ 2:
What is the size of Yes, No field?

1 bit
1 byte
1 character
1 GB

MCQ 3:
Which key is uniquely identifies each record?

Unique Key
Primary Key
Secondary Key
Candicate Key<

MCQ 4:
When you create or open the MS Access database file, command center of access file that appears

Database Window
Query Window
Design View Window
Switchboard

MCQ 5:
A database language concerned with the definition of the whole database structure and schema is ______________.

DCL (Data Control Language)
DML (Data Manipulation Language)
DDL (Data Definition Language)
All of the above

MCQ 6:
How to create a relationship between two tables in database.

Drag the primary key of a table into foreign key of another table
Drag the foreign key of a table into the primary key of another table
Drag any field from parent table and drop on child table
Any of above can be done to create relationship

MCQ 7:
If your entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

You need to delete the whole table, there is no method to remove a particular field only.
Delete all the fields from third downwards and reenter the required fields again.
Select the third column in datasheet view then Delete it.
Select the third row in table design view then Delete it.

MCQ 8:
To duplicate a controls formatting you can use ________________.

Manager
Wizard
Painter
Control

MCQ 9:
Which field type will you select when creating a new table if you require to enter long text in that field?

Text
Memo
Currency
Hyperlink

MCQ 10:
In table design view, what are the first column of buttons used for?

Indicate Primary Key
Indicate Current Row
Both of above
None of above

MCQ 11:
What does the show check box in query design window indicate?

It indicates whether the field is to be used or not
It indicates whether the field is to be displayed in query result or not
It indicates whether the field names to be displayed in query result or not
None of above

MCQ 12:
Which of the following is not a type of relationship that can be applied in access database.

One to One Relationship
One to Many Relationship
Many to Many Relationship
All of the above can be applied

MCQ 13:
A ________________ name must be unique within a database.

Table
Field
Record
Character

MCQ 14:
This option allows you to build a new table by entering data directly into the datasheet.

datasheet view
design view
link table
None of the above

MCQ 15:
To create queries in Access, what steps you do.

You can drag and drop fields on query builders
You can type the SQL command in SQL view
You can use query wizard or design view
All of the above

MCQ 16:
Which of the given is not a database model.

Network database model
Relational database model
Object Oriented database model
None of the above

MCQ 17:
In table design view, which key can be used to switch between the field names and properties panels?

F3
F4
F5
F6

MCQ 18:
Which of the following is NOT a type of Microsoft Access database object?

Table
Form
Worksheets
Modules