Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

Online MBA - FEE Rs. 7500 Only

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

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

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

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

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.

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.

Answer: Option [D]


Useful Computer Science EBooks