Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SYNONYM and ALIAS?
- 6 Answers
- 28944 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
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is cursor stability in db2?
What language is db2 written in?
Which is faster delete or truncate?
What's The Error Code For Unique Index Voilation?
What is a db2 table?
What is sqlca?
What does db2 mean?
Mention data types used in db2 ?
What is reorg and runstats in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Is it possible using max on a char column?
Mention the location where the output received from explain statement is stored.
What is db2 connect?
What is dbrm library?
