Question :
In SQL, which command(s) is(are) used to create a synonym for a schema object?
Option 1: CREATE SCHEMA
Option 2: CREATE SYNONYM
Option 3: CREATE SAME
Option 4: None of the above
Correct Answer: CREATE SYNONYM
Solution : You need to have the CREATE ANY SYNONYM system access in order to create a private synonym in another user's schema. You need to have the CREATE PUBLIC SYNONYM system privilege in order to create a PUBLIC synonym. If a synonym already exists, enter OR REPLACE to create it.
Hence the correct answer is option 2.




