JOIN ADRE 2.0 Telegram Group

Database Backup and Recovery Objective Questions and Answers - DBMS MCQs for Interview

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]
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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]

ADRE 2.0 FULL LENGTH MOCK TEST

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!

Chapters

Advertisement
Assam Direct Recruitment Test Series