Data Storage and Querying Multiple Choice Questions with Answers – PDF Download

MCQ 1: The functional components of a database system can be broadly divided into:

1. 2 components
2. 3 components
3. 4 components
4. 5 components

MCQ 2: Translation of the various DML statements into low-level file-system commands, is done by:

1. Query processor
2. Storage manager
3. Query manager
4. Storage processor

MCQ 3: The component of storage manager, which ensures that the database remains in a consistent state despite of system failures, is known as:

1. File manager
2. Authorization and integrity manager
3. Buffer manager
4. Transaction manager

MCQ 4: Data is moved between disk storage and main memory as needed, because of the:

1. Efficiency
2. Storage space
3. Processing speed
4. Normalization

MCQ 5: The component that provides the interface between the low-level data stored and the application programs and queries submitted to the system, is known as:

1. Storage manager
2. Storage processor
3. Query processor
4. Query manager