Oracle
1Z0-007 · Question #123
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 and Managing 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
(32 responses)- B6% (2)
- C78% (25)
- D13% (4)
- F3% (1)
Explanation
The general syntax to create a synonym is: CREATE [PUBLIC] SYNONYM synonym FOR object;
Topics
#CREATE PUBLIC SYNONYM#synonyms#schema objects#DDL
Community Discussion
No community discussion yet for this question.