Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

Get Attractive Job

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]
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

Useful Computer Science EBooks