Transaction & ACID properties QUIZ

Last Updated :
Discuss
Comments

Question 1

What is a transaction in DBMS?

  • A user command

  • A single SQL statement

  • A logical unit of work

  • A stored procedure

Question 2

Which of the following is not one of the ACID properties?

  • Atomicity

  • Concurrency

  • Isolation

  • Durability

Question 3

Which ACID property ensures that either all operations of a transaction are completed or none?

  • Consistency

  • Atomicity

  • Durability

  • Isolation

Question 4

What does the Consistency property of ACID ensure?

  • The database always accepts new transactions

  • Every transaction brings the database from one valid state to another

  • Transactions run in parallel

  • Transactions don’t interfere with each other

Question 5

Which transaction state comes immediately after the transaction starts?

  • Active

  • Committed

  • Partially Committed

  • Failed

Question 6

What is the final state of a successful transaction?

  • Failed

  • Committed

  • Partially Committed

  • Aborted

Question 7

What happens during the “Aborted” state of a transaction?

  • Data is permanently saved

  • System waits for a lock

  • Changes are undone

  • Transaction is retried immediately

Question 8

Which ACID property ensures that the effects of a committed transaction are never lost?

  • Isolation

  • Durability

  • Atomicity

  • Consistency

Question 9

The Isolation property is mainly related to:

  • Backup and restore

  • Read and write permissions

  • Concurrent execution of transactions

  • Query optimization

Question 10

When a transaction has completed its final operation but is not yet committed, it is in which state?

  • Active

  • Partially Committed

  • Failed

  • Aborted

There are 10 questions to complete.

Take a part in the ongoing discussion