Oracle
1Z0-071 · Question #338
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEE_ID column is indexed. Rows exist for employees 100 and 200. Examine this statement: Which two statements…
The correct answer is B. Employees 100 will have JOB_ID set to the same value as the JOB_ID of employee 200 E. Employee 100 will have SALARY set to the same value as the SALARY of employee 200. See the full explanation below for the reasoning.
Question
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEE_ID column is indexed. Rows exist for employees 100 and 200. Examine this statement:
Which two statements are true? (Choose two.)
Exhibit
Options
- AEmployees 100 and 200 will have the same JOB_ID as before the update command
- BEmployees 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
- CEmployees 100 and 200 will have the same SALARY as before the update command
- DEmployee 200 will have SALARY set to the same value as the SALARY of employee 100
- EEmployee 100 will have SALARY set to the same value as the SALARY of employee 200
- FEmployee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
How the community answered
(31 responses)- A13% (4)
- B74% (23)
- C3% (1)
- D6% (2)
- F3% (1)
Community Discussion
No community discussion yet for this question.