What is the difference between SYNONYM and ALIAS?
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 the rules for db2 programming?
What is the purpose of using commit?
How to find the number of rows in db2 tables?
Why db2 is called db2?
What is catalog database in db2?
How to connect to db2 database from windows command line?
What does db2 plan contain?
How can deadlocks be resolved?
What does db2 blu stand for?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do I delete a table in db2?
How to find primary key of a table in db2?
What os does db2 run on?
What is the information associated with sysibm.syslinks table?