Concurrency Control Mcqs

Our collections of Multiple choice questions and answers focuses on study of Concurrency Control in DBMS. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate DBMS Concurrency Control in DBMS comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Concurrency Control Mcqs

1.
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?

Read committed

Read uncommitted

Repeatable read

Serializable

2.
Which of the following locks the item from access of any type?

Implicit lock

Explicit lock

Exclusive lock

Shared lock

4.
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:

Forward only

Static

Keyset

Dynamic

5.
Locks placed by the DBMS are called ________ .

Implicit locks

Explicit locks

Exclusive locks

Shared locks

6.
If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by

Flashback

Rollback

Both a and b

Cannot be done

7.
When the transaction finishes the final statement the transaction enters into

Active state

Committed state

Partially committed state

Abort state

8.
Which of the following is an atomic sequence of database actions?

Transaction

Concurrency

Relations

All of the mentioned

9.
DBMS periodically suspends all processing and synchronizes its files and journals through the use of

Checkpoint facility

Backup facility

Recovery manager

Database change log

10.
A race condition occurs when

Two concurrent activities interact to cause a processing error

Two users of the DBMS are interacting with different files at the same time

Both (a) and (b)

All of the above

11.
Data integrity control

Is used to set upper and lower limits on numeric data

Requires the use of passwords to prohibit unauthorized access to the file

Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files

All of the above

12.
The type of constraints that specifies the uniqueness of data stored in the database are considered as

Semantics

Business rules

Controlled rules

Structural rules

13.
The property of DBMS which ensures the execution of all the operations in transaction or none of the operation is executed is classified as

Isolation property

Atomicity property

Online execution property

Offline execution property

14.
The control feature in database management system which ensures the accuracy of data updated by multiple users is classified as

Conceptual implementation control

Concurrency control

Interface modeling control

User accessibility control

15.
The property of DBMS which ensures whether the hundreds of applications are executed, each transaction must be executed in isolation is classified as

Online execution property

Offline execution property

Isolation property

Atomicity property

0Shares
0
Scroll to Top