Master In Computer Science

Database Systems MCQs

CS: Database Systems MCQs - Subtopic

Multiple Granularity in DBMS MCQ with Answers

Multiple Granularity in DBMS Multiple Choice Questions (MCQ) to practice multiple granularity in dbms quiz answers PDF, multiple granularity in data sciencems worksheets for online degrees. Solve concurrency control Multiple Choice Questions and Answers (MCQs), "Multiple Granularity in DBMS Quiz Questions" and answers for 2 year computer science degree. Learn concurrency in index structures, multiple granularity in dbms, deadlock handling test prep for top computer science schools in the world.

"The rigorous two-phase locking protocol permits releasing all locks at the" Multiple Choice Questions (MCQ) on multiple granularity in dbms with choices beginning of transaction, during execution of transaction, end of transaction, and never in the life-time of transaction for 2 year computer science degree. Solve multiple granularity in dbms quiz questions for merit scholarship test and certificate programs for CS major.

MCQs on Multiple Granularity in DBMS

1.

The rigorous two-phase locking protocol permits releasing all locks at the

Beginning of transaction
During execution of transaction
End of transaction
Never in the life-time of transaction

2.

For deadlock prevention, when we use an ordering of data items, the request locks are sequenced in

Consistent with access
Consistent with relation
Consistent with ordering
Consistent with execution

3.

A way of guarding against deadlock prevention is to

Order data items
Order the execution
Order access
Order cascading

4.

To ensure deadlock prevention, we can use the preemption approach and

Rollbacks
Timestamping
Cascading
Validating

5.

Graph-based locking protocols impose restrictions on the

Order of execution
Order of access
Order of evaluation
Order of cascading