Database Management System MCQ Set 7

1) The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

A. Procedural DML

B. Non-Procedural DML

C. Procedural DDL

D. Non-Procedural DDL

2) Which two files are used during operation of the DBMS?

A. Query languages and utilities

B. DML and query language

C. Data dictionary and transaction log

D. Data dictionary and query language

3) The database schema is written in

A. HLL

B. DML

C. DDL

D. DCL

4) The way a particular application views the data from the database that the application uses is a

A. module

B. relational model

C. schema

D. sub schema

5) The relational model feature is that there

A. is no need for primary key data

B. is much more data independence than some other database models

C. are explicit relationships among records.

D. are tables with many dimensions

6) Which one of the following statements is false?

A. The data dictionary is normally maintained by the database administrator

B. Data elements in the database can be modified by changing the data dictionary.

C. The data dictionary contains the name and description of each data element.

D. The data dictionary is a tool used exclusively by the database administrator.

7) Which of the following are the properties of entities?

A. Groups

B. Table

C. Attributes

D. Switchboards

8) Which database level is closest to the users?

A. External

B. Internal

C. Physical

D. Conceptual

9) Which are the two ways in which entities can participate in a relationship?

A. Passive and active

B. Total and partial

C. Simple and Complex

D. All of the above

10) ........ data type can store unstructured data

A. RAW

B. CHAR

C. NUMERIC

D. VARCHAR

Answers

1.b

2.c

3.c

4.d

5.b

6.b

7.c

8.a

9.b

10.a