SQL and PL/SQL Question:

Download Job Interview Questions and Answers PDF

What is Synonyms?

SQL and PL/SQL Interview Question
SQL and PL/SQL Interview Question

Answer:

Synonyms is the alias name for table, views, sequences & procedures and are created for reasons of Security and Convenience.
Two levels are Public - created by DBA & accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifying the owner and Flexibility to customize a more meaningful naming convention.

Download SQL and PL/SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is Sequences?What is Indexes?