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: