JOIN ADRE 2.0 Telegram Group

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

Questions
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

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

Answer: Option [B]
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

3 Which of the following is not a proper state of transaction ?
A Partially aborted
B Partially committed
C Aborted
D Committed

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

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

Answer: Option [A]

ADRE 2.0 FULL LENGTH MOCK TEST

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!

Chapters

Advertisement
Assam Direct Recruitment Test Series

Latest Test Series

ssc cgl test series

SSC CGL

Start Test 1000+ Tests Latest patternView Course
delhi policesi test series

DELHI POLICE SI

Start Test 1000+ Tests Latest patternView Course
west bengal psc test series

WEST BENGAL PSC

Start Test 1000+ Tests Latest patternView Course
cisf head constable test series

CISF CONSTABLE

Start Test 1000+ Tests Latest patternView Course
Junior Associate of the Indian Institute of Bankers(JAIIB) test series

JAIIB

Start Test 30 Full Length Tests View Course
adre 2024 test series

ADRE 2024

Start Test 25000+ QUESTIONS SOLUTIONSView Course
RRB RRC GROUP D test series

RRB RRC GROUP D

Start Test 15000+ QUESTIONS Latest patternView Course
UP POLICE SI test series

UP POLICE SI

Start Test 16000+ QUESTIONS Latest patternView Course
CLICK HERE TO VIEW ALL COURSES