Question

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?
Select one:
O a. A change to the DEFAULT value affects only subsequent insertions to the table.
O b. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER
data type.
ale talles
O c. Column definitions cannot be altered to add DEFAULT values.
O d. All the rows that have a NULL value for the SALARY column will be updated with the value
5000​

Answer 1

Answer:

A change to the DEFAULT value affects only subsequent insertions to the table.

Explanation: