GkSeries.com

Database Backup and Recovery Questions and Answers | DBMS MCQs with Answers

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
(16) A race condition occurs when :
[A] Two concurrent activities interact to cause a processing error.
[B] Two users of the DBMS are interacting with different files at the same time.
[C] Both [A] and [B]
[D] None of the above

Comment

Answer: Option [A]
(17) In multiuser database, if two users wish to update the same record at the same time, they are prevented by doing so by
[A] jamming
[B] password
[C] documentation
[D] record-lock

Comment

Answer: Option [D]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

(18) One of the following steps is not involved in processing a query :
[A] Parsing and transaction
[B] Optimization
[C] Evaluation
[D] Distribution

Comment

Answer: Option [D]
(19) Which one of the following describes the timestamp-based protocols correctly ?
[A] This protocol requires that each transaction issue lock and unlock requests in two phases.
[B] This protocol employs only exclusive locks.
[C] This protocol selects an ordering among transaction in advance.
[D] None of the above.

Comment

Answer: Option [C]
(20) Which of the following can enhance database system throughput ?
[A] Database system throughput can be enhanced by locking the smallest sized objects possible.
[B] Database system throughput can be enhanced by reducing the time that transaction that hold locks.
[C] Database system throughput can be enhanced by reducing the hot spots (frequently accessed and modified database objects).
[D] Increasing the main memory capacity can enhance database system throughput.

Comment

Answer: Option [D]

Please share this page

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

Chapters

Click Here to Read more questions

Teacher Eligibility Test