试题详情
- 单项选择题 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.
- B
关注下方微信公众号，在线模考后查看
热门试题
- 如果允许用户对视图进行更新和插入操作，但
- A subquery can be us
- Examine this&e
- You included&e
- You want
- Which two̳
- Which data dictionar
- You are i
- Given： What is
- You are
- Which three statemen
- Which two are true a
- DRAGDROPClicktheTask
- Which three
- Which of the followi
- Given： And the
- You want
- 下面不是常用的数据对象权限的是（）。
- You wish to enable
- You createQ