Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SYNONYM and ALIAS?
- 6 Answers
- 28966 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
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What are foreign keys in db2?
How is deadlock resolved?
What is null value in db2?
What is the difference between using bind () and rebind () methods of naming class?
What is the max length of sqlca?
How do I start db2 in windows?
What is rct?
What is db2 stogroup?
What is the physical storage length of date data type?
Is db2 a mainframe?
How to retrieve rows from a db2 table in embedded sql?
What are the various isolation levels possible?
How can you find out the # of rows updated after an update statement?
How to find the number of rows in db2 tables?
