Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB

Oracle 1z0-071 Question Answer

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.

Only the EMPLOYEES_ID column is indexed.

Rows exist for employees 100 and 200.

Examine this statement:

UPDATE employees

SET (job_id, salary) =

(SELECT job_id, salary

FROM employees

WHERE employee_id = 200)

WHERE employee id=100;

Which two statements are true?

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

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

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

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

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

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

1z0-071 PDF/Engine

Get 60% Discount on All Products, Use Coupon: "8w52ceb345"

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.