Question

A transaction in which either all of the database actions occur or none of them do is called:

a.

atomic

b.

consistent

c.

isolated

d.

durable

Posted under Concurrency Control DBMS

Answer: (a).atomic

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. A transaction in which either all of the database actions occur or none of them do is called:

Add Comment

Similar Questions

Discover Related MCQs

Q. A cursor type in which the application can only move forward through the recordset is called:

View solution

Q. Which of the following occurs when one transaction reads a changed record that has not been committed to the database?

View solution

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

View solution

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

View solution

Q. The size of a lock is called:

View solution

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

View solution

Q.
Locks placed by the DBMS are called ________ .

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. A race condition occurs when

View solution

Q. Data integrity control

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. If a transaction has obtained a __________ lock, it can read but cannot write on the item

View solution

Q. If a transaction has obtained a ________ lock, it can both read and write on the item

View solution

Q. A transaction can proceed only after the concurrency control manager ________ the lock to the transaction

View solution

View All MCQs on Concurrency Control

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!

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

Formal Languages and Automata Theory

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

Computer Graphics

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

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...