Free Test Transactions and Prope... – Databas...

Q1: What does the "A" in ACID properties stand for?

A. Atomicity B. Availability C. Accuracy D. Access

Q2: What is Atomicity in transactions?

A. Transaction is fully completed or not executed at all B. Data is available always C. Data accuracy is guaranteed D. All transactions are serialized

Q3: What does Consistency mean in ACID?

A. Database remains in a valid state before and after a transaction B. Data is consistent across multiple servers C. Data is backed up regularly D. Users see consistent data

Q4: What does Isolation ensure?

A. Concurrent transactions do not interfere with each other B. All users see the same data C. Data is backed up D. Only one user can access the database

Q5: What does Durability guarantee?

A. Once a transaction commits, changes are permanent even on failure B. Data is consistent C. Transaction isolation is maintained D. Atomicity is preserved

Q6: Which property ensures that a transaction is indivisible?

A. Atomicity B. Consistency C. Isolation D. Durability

Q7: What can happen if Isolation is violated?

A. Dirty reads, lost updates, or inconsistent data B. Improved performance C. Durable commits D. Faster transactions

Q8: Which of the following is NOT an ACID property?

A. Availability B. Durability C. Consistency D. Atomicity

Q9: How is Consistency maintained?

A. By enforcing database constraints and rules B. By logging transactions C. By locking tables D. By backup

Q10: Which isolation level allows dirty reads?

A. Read Uncommitted B. Serializable C. Repeatable Read D. Read Committed

Q11: What is a dirty read?

A. Reading uncommitted data from another transaction B. Reading consistent data C. Writing data twice D. Losing data

Q12: What is the effect of Durability in case of power failure?

A. Committed transactions are not lost B. Data is lost C. Transactions are rolled back D. Transactions fail

Q13: Which of these is an example of an atomic operation?

A. Either all changes of a transaction are applied or none B. Partial updates of a record C. Multiple users accessing data D. Database backup

Q14: What is the main goal of transaction management?

A. To ensure database integrity despite concurrent access and failures B. To backup data C. To improve network speed D. To simplify queries

Q15: Which component manages transaction concurrency in a DBMS?

A. Concurrency control manager B. Query processor C. Storage manager D. Network manager

Q16: What is a rollback?

A. Reversing a transaction to its initial state on failure B. Committing a transaction C. Backing up data D. Deleting a record

Q17: What does serializability ensure?

A. Concurrent transactions produce same effect as some serial execution B. Transactions execute simultaneously C. Transactions are aborted D. Database is locked

Q18: Which of the following is a concurrency anomaly?

A. Lost update B. Data backup C. Transaction commit D. Indexing

Q19: Which of these is a technique to ensure atomicity?

A. Write-ahead logging B. Data encryption C. Query optimization D. Indexing

Q20: What does "commit" mean in a transaction?

A. Making all changes permanent B. Reversing changes C. Starting a transaction D. Backing up data

Quiz for Transactions and Properties (ACID)