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 12 of 15

Explore more Topics under DBMS

Q111.
Which of the following is not true about B+ trees?

a.

B+ tree index takes the form of balanced tree

b.

Performance of B+ tree degrades as the file grows

c.

Look-up in B+ tree is straightforward and efficient

d.

Insertion and deletion in B+ tree is complicated but efficient

Discuss
Answer: (b).Performance of B+ tree degrades as the file grows
Q112.
The extent of the database resource that is included with each lock is called the level of

a.

Impact

b.

Granularity

c.

Management

d.

DBMS control

Discuss
Answer: (b).Granularity
Q113.
Snapshot isolation is a particular type of ______________ scheme.

a.

Concurrency-control

b.

Concurrency-allowance

c.

Redirection

d.

Repetition-allowance

Discuss
Answer: (a).Concurrency-control
Q114.
Snapshot isolation is used to give

a.

Transaction a snapshot of the database

b.

Database a snapshot of the transaction

c.

Database a snapshot of committed values in the transaction

d.

Transaction a snapshot of the database and Database a snapshot of committed values in the transaction

Discuss
Answer: (d).Transaction a snapshot of the database and Database a snapshot of committed values in the transaction
Q115.
Lost update problem is

a.

Second update overwrites the first

b.

First update overwrites the second

c.

The updates are lost due to conflicting problem

d.

None of the mentioned

Discuss
Answer: (a).Second update overwrites the first
Q116.
Under first updater wins the system uses a __________ mechanism that applies only to updates.

a.

Close

b.

Read

c.

Locking

d.

Beat

Discuss
Answer: (c).Locking
Q117.
When a transaction Ti attempts to update a data item, it requests a _________ on that data item.

a.

Read lock

b.

Update lock

c.

Write lock

d.

Chain lock

Discuss
Answer: (c).Write lock
Q118.
Each of a pair of transactions has read data that is written by the other, but there is no data written by both transactions, is referred to as

a.

Read skew

b.

Update skew

c.

Write lock

d.

None of the mentioned

Discuss
Answer: (d).None of the mentioned
Q119.
An application developer can guard against certain snapshot anomalies by appending a ______ clause to the SQL select query.

a.

For update

b.

For read

c.

For write

d.

None of the mentioned

Discuss
Answer: (a).For update
Q120.
Evaluate the CREATE TABLE statement:

CREATE TABLE products
(product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2(15));

Which statement is true regarding the PROD_ID_PK constraint?

a.

It would be created only if a unique index is manually created first

b.

It would be created and would use an automatically created unique index

c.

It would be created and would use an automatically created no unique index

d.

It would be created and remains in a disabled state because no index is specified in the command

Discuss
Answer: (b).It would be created and would use an automatically created unique index
Page 12 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!

Data Science

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

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Formal Languages and Automata Theory

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

Systems Programming

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

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...