Oracle
1Z0-007 · Question #123
1Z0-007 Question #123: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #123. The question stem and answer options stay visible for context.
Question
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?
Options
- ACREATE PUBLIC SYNONYM EDL_VU
- BCREATE PUBLIC SYNONYM EDL:VU
- CCREATE PUBLIC SYNONYM EDL_VU
- DCREATE SYNONYM EDL_VU
- ECREATE SYNONYM EDL_VU
- FCREATE PUBLIC SYNONYM EDL_VU
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.