DBMS - Chapterwise Database Backup and Recovery MCQs and Answers for DBA Interview

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]

Article and Schedule Quiz	Start Test!

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]

Take Mock Tests

Missiles Mock Test	Start Test!
SSC MTS Mock Test	Start Test
IBPS CLERK MOCK TEST	Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH)	Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi)	Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH)	Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH)	Start Test!
IB Security Assistant Mock test 1 (english)	Start Test!
UP POLICE CONSTABLE MOCK TEST 1	Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI)	Start Test!