In concurrency control, the 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 predicate a transaction has already read, so re-running the query returns extra 'phantom' tuples.More Database Management Systems questions
- Which of the following is/are FALSE statement(s)? A. An all-key relation is always in BCNF since it has no FDs. B. A relation that is not i…
- Which of the following commands can be used to modify data in an SQL table? A. INSERT B. DELETE C. UPDATE D. SELECT Choose the correct answ…
- Which of the following tables contains the primary information in a data warehouse?
- The INSERT command is used to A. add a single tuple to a relation B. add multiple tuples to a relation C. add values to specific attributes…
- Match List I with List IIList I List II A. Hadoop Distributed File System I. Trust B. Veracity II. Facebook C. Apache Pig III. Name-Node D.…
- The degree of a relation in a database is