TomoLink
CompaniesInfosysDatabase ManagementTransactions, Concurrency & ACID
DBMS
Transactions, Concurrency & ACID

Transactions, Concurrency & ACID

dbmstransactionsacid
1 sections
dbms, transactions

MCQ — Transactions & ACID

Q1Easy

What does ACID stand for in database transactions?

Q2Easy

Which property ensures that either all operations of a transaction succeed or none of them are applied?

Q3Medium

Which isolation level allows dirty reads?

Q4Hard

A 'phantom read' occurs when:

Q5Easy

Which isolation level is the strictest and prevents all concurrency anomalies?

Q6Medium

A deadlock occurs when:

Q7Easy

Which lock allows reading but prevents writing?

Q8Medium

Which technique uses timestamps instead of locks for concurrency control?

Q9Medium

In 2-Phase Locking (2PL), the two phases are:

Q10Easy

Which command makes transaction changes permanent?

Dbms Transactions Concurrency Acid | Infosys Dbms | TomoLink