1z0-061 Exam Dumps | User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and

Valid 1z0-061 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-061 Exam! ExamDiscuss.com now offer the newest 1z0-061 exam dumps, the ExamDiscuss.com 1z0-061 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-061 dumps with Test Engine here:

Access 1z0-061 Dumps Premium Version
(340 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 143/150

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?

A. CREATE PUBLIC SYNONYM EDL_VU. ON emp_dept_loc_vu;

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

C. CREATE PUBLIC SYNONYM EDL_VU. FOR emp_dept_loc_vu;

D. CREATE SYNONYM EDL_VU. ON emp_dept_loc_vu. FOR EACH USER;

E. CREATE SYNONYM EDL_VU. FOR EACH USER. ON emp_dept_loc_vu;

F. CREATE PUBLIC SYNONYM EDL_VU. ON emp_dept_loc_vu. FOR ALL USERS;

Question 143/150

LEAVE A REPLY

Download PDF File