Oracle
1Z0-061 · Question #170
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…
The correct answer is C. CREATE PUBLIC SYNONYM EDL_VU. The general syntax to create a synonym is: CREATE [PUBLIC] SYNONYM synonym FOR object;
Creating Other Schema Objects
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
How the community answered
(36 responses)- B3% (1)
- C81% (29)
- D11% (4)
- F6% (2)
Explanation
The general syntax to create a synonym is: CREATE [PUBLIC] SYNONYM synonym FOR object;
Topics
#PUBLIC SYNONYM#CREATE SYNONYM#schema objects#privileges
Community Discussion
No community discussion yet for this question.