Oracle
1Z0-061 · Question #206
1Z0-061 Question #206: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #206. The question stem and answer options stay visible for context.
Question
The EMPLOYEES table has these columns: LAST NAME. VARCHAR2(35) SALARY. NUMBER(8, 2) HIRE_DATE. DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); What is true about your ALTER statement?
Options
- AColumn definitions cannot be altered to add DEFAULT values.
- BA change to the DEFAULT value affects only subsequent insertions to the table.
- CColumn definitions cannot be altered at add DEFAULT values for columns with a NUMBER data
- DAll the rows that have a NULL value for the SALARY column will be updated with the value 5000.
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 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.