Data Storage and Querying MCQ (Multiple Choice Questions) PDF Download

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

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

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

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

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

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

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