Oracle
1Z0-007 · Question #66
1Z0-007 Question #66: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #66. The question stem and answer options stay visible for context.
Question
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?
Options
- ASELECT COUNT(*) FROM employees WHERE last_name='Smith';
- BSELECT COUNT (dept_id) FROM employees WHERE last_name='Smith';
- CSELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
- DSELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
- ESELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
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.