Current Affairs Quiz 2024Courses UGC NETADRE 2.0English

Database Backup and Recovery Questions and Answers | DBMS MCQs with Answers

Download PDF

DBMS multiple choice questions and answers page contain 5 questions from chapter Database Backup & Recovery. Each objective question has 4 possible answers. Choose your answer and check your answer with the given correct answer.
Go To Download Page
(16) A race condition occurs when :
[A] Two concurrent activities interact to cause a processing error.
[B] Two users of the DBMS are interacting with different files at the same time.
[C] Both [A] and [B]
[D] None of the above

Comment

Answer: Option [A]
(17) In multiuser database, if two users wish to update the same record at the same time, they are prevented by doing so by
[A] jamming
[B] password
[C] documentation
[D] record-lock

Comment

Answer: Option [D]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

Article and Schedule Quiz Start Test!
(18) One of the following steps is not involved in processing a query :
[A] Parsing and transaction
[B] Optimization
[C] Evaluation
[D] Distribution

Comment

Answer: Option [D]
(19) Which one of the following describes the timestamp-based protocols correctly ?
[A] This protocol requires that each transaction issue lock and unlock requests in two phases.
[B] This protocol employs only exclusive locks.
[C] This protocol selects an ordering among transaction in advance.
[D] None of the above.

Comment

Answer: Option [C]
(20) Which of the following can enhance database system throughput ?
[A] Database system throughput can be enhanced by locking the smallest sized objects possible.
[B] Database system throughput can be enhanced by reducing the time that transaction that hold locks.
[C] Database system throughput can be enhanced by reducing the hot spots (frequently accessed and modified database objects).
[D] Increasing the main memory capacity can enhance database system throughput.

Comment

Answer: Option [D]

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