Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SYNONYM and ALIAS?
- 6 Answers
- 28638 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / asr
SYNONYM - 1)It is a private object.
2)Only user who created it,can access it.
3)When the base table is dropped,automatically
sunonym wll drop.
4)SYSADM authority is not needed to create synonym
ALIAS - 1)It is a global object.
2)Any user can access it.
3)When the base table is dropped,automatically
sunonym wll not drop.
4)SYSADM authority is needed to create synonym
| Is This Answer Correct ? | 18 Yes | 7 No |
Post New Answer View All Answers
Can there be more than one cursor open for any program?
What are catalog tables in db2?
What is db2? Explain.
What is a bind card?
What do you mean by rollback?
How does db2 sample database connect?
What is db2 command?
What is image copy in db2?
What are the bind parameters ibm db2?
What is db2 optimizer?
Explain the benefits you can get from mainframe connect?
How do I start db2 in windows?
What type of database is db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is reorg?
