Oracle Exam 1Z0-082 Topic 3 Question 107 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 107
Topic #: 3

[All 1Z0-082 Questions]

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

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

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

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

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

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

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

Show Suggested Answer

Suggested Answer: C

by Tegan at Oct 21, 2024, 07:47 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

I agree with Marisha. Option C seems correct based on the information provided.

upvoted 0 times

...

3 days ago

I think option C is true because the statement mentions that the SALARY column is being updated.

upvoted 0 times

...