Database Backup and Recovery MCQs | Chapter-wise DBMS Interview Questions and Answers

Questions

11 A transaction performs on the isolation level of the Read Uncommitted if :

A A dirty read occurs

B Non-repeatable read occurs

C Phantom reads occurs

D All of the above

Answer: Option [D]

12 One common approach of preventing deadlocks, before beginning an update is :

A lock the DBMS

B lock the database

C lock the one row

D lock all the rows and/or table

Answer: Option [B]

Article and Schedule Quiz	Start Test!

13 Media recovery refers to recovering database :

A after a system crash.

B after some individual transaction has failed.

C after database has been physically damaged.

D none of the above.

Answer: Option [C]

14 Which one is true statement ?

A With finer degree of granularity of locking a high degree of concurrency is possible.

B Locking prevents non-serializable schedules.

C Locking cannot take place at level.

D An exclusive lock on data item X is granted even if a shared lock in already held on X.

Answer: Option [B]

15 Assume transaction A holds a share lock R. If a transaction B also requests for a shared lock on R.

A it will result in deadlock situation.

B it will immediately be granted.

C it will immediately be rejected.

D it will be granted as soon as it is released by A.

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!