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
ADRE 2.0 Mock Test - 5 Start Test
ADRE 2.0 Mock Test - 5 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 MOCK TEST

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!

Chapters

Advertisement