adplus-dvertising

Welcome to the Concurrency Control MCQs Page

Dive deep into the fascinating world of Concurrency Control with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Concurrency Control, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of Concurrency Control, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

frame-decoration

Check out the MCQs below to embark on an enriching journey through Concurrency Control. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Concurrency Control. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Concurrency Control MCQs | Page 10 of 15

Explore more Topics under DBMS

Q91.
Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other

a.

Concurrency

b.

Deadlock

c.

Backup

d.

Recovery

Discuss
Answer: (a).Concurrency
Q92.
All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions.

a.

Scheduler

b.

DBMS

c.

Lock manager

d.

Locking agent

Discuss
Answer: (c).Lock manager
Q93.
The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.

a.

Table-level

b.

Page-level

c.

Row-level

d.

Field-level

Discuss
Answer: (d).Field-level
Q94.
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?

a.

Record controller

b.

Exclusive lock

c.

Authorization rule

d.

Two phase lock

Discuss
Answer: (d).Two phase lock
Q95.
The situation where the lock waits only for a specified amount of time for another lock to be released is

a.

Lock timeout

b.

Wait-wound

c.

Timeout

d.

Wait

Discuss
Answer: (a).Lock timeout
Q96.
A deadlock exists in the system if and only if the wait-for graph contains a ___________

a.

Cycle

b.

Direction

c.

Bi-direction

d.

Rotation

Discuss
Answer: (a).Cycle
Q97.
In a granularity hierarchy the highest level represents the

a.

Entire database

b.

Area

c.

File

d.

Record

Discuss
Answer: (a).Entire database
Q98.
In a database the file is contained in ________

a.

Entire database

b.

Two area

c.

One area

d.

more than one area

Discuss
Answer: (c).One area
Q99.
If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called

a.

Intention lock modes

b.

Explicit lock

c.

Implicit lock

d.

Exclusive lock

Discuss
Answer: (a).Intention lock modes
Q100.
If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks.

a.

Intention lock modes

b.

Intention-shared-exclusive mode

c.

Intention-exclusive (IX) mode

d.

Intention-shared (IS) mode

Discuss
Answer: (a).Intention lock modes
Page 10 of 15

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...