You have the privileges to create any type of synonym.
Which stalement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accesible to all users?
CREATE GLOBAL SYNONYM emp FOR hcm.employee_records;
CREATE SYNONYM emp FOR hcm.employee_records;
CREATE SYNONYM PUBLIC.emp FOR hcm.employee_records;
CREATE SYNONYM SYS.emp FOR hcm.employee_records;
CREATE PUBLIC SYNONYM emp FOR hcm. employee_records;
Synonyms in Oracle are aliases for database objects that can simplify SQL statements for database users.
A. The term "GLOBAL" is not used in the creation of synonyms in Oracle.
B. The statement without the keyword PUBLIC will create a private synonym that is only accessible to the user creating the synonym, not all users.
C. The correct syntax does not include PUBLIC as a prefix to the synonym name itself, making this option incorrect.
D. You cannot specify the SYS schema for creating synonyms, as it is reserved for system objects.
E. This is the correct syntax to create a public synonym, which makes the underlying object accessible to all users.
References:
Oracle Database SQL Language Reference, 12c Release 1 (12.1): "CREATE SYNONYM"
Submit