Master In Computer Science

Database Systems MCQs

CS: Database Systems MCQs - Subtopic

Concurrency in Index Structures MCQ with Answers

Concurrency in Index Structures Multiple Choice Questions (MCQ) to practice concurrency in index structures quiz answers PDF, concurrency in index structures worksheets for online degrees. Solve concurrency control Multiple Choice Questions and Answers (MCQs), "Concurrency in Index Structures Quiz Questions" and answers for online computer science engineering. Learn concurrency in index structures, multiple granularity in dbms, deadlock handling test prep for CS major.

"The system must deal with the deadlocks that are not prevented by using schemes of" Multiple Choice Questions (MCQ) on concurrency in index structures with choices validation, deadlock detection, deadlock recovery, and both a and b for online computer science engineering. Solve concurrency in index structures quiz questions for merit scholarship test and certificate programs for online college classes.

MCQs on Concurrency in Index Structures

1.

The system must deal with the deadlocks that are not prevented by using schemes of

Validation
Deadlock detection
Deadlock recovery
Both A and B

2.

A scheme that creates a new version of a data item for each transaction is defined by

Concurrency control scheme
Multiversion concurrency control scheme
Timestamp concurrency control scheme
Wound concurrency control scheme

3.

A transaction that is inserting a new tuple into the database is given an

Shared lock
Mutual lock
Exclusive lock
NO lock

4.

Concurrency control is a challenging task for transactions that have

Application accesses
I/O activities
User interactions
Application interactions

5.

In preemption technique, transactions are assigned a unique timestamp to decide whether it should wait or

Executed
Committed
Aborted
Rolled back