Oracle
1Z0-071 · Question #386
You have the privileges to create any type of synonym. Which statement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accessible to all users?
The correct answer is A. CREATE PUBLIC SYNONIM emp FOR hcm.employee_records. CREATE PUBLIC SYNONYM emp_table https://docs.oracle.com/database/121/SQLRF/statements_7001.htm#SQLRF01401
Creating Other Schema Objects
Question
You have the privileges to create any type of synonym. Which statement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accessible to all users?
Options
- ACREATE PUBLIC SYNONIM emp FOR hcm.employee_records;
- BCREATE GLOBAL SYNONIM emp FOR hcm.employee_records;
- CCREATE SYNONIM emp FOR hcm.employee_records;
- DCREATE SYNONIM PUBLIC.emp FOR hcm.employee_records;
- ECREATE SYNONIM SYS.emp FOR hcm.employee_records;
How the community answered
(22 responses)- A73% (16)
- B5% (1)
- D5% (1)
- E18% (4)
Explanation
CREATE PUBLIC SYNONYM emp_table https://docs.oracle.com/database/121/SQLRF/statements_7001.htm#SQLRF01401
Topics
#PUBLIC synonym#CREATE SYNONYM syntax#schema objects#synonym scope
Community Discussion
No community discussion yet for this question.