The EMPLOYEES table has these columns: LAST NAMEVARCHAR2(35)
SALARYNUMBER(8,2) HIRE_DATEDATE 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?
A.
Column definitions cannot be altered at add DEFAULT values for columns with
aNUMBER data type.
B.
All the rows that have a NULL value for the SALARY column will be updated with the
value 5000.
C.
Column definitions cannot be altered to add DEFAULT values.
D.
A change to the DEFAULT value affects only subsequent insertions to the table.
Explanation:
D