MSACCESS_RDMS_M1

MS ACCESS_RDBMS_M1

Open Ended

List any two types of Databases .

Multiple Choice

Name the information stored row wise in a table:

• record

• field

• table

Multiple Choice

Name the information stored column wise in a table:

• field

• row

• table

Multiple Choice

Identify the number of fields in the figure

• 3

• 5

• 6

• 7

Multiple Choice

Identify the number of rows in the figure

• 6

• 7

• 8

• 9

Open Ended

List the different objects of the Database

Multiple Choice

Identify the view

• Datasheet View

• Design View

Open Ended

Can I have a primary key field with no values? Justify your answer.

Open Ended

Suppose you have created a student database and would like to delete the record of the students who has taken TC. How would you delete the record pertaining to that student? Which view is advisable to do the same?

Poll

• Yes

• NO

Open Ended

Can the field Employee Name be made primary key?

Justify your answer.

Open Ended

List two differences between Datasheet View and Design View