Oracle
1Z0-047 · Question #115
View the Exhibit and examine the description of the EMPLOYEES table. You want to know the EMPLOYEE_ID and FIRST_NAME of all the records in the EMPLOYEES table wherein the JOB_ID column has ST_CLERK…
The correct answer is D. SELECT employee_id, first_name. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the description of the EMPLOYEES table. You want to know the EMPLOYEE_ID and FIRST_NAME of all the records in the EMPLOYEES table wherein the JOB_ID column has ST_CLERK or ST_MAN values, the DEPARTMENT_ID column has value 30, and the SALARY column has a value greater than 3,000. Which SOL statement would get you the desired result?
Exhibit
Options
- ASELECT employee_id, first_name
- BSELECT employee_id, first_name
- CSELECT employee_id, first_name
- DSELECT employee_id, first_name
How the community answered
(27 responses)- A4% (1)
- B4% (1)
- C11% (3)
- D81% (22)
Community Discussion
No community discussion yet for this question.