Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 75

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.)

Employees 100 and 200 will have the same SALARY as before the update command.

Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200.

Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100.

Employees 100 and 200 will have the same JOB_ID as before the update command.

Employee 100 will have SALARY set to the same value as the SALARY of employee 200.

Employee 200 will have SALARY set to the same value as the SALARY of employee 100.

Correct Answer: B, E

Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200. This is because the statement updates the JOB_ID of employee 100 to the JOB_ID of employee 200 as specified in the sub-query. Similarly, employee 100 will also have SALARY set to the same value as the SALARY of employee 200. Therefore, options B and E are correct.

Discussion

lucemqyOptions: BE

Inner query is run first then update query is ran

HassanMkhlalatiOptions: BE

BE Correct

NelitaOptions: BE

BE ARE CORRECT.