In concurrency control, phantom problem may occur, when-
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. records are inserted
Explanation
A phantom appears when another transaction inserts new rows that satisfy a query's condition, so re-running the query returns extra rows.
More Database Management Systems questions
- Match the LIST-I with LIST-II
- The degree of a relation in database is
- Match List I with List II. List I: A. Project Join Normal Form, B. The lost update problem, C. Discretionary Access Control, D. Data Manipu…
- Consider transactions T1: r1(x); r1(z); w1(z) T2: r2(y); r2(z); w2(z) T3: r3(y); r3(x); w3(y), and schedules S1: r1(x); r3(y); r3(x); r2(y)…
- Arrange the following phases of database design in the correct order : (A) Physical Design (B) Conceptual Design (C) Logical Design (D) Req…
- Which of the following statements is/are false? A. A user can assign privileges to any user on any relation. B. A user can assign privilege…