The EMPLOYEES table has these columns:LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATEManagement 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);Which is true about your ALTER statement?（）

A、Column definitions cannot be altered to add DEFAULT values.

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

C、Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

互联网编程 通信类考试 软考考试 项目管理 计算机等级考试 教师资格证 房产评估考试 人资类 社会工作 法考 职业资格考试 外贸考试 特种作业 交规类 导游证考试