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. |
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. |
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. |
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. |
