Current Affairs Quiz 2024Courses UGC NETADRE 2.0English

Database Backup and Recovery Multiple Choice Questions Answers | Database Management System

Download PDF

DBMS multiple choice questions and answers page contain 5 questions from chapter Database Backup & Recovery. Each objective question has 4 possible answers. Choose your answer and check your answer with the given correct answer.
Go To Download Page
(1) A deadlock exists in the system if and only if the wait for graph :
[A] has a cycle in it
[B] has a path from first node to last node
[C] is a tree
[D] none of the above

Comment

Answer: Option [A]
(2) Data processing cycle consists of :
[A] Input cycle and output cycle
[B] Input cycle, output cycle, storage and processing cycle
[C] Output cycle and processing cycle
[D] None of these

Comment

Answer: Option [B]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

Article and Schedule Quiz Start Test!
(3) Which of the following is not a proper state of transaction ?
[A] Partially aborted
[B] Partially committed
[C] Aborted
[D] Committed

Comment

Answer: Option [A]
(4) Which of the following concurrency-control schemes is not based on the serializability Property ?
[A] Two-phase locking
[B] Graph-based locking
[C] Timestamp-based locking
[D] None of the above

Comment

Answer: Option [D]
(5) Rollback of transactions is normally used to :
[A] recover from transaction failure
[B] update the transaction
[C] retrieve old records
[D] repeat a transaction

Comment

Answer: Option [A]

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