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.)
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
C.
Employee 200 will have SALARY set to the same value as the SALARY of employee 100
D.
Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
E.
Employees 100 and 200 will have the same JOB_ID as before the update command
F.
Employees 100 and 200 will have the same SALARY as before the update command
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)
This section is not available anymore. Please use the main Exam Page.1z0-082 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
danito
Highly Voted 4 years, 11 months agoEkos
4 years, 4 months agoyou1234
Highly Voted 4 years, 10 months agoEddieY
Most Recent 7 months, 3 weeks agoOracle2020
1 year, 1 month agoguimaleo
1 year, 2 months agoauwia
1 year, 10 months agofthusa
1 year, 11 months agoalgerianphoenix
2 years, 11 months agoryuah
3 years, 3 months agoGuhborges
3 years, 5 months ago