JOIN ADRE 2.0 Telegram Group

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

Questions
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

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

Answer: Option [D]
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

18 One of the following steps is not involved in processing a query :
A Parsing and transaction
B Optimization
C Evaluation
D Distribution

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.

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.

Answer: Option [D]

ADRE 2.0 FULL LENGTH MOCK TEST

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!

Chapters

Advertisement