Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 41
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
Correct Answer:
C
Chapter: 41
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
Correct Answer:
A
Chapter: 41
Q663:
Which property of a transaction ensures that it does not affect other transactions?
A. Isolation
B. Atomicity
C. Durability
D. Consistency
Correct Answer:
A
Chapter: 41
Q664:
Which type of view is stored as a pre-computed table?
A. Materialized View
B. Dynamic View
C. Simple View
D. Complex View
Correct Answer:
A
Chapter: 41
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
Correct Answer:
A
Chapter: 41
Q666:
In transaction management, which term refers to a transaction that has been successfully executed?
A. Commit
B. Rollback
C. Fail
D. Abort
Correct Answer:
A
Chapter: 41
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
Correct Answer:
A
Chapter: 41
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
Correct Answer:
A
Chapter: 42
Q669:
What does a DBMS ensure when interleaving transactions?
A. Atomicity
B. Consistency
C. Isolation
D. Durability
Correct Answer:
A
Chapter: 42
Q670:
The four properties of transactions in a DBMS are known by which acronym?
A. ACID
B. ABC
C. XYZ
D. DEF
Correct Answer:
A
Chapter: 42
Q671:
In a DBMS, what is the purpose of a lock-based concurrency control protocol?
A. To allow unrestricted access to database objects
B. To ensure that transactions are executed serially
C. To ensure that interleaved transactions have the same effect as serial execution
D. To prevent any database access during transaction execution
Correct Answer:
C
Chapter: 42
Q672:
What does serializability ensure about a schedule in a DBMS?
A. It guarantees that the schedule is always complete
B. It ensures the schedule's effect is identical to some serial schedule
C. It prevents any form of concurrency
D. It guarantees no transaction will abort
Correct Answer:
B
Chapter: 42
Q673:
What is a deadlock in the context of transaction management?
A. A situation where all transactions complete successfully
B. A cycle of transactions waiting for each other’s locks to be released
C. A method for preventing transactions from accessing the same data
D. A method for increasing transaction throughput
Correct Answer:
B
Chapter: 42
Q674:
What property of transactions ensures that incomplete transactions do not affect the database?
A. Atomicity
B. Consistency
C. Isolation
D. Durability
Correct Answer:
A
Chapter: 42
Q675:
Which locking protocol is known for its two-phase approach?
A. Strict Two-Phase Locking
B. Optimistic Locking
C. Pessimistic Locking
D. Conservative Locking
Correct Answer:
A
Chapter: 42
Q676:
In Strict Two-Phase Locking, when are all locks released?
A. When a transaction begins
B. When a transaction requests a lock
C. When a transaction commits
D. When a transaction reads an object
Correct Answer:
C
Chapter: 42
Q677:
A transaction’s effect should be persistent even if the system crashes after completion. This property is known as?
A. Atomicity
B. Consistency
C. Isolation
D. Durability
Correct Answer:
D
Chapter: 42
Q678:
The acronym ACID stands for Atomicity, Consistency, Isolation, and which other property?
A. Durability
B. Dependability
C. Detectability
D. Delay
Correct Answer:
D
Chapter: 42
Q679:
In the wait-die scheme for deadlock prevention, what happens if a lower priority transaction requests a lock held by a higher priority transaction?
A. The lower priority transaction is aborted
B. The higher priority transaction is aborted
C. Both transactions are aborted
D. The system waits for both transactions to complete
Correct Answer:
A
Chapter: 42
Q680:
The main benefit of concurrent execution of transactions in a DBMS is to improve?
A. Consistency
B. Throughput
C. Isolation
D. Atomicity
Correct Answer:
B