The questions can come in any order, so make sure you are selecting right option for all questions.
1. What term refers to the situation where two or more transactions are executing simultaneously and may interfere with each other's operations?
(b) Concurrency
2. Which of the following is a potential issue that concurrency control helps to address?
(c) Lost updates and data inconsistency
3. Which of the following statements is true regarding the need for concurrency control in a DBMS?
(c) Without concurrency control, transactions may interfere with each other, leading to data integrity issues.
4. What is the main goal of concurrency control mechanisms in a multi-user database environment?
(c) To ensure serializability and maintain data integrity
5. What is the primary purpose of concurrency control in a database management system?
(b) To ensure data consistency in a multi-user environment
6. What is the impact of concurrent access on data in the absence of proper concurrency control?
(c) Potential data anomalies and inconsistencies
7. What is a potential consequence of not implementing concurrency control mechanisms in a database system?
(c) Decreased transaction isolation
8. In a scenario without concurrency control, what problem might arise when two transactions try to update the same data simultaneously?
(b) Improved data consistency
9. Why is concurrency control necessary in a database system?
(c) To prevent data corruption in concurrent transactions