1Z0-061 · Question #206
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…
The correct answer is B. A change to the DEFAULT value affects only subsequent insertions to the table. A change to the DEFAULT value affects only subsequent insertions to the table. Existing rows will not be affected. Incorrect Answers A:. Column definitions can be altered to add DEFAULT values. C:. Column definitions can be altered to add DEFAULT values. It works for columns…
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.
How the community answered
(17 responses)- A18% (3)
- B71% (12)
- C6% (1)
- D6% (1)
Explanation
A change to the DEFAULT value affects only subsequent insertions to the table. Existing rows will not be affected. Incorrect Answers A:. Column definitions can be altered to add DEFAULT values. C:. Column definitions can be altered to add DEFAULT values. It works for columns with a NUMBER data type also. D:. A change to the DEFAULT value affects only subsequent insertions to the table. Existing rows will not be affected.
Topics
Community Discussion
No community discussion yet for this question.