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

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Elke

11 days ago

Hmm, looks like an update statement targeting the EMPLOYEES table. I think A and C are the correct answers, since the update sets the SALARY of employee 100 to the same value as employee 200, and vice versa.

upvoted 0 times

...

Garry

20 days ago

I'm not sure about option C. I think option F might also be true because the SALARY column is being updated for both employees.

upvoted 0 times

...

Felix

23 days ago

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

upvoted 0 times

...

Marisha

24 days ago

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

upvoted 0 times

...