GkSeries.com

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

Download PDF

DBMS objective questions and answers page contain 5 questions from chapter Database Backup & Recovery. Each mcq has 4 possible answers. Choose your answer and check your answer with the given correct answer.
Go To Download Page
(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

Comment

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

Comment

Answer: Option [A]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

(8) Which is not a desirable property of a transaction ?
[A] Isolation
[B] Atomicity
[C] Durability
[D] All are desirable

Comment

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

Comment

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

Comment

Answer: Option [B]

Please share this page

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

Click Here to Read more questions

Teacher Eligibility Test