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 four-digit values for all rows. Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

Question

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 four-digit values for all rows. Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

Accepted Answer

A. PROD_NAMEsize can be increased from five to 10 characters. C. PROD_RATEsize can be changed from NUMBER(4) to NUMBER(6, 2).

Answer

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

Answer

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

Answer

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

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…

Question

Options

How the community answered

Community Discussion