Current Affairs Quiz 2024Courses UGC NETADRE 2.0English

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

Article and Schedule Quiz Start Test!
(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]

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!

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

Chapters

LEAVE A COMMENT