欢迎来到在线考试题库网 在线考试题库官网
logo
全部科目 > Oracle认证考试 > 1Z0-007

单项选择题

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?()

    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 at 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.

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题