New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Oracle Database 12c Essentials 1z0-497 Question # 34 Topic 4 Discussion

Oracle Database 12c Essentials 1z0-497 Question # 34 Topic 4 Discussion

1z0-497 Exam Topic 4 Question 34 Discussion:
Question #: 34
Topic #: 4

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?


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.


Get Premium 1z0-497 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.