Oracle
1Z0-514 · Question #1
1Z0-514 Question #1: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-514 to reveal the answer and full explanation for question #1. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-514 to see the answer
You've previewed enough free 1Z0-514 questions. Unlock 1Z0-514 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.