One of Eden's customers has closed his account and moved to a different state.She needs to change his status to Inactive.What SQL command will accomplish this task?

A) DELETE
B) INSERT
C) SELECT
D) UPDATE

Question

Tachana Upapong · Accepted Answer

Final Answer : D, Explanation :  The UPDATE command can modify an existing record in the database. We can use it to change the status of the customer to inactive without deleting the record completely, which may still be useful for historical purposes.

One of Eden's customers has closed his account and moved to a different state.She needs to change his status to Inactive.What SQL command will accomplish this task?

A) DELETE
B) INSERT
C) SELECT
D) UPDATE

Definitions

Learning Objectives

Learning Objectives

Related questions

One of Eden's customers has closed his account and moved to a different state.She needs to change his status to Inactive.What SQL command will accomplish this task?A) DELETEB) INSERTC) SELECTD) UPDATE

Definitions

Learning Objectives

Learning Objectives

Related questions

One of Eden's customers has closed his account and moved to a different state.She needs to change his status to Inactive.What SQL command will accomplish this task?

A) DELETE
B) INSERT
C) SELECT
D) UPDATE