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:

Dividends In Arrears

Due dividends on cumulative preferred stock that have not been paid in the period they were due.

Preferred Dividends

Dividends that are paid to preferred shareholders, typically at a fixed rate, before any dividends are paid to common shareholders.

Treasury Stock

Shares bought back by the issuing company, reducing the amount of outstanding stock on the open market.

Corporate Stock

Equity securities representing ownership shares in a corporation, entitling shareholders to dividends and a claim on assets and earnings.