Concurrency Control in DBMS

This set of MCQs helps students to learn about the concepts of concurrency control concept that comes under the transaction .database management system (DBMS). It is a procedure in DBMS which helps us for the management of two simultaneous processes to execute without conflicts between each other, these conflicts occur in multi-user systems.

Start Quiz

Which of the following is not a restriction for a table to be a relation?

The cells of the table must contain a single value. All of the entries in any column must be of the same kind. The columns must be ordered. No two rows in a table may be identical.

A relation in this form is free of all modification anomalies.

First normal form Second normal form Third normal form Domain/key normal form

In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?

Triggers Pointers Locks Cursors

Which of the following are introduced to reduce the overheads caused by the log-based recovery?

Checkpoints Indices Deadlocks Locks

Which of the following protocols ensures conflict serializability and safety from deadlocks?

Two-phase locking protocol Time-stamp ordering protocol Graph based protocol None of the mentioned

Which of the following is the block that is not permitted to be written back to the disk?

Dead code Read only Pinned Zapped

If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ­­­­­­__________ on all the records belonging to that file.

Explicit lock in exclusive mode Implicit lock in shared mode Explicit lock in shared mode Implicit lock in exclusive mode

All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions.

Scheduler DBMS Lock manager Locking agent

The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.

Table-level Page-level Row-level Field-level

Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?

Record controller Exclusive lock Authorization rule Two phase lock

For some relations, changing the data can have undesirable consequences called:

Referential integrity constraints.

Modification anomalies.

Normal forms.

Transitive dependencies.

A key:

Must always be composed of two or more columns.

Can only be one column.

Identifies a row.

Identifies a column.

An attribute is a(n):

Column of a table.

Two dimensional table.

Row of a table.

Key of a table.

A lock that allows concurrent transactions to access different rows of the same table is known as a,

Database-level lock

Table-level lock

Page-level lock

Row-level lock

This refers to a property of computer to run several operations simultaneously and possible as computers await the response of each other.

Concurrency

Deadlock

Backup

Recovery

Quiz/Test Summary
Title: Concurrency Control in DBMS
Questions: 15
Contributed by:
Steve