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 4896

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES
EMPLOYEE_IDNUMBERPrimary Key
FIRST_NAMEVARCHAR2 (25) LAST_NAMEVARCHAR2 (25) HIRE_DATEDATE
NEW EMPLOYEES
EMPLOYEE_IDNUMBERPrimary Key NAMEVARCHAR2 (60)
Which DELETE statement is valid?
 

Option A

A.    DELETE FROM employees
WHERE employee_id = (SELECT employee_id FROM employees);
 

Option B

B.    DELETE * FROM employees
WHERE employee_id = (SELECT employee_id FROM new_employees);
 

Option C

C.    DELETE FROM employees
WHERE employee_id IN(SELECT employee_id FROM new_employees
WHERE name = 'Carrey');
 

Option D

D.    DELETE * FROM employees
WHERE employee_id IN (SELECT employee_id
FROM new_employees
WHERE last_name = 'Carrey');
 

Correct Answer C
Explanation


Question ID 4897

Examine the structure of the EMP_DEPT_VU view:
Column Name Type Remarks
EMPLOYEE_ID NUMBER From the EMPLOYEES table
EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table
SALARY NUMBER From the EMPLOYEES table
DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table
Which SQL statement produces an error?
 

Option A

A.    SELECT *
FROM emp_dept_vu;
 

Option B

B.    SELECT department_id, SUM(salary) FROM emp_dept_vu
GROUP BY department_id;
 

Option C

C.    SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu
GROUP BY department_id, job_id;
 

Option D

D.    SELECT job_id, SUM(salary) FROM emp_dept_vu
WHERE department_id IN (10,20) GROUP BY job_id
HAVING SUM(salary) > 20000;
 

Option E

E.    None of the statements produce an error; all are valid.
 

Correct Answer E
Explanation

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