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]

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
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]

Chapters

ADRE 3.0 Complete Study Material