Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SYNONYM and ALIAS?
- 6 Answers
- 29177 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 is the difference between drop table and delete table?
Why do we bind in db2?
What is difference between rollback and commit?
Is db2 free?
When reorg is used?
what is the role of the cursor in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How is a typical db2 batch pgm executed?
What are the contents of dclgen?
What language is db2 written in?
Give a brief description of db2 isolation levels?
What is dbrm?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is a system catalog table in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
