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:

80th Percentile

A value below which 80 percent of the data in a data set falls, indicating the upper 20% of values.

Mean

The average of a set of numbers, calculated by summing all numbers in the set and then dividing by the count of numbers.

Standard Normal

A special case of the normal distribution with a mean of zero and a standard deviation of one.

Random Variable

A random variable is a variable whose values depend on outcomes of a random phenomenon, used in probability and statistics to model real-world processes.