[单选]
Click the Exhibit button and examine the data in the EMPLOYEES table.
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.
Evaluate this DELETE statement:
DELETE employee_id, salary, job_id
FROM employees
WHERE dept_id = 90;
Why does the DELETE statement fail when you execute it?（）

A . There is no row with dept_id 90 in the EMPLOYEES table.
B . You cannot delete the JOB_ID column because it is a NOT NULL column.
C . You cannot specify column names in the DELETE clause of the DELETE statement.
D . You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

城市公共交通按规划期限划分为哪三个层次？程某因违反治安管理被公安机关处以1500元罚款，超过缴纳期限后程某仍拒不缴纳罚款。根据《治安管理处罚法》和《行政处罚法》的规定，公安机关可以（）改处拘留，罚款仍需执行。逾期1日，加处45元罚款。将依法扣押的财物拍卖抵缴罚款。申请人民法院强制执行。试述心理购买动机的构成与特点？某20层办公楼，建筑面积32000㎡，总高度71m，钢筋混凝土框架一剪力墙结构，脚手架采用悬挑钢管脚手架，外挂密目安全网，以塔式起重机作为垂直运输工具，2011年11月9日在15层结构施工时，吊运钢管时钢丝绳滑扣，起吊离地20m后，钢管散落，造成下方作业的4名人员死亡，2人重伤。经事故调查发现：（1）作业人员严重违章，起重机驾驶员因事请假，工长临时指定一名机械工操作塔式起重机，钢管没有捆扎就托底兜着吊起，而且钢丝绳没有在吊钩上挂好，只是挂在吊钩的端头上。（2）专职安全员在事故发生时不在现场。（3）作业前，施工单位项目技术负责人未详细进行安全技术交底，仅向专职安全员口头交代了施工方案中的安全管理要求。针对现场伤亡事故，项目经理应采取哪些应急措施？ You issue these LSNRCTL commands： LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02 What is the result of issuing these commands？（） A listener named LISTENER is started.。 A listener named LISTENER01 is started.。 A listener named LISTENER02 is started.。 The START command fails and no listener is started.。

Click the Exhibit button and examine the data in the EMPLOYEES table.
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.
Evaluate this DELETE statement:
DELETE employee_id, salary, job_id
FROM employees
WHERE dept_id = 90;
Why does the DELETE statement fail when you execute it?（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

相关题目: