A Lock Arising from a SELECT

question 136

Multiple Choice

A lock arising from a SELECT...FOR UPDATE command will be released when ____.​

• A) ​a COMMIT command is executed
• B) ​a ROLLBACK command is executed
• C) ​an implicit commit occurs
• D) ​all of the above

---

Definitions:

Consumption Bundle

A set of goods or services that a consumer considers purchasing with a given budget.

Horizontal Axis

In a graph or chart, the x-axis, which typically represents the independent variable or the base measure for comparative analysis.

Indifference Curve

A graph that shows a combination of two goods that give a consumer equal satisfaction and utility, thereby making the consumer indifferent between the two combinations.

Consumption Bundle

A specific mix of goods and services that a consumer chooses to consume, reflecting the consumer's preferences and budget constraints.