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