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

Examine the table:
Table name: PRODUCTS
Schema: SCOTT
Tablespace: USERS

Organization: Standard (Heap Organized)
This table contains 20 rows. In the data that has been entered, the PROD_IDcolumn contains only
single-digit values, PROD_NAMEhas a maximum of five characters, and PROD_RATEhas fourdigit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure
of the PRODUCTS table?

Examine the table:
Table name: PRODUCTS
Schema: SCOTT
Tablespace: USERS

Organization: Standard (Heap Organized)
This table contains 20 rows. In the data that has been entered, the PROD_IDcolumn contains only
single-digit values, PROD_NAMEhas a maximum of five characters, and PROD_RATEhas fourdigit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure
of the PRODUCTS table?

A.
PROD_NAMEsize can be increased from five to 10 characters.

B.
PROD_IDcan be changed from CHAR to NUMBER data type.

C.
PROD_RATEsize can be changed from NUMBER(4) to NUMBER(6, 2).

D.
New columns can be added only if they have a NOT NULL constraint.

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



Leave a Reply 2

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


benji

benji

AC are corrects