Structure of the CUSTOMERS Table

question 17

Multiple Choice

Structure of the CUSTOMERS table
​
-Which of the following commands will change the name of the LAST NAME column to LAST_NAME in the CUSTOMERS table?​

• A) ALTER TABLE customers MODIFY lastname to last_name;​
• B) ​ALTER TABLE customers CHANGE lastname to last_name;
• C) ​ALTER TABLE customers MODIFY (lastname,last_name);
• D) ​none of the above

---

Definitions:

Promotion Schedule

A planned timeline or criteria set by an organization for the advancement of employees to higher positions or ranks.

Job Title

A designation given to a specific job or position within a company, reflecting the role and responsibilities of the holder.

Job Characteristics Model

A theory that suggests jobs can be designed to enhance employee motivation, satisfaction, and productivity by incorporating five core job dimensions.

Employee Motivation

The intrinsic and extrinsic factors that stimulate workers to take actions that lead to achieving a goal or performing at a high level.