|
Explanation: Correct syntax to create a local synonym is CREATE SYNONYM synonym_name. With PUBLIC keyword you can create public synonym. Incorrect Answers: 1: There is no PRIVATE keyword for the CREATE SYNONYM command. 3: There is no LOCAL keyword for the CREATE SYNONYM command. 4: This SQL statement shows incorrect syntax to create a synonym. 5: Synonyms can be created not only for tables but for other objects also. 6: Scott can create synonym for Mary’s view because she granted SELECT privilege to Scott on this view. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 331-335 Chapter 7: Creating Other Database Objects in Oracle
|