Classical

Database MCQ - ER-model & Relational Model

11:  

The method in which records are physically stored in a specified order according to a key field in each record is

A.

Hash

B.

Direct.

C.

Sequential

D.

All of the above.

 
 

Option: A

Explanation :

A method in which records are physically stored in a specified order according to a key field in each record is hash. (In hash method, a hash function is performed on the key value to determine the unique physical address of the record to store or retrieve)


12:  

 A subschema expresses

A.

The logical view

B.

The physical view.

C.

The external view.

D.

All of the above.

 
 

Option: C

Explanation :

 A subschema expresses the external view. (External schemas are called also called as subschemas)


13:  

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.

 
 

Option: B

Explanation :


14:  

 An advantage of the database management approach is

A.

Data is dependent on programs

B.

Data redundancy increases.

C.

Data is integrated and can be accessed by multiple programs.

D.

None of the above

 
 

Option: C

Explanation :


15:  

 A DBMS query language is designed to

A.

Support end users who use English-like commands

B.

Support in the development of complex applications software

C.

Specify the structure of a database.

D.

All of the above.

 
 

Option: D

Explanation :




Suggest an improvement