移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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

发布日期:2022-07-08

The EMPLOYEES table has these columns:LAST_NAME VA...
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.

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

Oracle认证考试

1Z0-007

去刷题
热门试题热门资讯 相关试题