Oracle
1Z0-514 · Question #1
View the exhibit 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…
The correct answer is A. PROD_NAME size can be reduced from 10 to 5 characters. D. PROD_RATE size can be changed from NUMBER (4) to NUMBER (6, 2). See the full explanation below for the reasoning.
Question
View the exhibit 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.)
Exhibit
Options
- APROD_NAME size can be reduced from 10 to 5 characters.
- BPROD_IP can be changed from CHAR to NUMBER data type.
- CNow columns can be added only if they have NOT NULL constraint.
- DPROD_RATE size can be changed from NUMBER (4) to NUMBER (6, 2).
- ENone of the existing columns can be dropped because they contain data.
How the community answered
(36 responses)- A78% (28)
- B6% (2)
- C14% (5)
- E3% (1)
Community Discussion
No community discussion yet for this question.