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

Questions

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]

⭐ Make GKSeries Your Preferred Source on Google

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]