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

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

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Answer

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

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…

Question

Exhibit

Options

How the community answered

Topics

Community Discussion