CAF-3 · Chapter 5 · Question 3 of 15
Two customers try to purchase the last available airline ticket at the exact same millisecond. The DBMS ensures that these concurrent transactions do not interfere with each other. This represents which ACID property?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: C) Isolation
Explanation
Isolation ensures that concurrent transactions occur independently without interfering with each other, maintaining data accuracy
More Types of DBMS MCQs
- Q5In a company's database, the HR department has a view showing employee salaries, while the Sales department has a view showing customer…
- Q6Which level of the DBMS architecture acts as the global logical view of the entire database, defining entities, attributes, and…
- Q7The IT department decides to re-index the database and move the data files to a new, faster SSD storage drive. This change does not affect…
- Q8The ability to modify the physical storage mechanisms (like changing hard drives or compressing data) without impacting the logical…
- Q9A database administrator adds a new column, "Customer_Age", to an existing table. This modification to the schema does not break the…