Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q41: Which of the following is added to the data by the DBMS when storing it?
- A: Indexes
- B: Physical addresses
- C: File paths
- D: Permissions
View Answer
A
Q42: Which process reduces disk operations and improves the efficiency of writing data?
- A: Record header addition
- B: Data compression
- C: Block-wise storage
- D: File organization
View Answer
C
Q43: The mapping between internal and conceptual levels is called?
- A: Conceptual mapping
- B: External mapping
- C: Conceptual/Internal mapping
- D: External/Internal mapping
View Answer
C
Q44: What is data encryption used for at the internal level?
- A: Reduce storage space
- B: Improve data readability
- C: Secure stored data
- D: Create indexes
View Answer
C
Q45: What is the DBMS responsible for in a client-server environment?
- A: Data input
- B: Transaction processing
- C: Communication
- D: Storing files
View Answer
B
Q46: Which type of independence is achieved between the conceptual and internal levels?
- A: Physical data independence
- B: Logical data independence
- C: Data communication independence
- D: Transaction independence
View Answer
A
Q47: What does the DBMS catalog store?
- A: Physical locations of data
- B: Schema information
- C: Data encryption keys
- D: Backup information
View Answer
B
Q48: Logical data independence protects changes made at which level?
- A: Physical
- B: Conceptual
- C: External
- D: Data storage
View Answer
B
Q49: What function allows multiple transactions to be processed simultaneously?
- A: Transaction support
- B: Concurrency control
- C: Authorization services
- D: Recovery services
View Answer
B
Q50: What does data integrity ensure in a DBMS?
- A: Data is stored in binary format
- B: Data reflects the truth
- C: Data is compressed
- D: Data is encrypted
View Answer
B