Database Backup and Recovery Objective Type Questions Answers | Database Management System MCQs

Questions

6 Which commands are used to control which users have which privilege over which objects ?

A QUE and QUIST

B GRANT and REVOKE

C CASECADE and MVD

D None of the above

Answer: Option [B]

7 When a deadlock is detected the recovery is normally accomplished by :

A rollback of transaction

B locking of data

C consistency checking

D none of these

Answer: Option [A]

⭐ Make GKSeries Your Preferred Source on Google

8 Which is not a desirable property of a transaction ?

A Isolation

B Atomicity

C Durability

D All are desirable

Answer: Option [D]

9 A directed graph which represents the deadlock is called :

A cycle graph

B deadlock graph

C wait-for graph

D none of the above

Answer: Option [C]

10 Transaction Throughput is :

A Elapsed Time between submitting a transaction and receiving a transaction.

B Average no. of transaction processed per second.

C No. of resources used by a transaction.

D None of the above

Answer: Option [B]