Oracle
1Z0-497 · Question #14
1Z0-497 Question #14: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-497 to reveal the answer and full explanation for question #14. The question stem and answer options stay visible for context.
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?
Options
- APROD_NAMEsize can be increased from five to 10 characters.
- BPROD_IDcan be changed from CHAR to NUMBER data type.
- CPROD_RATEsize can be changed from NUMBER(4) to NUMBER(6, 2).
- DNew columns can be added only if they have a NOT NULL constraint.
- ENone of the existing columns can be dropped because they contain data.
Unlock 1Z0-497 to see the answer
You've previewed enough free 1Z0-497 questions. Unlock 1Z0-497 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.