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:

People

Human beings, either individually or collectively, considered within a social or cultural context.

Peace Sign

A symbol or gesture often used to represent peace, anti-war sentiments, or unity, consisting of a circle with three lines radiating downwards.

Gestures

Movements of the body, especially hands and arms, that convey ideas or meanings without using words.

War Protesters

Individuals or groups that openly oppose and actively demonstrate against warfare and military conflicts.