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]

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
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]

Chapters

ADRE 3.0 Complete Study Material