GkSeries.com

Database Backup and Recovery Multiple Choice Questions Answers | Database Management System

Download PDF

DBMS multiple choice questions and answers page contain 5 questions from chapter Database Backup & Recovery. Each objective question has 4 possible answers. Choose your answer and check your answer with the given correct answer.
Go To Download Page
(1) A deadlock exists in the system if and only if the wait for graph :
[A] has a cycle in it
[B] has a path from first node to last node
[C] is a tree
[D] none of the above

Comment

Answer: Option [A]
(2) Data processing cycle consists of :
[A] Input cycle and output cycle
[B] Input cycle, output cycle, storage and processing cycle
[C] Output cycle and processing cycle
[D] None of these

Comment

Answer: Option [B]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

(3) Which of the following is not a proper state of transaction ?
[A] Partially aborted
[B] Partially committed
[C] Aborted
[D] Committed

Comment

Answer: Option [A]
(4) Which of the following concurrency-control schemes is not based on the serializability Property ?
[A] Two-phase locking
[B] Graph-based locking
[C] Timestamp-based locking
[D] None of the above

Comment

Answer: Option [D]
(5) Rollback of transactions is normally used to :
[A] recover from transaction failure
[B] update the transaction
[C] retrieve old records
[D] repeat a transaction

Comment

Answer: Option [A]

Please share this page

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

Chapters

Click Here to Read more questions

Teacher Eligibility Test