Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q661: A transaction that guarantees that none of its steps are executed due to an error is said to be _______.
- A: Committed
- B: Completed
- C: Rolled Back
- D: Failed
View Answer
C
Q662: In a distributed environment, materialized views are used to _______.
- A: Replicate data at distributed sites
- B: Replace base tables
- C: Increase storage capacity
- D: Encrypt data
View Answer
A
Q663: Which property of a transaction ensures that it does not affect other transactions?
- A: Isolation
- B: Atomicity
- C: Durability
- D: Consistency
View Answer
A
Q664: Which type of view is stored as a pre-computed table?
- A: Materialized View
- B: Dynamic View
- C: Simple View
- D: Complex View
View Answer
A
Q665: The process of refreshing a materialized view is similar to _______.
- A: Updating indexes
- B: Creating new tables
- C: Deleting old records
- D: Running SQL queries
View Answer
A
Q666: In transaction management, which term refers to a transaction that has been successfully executed?
- A: Commit
- B: Rollback
- C: Fail
- D: Abort
View Answer
A
Q667: What is the primary function of a clustered index on a view?
- A: To store the result set built at the time the index is created
- B: To provide a backup for the view
- C: To update the view periodically
- D: To encrypt the data
View Answer
A
Q668: To create a view that joins multiple tables, you use _______.
- A: The JOIN clause
- B: The WHERE clause
- C: The ORDER BY clause
- D: The GROUP BY clause
View Answer
A
Q669: What does a DBMS ensure when interleaving transactions?
- A: Atomicity
- B: Consistency
- C: Isolation
- D: Durability
View Answer
A
Q670: The four properties of transactions in a DBMS are known by which acronym?
- A: ACID
- B: ABC
- C: XYZ
- D: DEF
View Answer
A