JOIN ADRE 2.0 Telegram Group

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

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]

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!