Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

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

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]
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]


Useful Computer Science EBooks