ExamQuestions.com

Register
Login
Oracle Database 12c Essentials Exam Questions

Oracle

Oracle Database 12c Essentials

29 / 80

Question 29:

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_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has 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? 

Answer options:

A. PROD_NAME size can be increased from five to 10 characters.
B. PROD_ID can be changed from CHAR to NUMBER data type.
C. PROD_RATE size 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.