Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. SQL can be used to:
a. create database structures only
b. query database data only
c. modify database data only
d. all of the mentioned
Q. Which of the following are introduced to reduce the overheads caused by the log- based recovery?
a. checkpoints
b. indices
c. deadlocks
d. locks
Q. Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other
a. concurrency
b. deadlock
c. backup
d. recovery
Q. Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
a. record controller
b. exclusive lock
c. authorization rule
d. two phase lock
Q. A system is in a state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
a. idle
b. waiting
c. deadlock
d. ready
Q. The deadlock state can be changed back to stable state by using statement.
a. commit
b. rollback
c. savepoint
d. deadlock
Q. What are the ways of dealing with deadlock?
a. deadlock prevention
b. deadlock recovery
c. deadlock detection
d. all of the mentioned
Q. The deadlock in a set of a transaction can be determined by
a. read-only graph
b. wait graph
c. wait-for graph
d. all of the mentioned
Q. A deadlock exists in the system if and only if the wait-for graph contains a
a. cycle
b. direction
c. bi-direction
d. rotation
Q. rollback requires the system to maintain additional information about the state of all the running transactions.
a. total
b. partial
c. time
d. commit
Q. If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called
a. intention lock modes
b. explicit lock
c. implicit lock
d. exclusive lock
Q. If a node is locked in explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
a. intention lock modes
b. intention-shared-exclusive mode
c. intention-exclusive (ix) mode
d. intention-shared (is) mode
Q. If a node is locked in then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.
a. intention lock modes
b. intention-shared-exclusive mode
c. intention-exclusive (ix) mode
d. intention-shared (is) mode