JOIN ADRE 2.0 Telegram Group

Database Backup and Recovery Short Questions Answers | DBMS Objective Questions and Answers

Questions
21 A statement that is executed automatically by the system as a side effect of a modification to the database is known as :
A Assertion
B Triggers
C Referential constraints
D None of the above

Answer: Option [B]
22 An audit trail :
A Can be used to restore lost information
B is used to make backup copies
C is the recovered history of operations performed on a file
D all of the above

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

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

23 Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
A it will result in a deadlock situation
B it will immediately be granted
C it will immediately be rejected
D it will immediately be rejected

Answer: Option [D]
24 Which technique is used to restore a database upto the last consistent state after system failure ?
A Backup
B Recovery
C Both [A] and [B]
D None of the above

Answer: Option [B]
25 What is log in log based recovery system ?
A Filter
B Records
C Blocks
D Numbers

Answer: Option [B]

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