Database Backup and Recovery Objective Type Questions Answers | Database Management System MCQs

(6) Which commands are used to control which users have which privilege over which objects ?
[A] QUE and QUIST
[B] GRANT and REVOKE
[C] CASECADE and MVD
[D] None of the above

Comment

Answer: Option [B]
(7) When a deadlock is detected the recovery is normally accomplished by :
[A] rollback of transaction
[B] locking of data
[C] consistency checking
[D] none of these

Comment

Answer: Option [A]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

Article and Schedule Quiz Start Test!
(8) Which is not a desirable property of a transaction ?
[A] Isolation
[B] Atomicity
[C] Durability
[D] All are desirable

Comment

Answer: Option [D]
(9) A directed graph which represents the deadlock is called :
[A] cycle graph
[B] deadlock graph
[C] wait-for graph
[D] none of the above

Comment

Answer: Option [C]
(10) Transaction Throughput is :
[A] Elapsed Time between submitting a transaction and receiving a transaction.
[B] Average no. of transaction processed per second.
[C] No. of resources used by a transaction.
[D] None of the above

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!

Chapters