Which Keywords Create a Shared Lock on a Table to Prevent

question 20

Multiple Choice

Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns?​

• A) ​SELECT...LOCK
• B) ​SELECT...COMMIT
• C) ​SELECT...FOR UPDATE
• D) ​SELECT...FOR CHANGE

---

Definitions:

Research Development

The systematic activity combining both basic and applied research, aimed at discovering solutions to problems or creating new goods and knowledge.

Fixed Overhead Rate

A predetermined rate used to assign fixed manufacturing overhead costs to products, typically based on a standard activity level.

Volume Variance

A deviation in manufacturing or procurement costs that arises when the actual volume of production differs from the expected volume.

Productive Capacity

Productive capacity refers to the maximum output a system, facility, or economy can achieve under ideal conditions over a specific time period.