Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
a. Entity Integrity Constraints
b. Referential Integrity Constraints
c. Domain Integrity Constraints
d. Key Constraints
Q. ____ ensures that once transaction changes are done, they cannot be undone orlost, even in the event of a system failure.
a. Atomicity
b. Consistency
c. Durability
d. Isolation
Q. Deadlocks are possible only when one of the transactions wants to obtain a(n)____ lock on a data item.
a. binary
b. exclusive
c. shared
d. Complete
Q. A DBMS uses a transaction ____ to keep track of all transactions that update thedatabase
a. log
b. table
c. block
d. Statement
Q. When a program is abnormally terminated, the equivalent of a ____ commandoccurs.
a. COMMIT
b. ROLLBACK
c. QUIT
d. EXIT
Q. In a(n) ____ backup of the database, only the last modifications to the databaseare copied.
a. full
b. incomplete
c. differential
d. transaction log
Q. Although the ____ locking approach improves the availability of data, itsmanagement requires high overhead.
a. database-level
b. table-level
c. page-level
d. row-level
Q. A(n) ____ lock exists when concurrent transactions are granted Read access onthe basis of a common lock.
a. binary
b. field-level
c. shared
d. Exclusive
Q. A ____ database state is one in which all data integrity constraints are satisfied.
a. fixed
b. complete
c. consistent
d. Secure
Q. ____ means that the data used during the execution of a transaction cannot beused by a second transaction until the first one is completed.
a. Atomicity
b. Consistency
c. Durability
d. Isolation
Q. The three basic techniques to control deadlocks are: deadlock ____, deadlockdetection, and deadlock avoidance.
a. prevention
b. prohibition
c. rollback
d. Commits
Q. All transactions are controlled and executed by the DBMS (subject to somelimitations) to guarantee database ____.
a. integrity
b. uniqueness
c. consistency
d. Design
Q. In a ____ lock, the DBMS will lock an entire disk page.
a. database-level
b. table-level
c. page-level
d. row-level