What is Synonyms?
Submitted by: AdministratorSynonyms 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online SQL and PL/SQL Job Interview Questions And Answers
Top SQL and PL/SQL Questions
☺ | The IN operator may be used if you know the exact value you want to return for at least one of the columns. |
☺ | What is the use of CASCADE CONSTRAINTS? |
☺ | What is Posting? |
☺ | What is Character Functions? |
☺ | What is the SQL? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |