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 4968

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 employeesWHERE employee_id = (SELECT employee_id FROM employees);
 

Option B

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

Option C

C.    DELETE FROM employeesWHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ‘Carrey’);
 

Option D

D.    DELETE * FROM employeesWHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ‘Carrey’);
 

Correct Answer C
Explanation


Question ID 4969

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.
Which SQL statement can Mary use to accomplish that task?
 

Option A

A.    CREATE PUBLIC SYNONYM EDL VU ON emp_dept_loc_vu;
 

Option B

B.    CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
 

Option C

C.    CREATE PUBLIC SYNONYM EDL VU FOR emp_dept_loc_vu;

 

Option D

D.    CREATE SYNONYM EDL VU ON emp_dept_loc_vu
FOR EACH USER;
 

Option E

E.    CREATE SYNONYM EDL VU FOR EACH USER
ON emp_dept_loc_vu;
 

Option F

F.    CREATE PUBLIC SYNONYM EDL VU ON emp_dept_loc_vu
FOR ALL USERS;

Correct Answer C
Explanation

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