Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

View the exhibit

and examine the structure of the PRODUCTS table.
The PRODUCTS table contains 20 rows.
In the data that has been entered, the PROD_ID column contains only single digit values,
PROD_NAMKhas a maximum of 5 characters, and RATE has 4 digit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure
of the PRODUCTS table? (Choose two.)

View the exhibit

and examine the structure of the PRODUCTS table.
The PRODUCTS table contains 20 rows.
In the data that has been entered, the PROD_ID column contains only single digit values,
PROD_NAMKhas a maximum of 5 characters, and RATE has 4 digit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure
of the PRODUCTS table? (Choose two.)

A.
PROD_NAME size can be reduced from 10 to 5 characters.

B.
PROD_IP can be changed from CHAR to NUMBER data type.

C.
Now columns can be added only if they have NOT NULL constraint.

D.
PROD_RATE size can be changed from NUMBER (4) to NUMBER (6, 2).

E.
None of the existing columns can be dropped because they contain data.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *