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
ADRE 2.0 Mock Test - 5 Start Test
ADRE 2.0 Mock Test - 5 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 MOCK TEST

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters

Advertisement