热门：

可学答题网 > 问答 > 1Z0-007题库

目录：标题| 题干| 答案| 搜索| 相关

问题

The EMPLOYEES table has these columns:

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?（）

AColumn definitions cannot be altered to add DEFAULT values.
BA change to the DEFAULT value affects only subsequent insertions to the table.
CColumn definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.
DAll the rows that have a NULL value for the SALARY column will be updated with the value 5000.

参考答案

参考解析：

分类：1Z0-007题库

1、The EMPLOYEE tables has these columns

The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salar...

2、The EMPLOYEE tables has these columns

The EMPLOYEE tables has these columns:You want to display the name and annual salary multiplied by the commission_pct for all employees. For re...

3、The CUSTOMERS table has these columns

The CUSTOMERS table has these columns:CUSTOMER_ID NUMBER(4) NOT NULLCUSTOMER_NAME VARCHAR2(100) NOT NULLSTREET_ADDRESS VARCHAR2(150)CITY_ADDRESS VARCHAR...

4、The ORDERS table has these columns:

The ORDERS table has these columns:The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Whic...

5、The EMP table has these columns: Man

The EMP table has these columns:Management wants a list of names of employees who have been with the company for more than five years. Which...

6、The CUSTOMERS table has these columns

The CUSTOMERS table has these columns:Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）A SELECT custome...

编辑推荐

社会工作是社会者的职业活动，因此社会工作者是社会活动的（）。..

家庭暴力从形式上来看可分为（）三种。..

道口设备故障实行即报即修制度，（）小时内必须修复，确保道.....

周围性肺癌常见细胞类型为..

简述固定翼无人机重心配平方法及位置？..

下列选项中属于个人消费贷款的有（）。..