DBMS EXAM 1 QUESTIONS WITH CORRECT
ANSWERS
Storage Manager and Query Processor - Correct Answers -Functional components of a
DB system broadly divided into:
Storage Manager - Correct Answers -module that provides the interface between the
low-level data stored in the DB and the application programs and queries submitted to
the system.
File Manager - Correct Answers -manages the allocation of space on disk and the data
structures used to represent information stored on disk.
Buffer Manager - Correct Answers -responsible for fetching data from disk storage into
main memory, and deciding what data to cache in main memory.
Authorization & Integrity Manager - Correct Answers -checks satisfaction of integrity
constraints and authority of users to access data.
DDL (Data Definition Language) - Correct Answers -for defining relation schemas,
deleting relations, and modifying relation schemas
DML (Data Manipulation Language) - Correct Answers -to query information from the
database and to insert tuples into, delete tuples from, and modify tuples in the
database.
a)interaction with the file manager.
b)integrity enforcement.
c)security enforcement.
d)backup and recovery.
e)concurrency control - Correct Answers -5 responsibilities of a dmbs
Transaction Manager - Correct Answers -ensures that database remains in a consistent
state despite system failures, and controls concurrent transaction.
1. Parsing & Translation
2. Optimization
3. Evaluation - Correct Answers -Query Processing Steps (3)
1. Atomicity
ANSWERS
Storage Manager and Query Processor - Correct Answers -Functional components of a
DB system broadly divided into:
Storage Manager - Correct Answers -module that provides the interface between the
low-level data stored in the DB and the application programs and queries submitted to
the system.
File Manager - Correct Answers -manages the allocation of space on disk and the data
structures used to represent information stored on disk.
Buffer Manager - Correct Answers -responsible for fetching data from disk storage into
main memory, and deciding what data to cache in main memory.
Authorization & Integrity Manager - Correct Answers -checks satisfaction of integrity
constraints and authority of users to access data.
DDL (Data Definition Language) - Correct Answers -for defining relation schemas,
deleting relations, and modifying relation schemas
DML (Data Manipulation Language) - Correct Answers -to query information from the
database and to insert tuples into, delete tuples from, and modify tuples in the
database.
a)interaction with the file manager.
b)integrity enforcement.
c)security enforcement.
d)backup and recovery.
e)concurrency control - Correct Answers -5 responsibilities of a dmbs
Transaction Manager - Correct Answers -ensures that database remains in a consistent
state despite system failures, and controls concurrent transaction.
1. Parsing & Translation
2. Optimization
3. Evaluation - Correct Answers -Query Processing Steps (3)
1. Atomicity
