GkSeries.com

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

Download PDF

DBMS objective type Interview questions and answers page contain 5 questions from chapter Database Backup & Recovery. Each mcq has 4 possible answers. Choose your answer and check your answer with the given correct answer.
Go To Download Page
(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

Comment

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

Comment

Answer: Option [B]

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.

Comment

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.

Comment

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.

Comment

Answer: Option [D]

Please share this page

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

Click Here to Read more questions

Teacher Eligibility Test