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)

Click on Discuss to view users comments.

Write your comments here:



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)

Click on Discuss to view users comments.

Write your comments here:



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 :

Click on Discuss to view users comments.

Write your comments here:



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 :

Click on Discuss to view users comments.

Write your comments here:



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 :

Click on Discuss to view users comments.

Write your comments here:





Suggest an improvement