Current Affairs Quiz 2024Courses UGC NETADRE 2.0English

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

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

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!

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

Chapters

LEAVE A COMMENT