AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z1-051





Question ID 4892

EMPLOYEES and DEPARTMENTS data:
EMPLOYEES
EMPLOYEE_ID
EMP_NAME
DEPT_ID
MGR_ID
JOB_ID
SALARY
101 Smith
20
120 SA_REP
4000
102
Martin 10
105
CLERK
2500
103 Chris
20
 
120
IT ADMIN
4200
104 John
30
108
HR_CLERK 2500
105 Diana
30
108
IT ADMIN
5000
106 Smith
40
110 AD ASST 3000 108 Jennifer
30
110 HR_DIR
6500
110
Bob
40
EX_DIR
8000 120 Ravi 20
110 SA_DIR
6500
DEPARTMENTS
DEPARTMENT_ID
DEPARTMENT_NAME
10
Admin
20
Education
30
IT
40
Human Resources
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID.
On the DEPARTMENTS table DEPARTMENT_ID is the primary key.
 
Evaluate this UPDATE statement.
UPDATE employees
SET mgr_id =
(SELECT mgr_id
FROMemployees
WHERE dept_id=
(SELECT department_id
FROM departments
WHERE department_name = 'Administration')),
Salary = (SELECT salary
FROM employees
WHERE emp_name = 'Smith')
WHERE job_id = 'IT_ADMIN';
What happens when the statement is executed?
 

Option A

A.    The statement executes successfully, leaves the manager ID as the existing value, and changes the salary to 4000 for the employees with ID 103 and 105.
 

Option B

B.    The statement executes successfully, changes the manager ID to NULL, and changes the salary to 4000 for the employees with ID 103 and 105.
 

Option C

C.    The statement executes successfully, changes the manager ID to NULL, and changes the
salary to 3000 for the employees with ID 103 and 105.
 

Option D

D.    The statement fails because there is more than one row matching the employee name Smith.
 

Option E

E.    The statement fails because there is more than one row matching the IT_ADMIN job ID in the
EMPLOYEES table.
 

Option F

F.    The statement fails because there is no 'Administration' department in the DEPARTMENTS
table.
 

Correct Answer D
Explanation


Question ID 4893

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?
 

Option A

A.    SELECT &1, "&2"
FROM &3
WHERE last_name = '&4';
 

Option B

B.    SELECT &1, '&2'
FROM &3
WHERE '&last_name = '&4' ';
 

Option C

C.    SELECT &1, &2
FROM &3
WHERE last_name = '&4';
 

Option D

D.    SELECT &1, '&2'
FROM EMP
WHERE last_name = '&4';
 

Correct Answer C
Explanation

Send email to admin@getfreedumps for new dumps request!!!