Which of the Following SQL Commands Changes the Value in the Column

question 19

Multiple Choice

Which of the following SQL commands changes the value in the column LAST_NAME within the row containing a REP_ID of 007?

• A) UPDATE SALES_REP SET LAST_NAME = 'Bond' WHERE REP_ID = '007';
• B) CHANGE SALES_REP LAST_NAME = 'Bond' WHERE REP_ID = '007';
• C) REPLACE SALES_REP LAST_NAME = 'Bond' WHERE REP_ID = '007';
• D) INSERT SALES_REP SET LAST_NAME = 'Bond' WHERE REP_ID = '007';

---

Definitions:

Technological Imperative

A concept urging that if we have the technological capability to do something, we should do it. Action in the form of the use of an available technology is always preferable to inaction.

Western Societies

Cultures and communities typically found in Western Europe and North America, characterized by democratic political systems, capitalist economies, and specific socio-cultural norms.

Bureaucratized

The process of managing an organization by adhering strictly to fixed rules and formalities.

Hospitalized

The state of being admitted to a hospital for treatment, observation, or care, often due to illness, injury, or surgery.