GkSeries.com

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

Download PDF

DBMS short questions and answers page contain 5 questions from chapter Database Backup & Recovery. Each mcq has 4 possible answers. Choose your answer and check your answer with the given correct answer.
Go To Download Page
(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

Comment

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

Comment

Answer: Option [D]

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

Comment

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

Comment

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

Comment

Answer: Option [B]

Please share this page

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

Click Here to Read more questions

Teacher Eligibility Test