SQL (Structured Query Language) Question:
Download Job Interview Questions and Answers PDF
What is sql Synonyms?
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.
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 Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain Order of SQL statement execution? | What is sql Multiple columns? |