可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Click the Exhibit button and examine


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

  • AThere is no row with dept_id 90 in the EMPLOYEES table.
  • BYou cannot delete the JOB_ID column because it is a NOT NULL column.
  • CYou cannot specify column names in the DELETE clause of the DELETE statement.
  • DYou cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、Click the Exhibit button to examine t

Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement:SELECT e.employee_id "Emp_id", e.emp_name "Employ...

2、Click the Exhibit button and examine

Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? ()ASELECT * FROM employees where salary > (...

3、Click the Exhibit button and examine

Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Which SQL statement retrieves the order ID, customer ID, and...

4、Click the Exhibit button. What is the

Click the Exhibit button. What is the result?()A4321B0000CAn exception is thrown at runtime.DCompilation fails because of an error in line 18.

5、Click the Exhibit button and examine

Click the Exhibit button and examine the data from the EMP table.The COMMISSION column shows the monthly commission earned by the employee.Which...

6、Click the Exhibit button to examine t

Click the Exhibit button to examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Two new departments are added to your comp...