Question

The problem of an update affecting the execution of a query associated with the update is known as the _________

(a) Updation problem

(b) Incremental problem

(c) Halloween problem

(d) Optimization problem

The question was posed to me by my college professor while I was bunking the class.

Enquiry is from Materialized Views and Advanced Topics in Query Optimization topic in section Query Processing and Optimization of RDBMS

Answer 1

Correct answer is (c) Halloween problem

For explanation I would say: The problem of an update affecting the execution of a query associated with the update is known as the Halloween problem. This was because it was first recognized on the Halloween day at IBM.