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.)
Exam 1z0-082 All QuestionsBrowse all questions from this exam
Question 66
Correct Answer: A, D
The SQL statement updates the EMPLOYEES table by setting the JOB_ID and SALARY of employee 100 to be the same as those of employee 200. Therefore, Employee 100 will have the SALARY set to the same value as Employee 200, and Employee 100 will have the JOB_ID set to the same value as Employee 200. Employees 200's data remains unchanged.
Discussion
danitoOptions: AD
A D the correct options
Ekos
i agree
you1234Options: AD
A & D is correct
Oracle2020Options: AD
AD The correct options Example : CREATE TABLE EMPLOYES (EMP_ID NUMBER NOT NULL, EMP_NAME VARCHAR2(40), DEPT_ID NUMBER(2), SALARY NUMBER(8,2), JOIN_DATE DATE); insert into employes VALUES (1,'RICARDO',01,1200,'01/03/2024'); insert into employes values (2,'FERNANDO',02,1500,'01/02/2024'); update employes set (dept_id,salary)= (select dept_id,salary from employes where emp_id=2) where emp_id=1; This has updated the value of the salary and dept_id (equivalent to job_id) of employee 1 (equivalent to 100) by the value of employee 2 (equivalent to 200)
guimaleoOptions: AD
Tested in my own database
auwiaOptions: AD
Provided answer are wrong. The base! :-) Part IV
fthusaOptions: AD
AD are correct
algerianphoenixOptions: AD
AD, Employee 100 will have Employee 200 data ...
ryuahOptions: AD
A,D is correct
GuhborgesOptions: AD
A D the correct!