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:

Preferred Stock

Preferred Stock represents a class of ownership in a corporation that has a higher claim on assets and earnings than common stock, often including fixed dividends.

Common Stock

A form of corporate equity ownership, a type of security that represents ownership in a corporation and a claim on part of the company's profits.

Fair Market Value

The cost at which a property would be exchanged in a competitive bidding environment.

Incorporation Services

Services offered by certain companies or legal entities that assist individuals or other entities in forming a corporation.