问题

Examine the data in the EMPLOYEES tab

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

参考答案

参考解析：

分类：1Z0-007题库

相关推荐

1、Examine the data from the ORDERS and

Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed?（）ABCD The quer...

2、Examine the data in the EMPLOYEES and

Examine the data in the EMPLOYEES and EMP_HIST tables:The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID,...

3、Examine the data in the EMPLOYEES tab

Examine the data in the EMPLOYEES table:Which three subqueries work? （）A SELECT * FROM employees where salary > (SELECT MIN(salary) FROM emplo...

4、Examine the data of the EMPLOYEES tab

Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)E...

5、Examine the data of the EMPLOYEES tab

Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)W...

6、Exhibit: Examine the data in the EMP

Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGR...

编辑推荐

聚合反应..

某验船师在对一条2013年5月18日开工的内河货船进行建造检验时.....

根据支持物的不同，层析技术可分为柱层析，纸层析和（）层析。..

在纤芯内折射率不随半径变化而变化，有一恒定值n1.在纤芯-包.....

“齐大非偶”是用来推托什么的词语？..

上颌窦恶性肿瘤常容易侵犯（）..