What Does This SQL Command Accomplish? ALTER TABLE PRODUCTS

question 21

Multiple Choice

What does this SQL command accomplish? ALTER TABLE PRODUCTS
ADD CHECK (SIZE IN ('S', 'M', 'L', 'XL', 'XXL') ) ;

• A) updates all values in the SIZE column
• B) adds a parent-child constraint to the PRODUCTS table
• C) establishes a foreign key for the PRODUCTS table
• D) establishes legal values for the SIZE column

---

Definitions:

Carrying Value

The monetary value of an asset as recorded on the balance sheet, taking into account factors like depreciation or amortization.

Face Value

The nominal or dollar value printed on a financial instrument, such as a bond or stock certificate.

Premium

The amount paid for an insurance policy or the amount by which a bond or stock sells above its par value.

Straight-Line Amortization

A method of calculating equal amortization payments over an asset's useful life or a loan's term.