Oracle
1Z0-007 · Question #174
1Z0-007 Question #174: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #174. The question stem and answer options stay visible for context.
Question
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?
Exhibit
Options
- 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.
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.