Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SYNONYM and ALIAS?
- 6 Answers
- 28997 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 consistency token in db2?
How can we retrieve the total number of records in RPG & CLLE?
What r the comman abends in db2, jcl and cobol???????
What is dclgen (declaration generator)?
What is temporal table in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is scrollable cursor in db2?
What is null indicator in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are host variables in db2?
What do you mean by cursor?
What is package in cobol db2?
What is runstats db2?
Can you tell me how can you find out the # of rows updated after an update statement?
