Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13074 Views
- I also Faced
- E-Mail Answers
Answer Posted / guru
Alias & Synonyms are alternate of table or a view.
ALIAS SYNONYM
1. it is a global object. 1. it is aprivate object.
2. any one can access the 2. but the one who create
alias. the alias can only
access it.
3.when the base table is
droped.Alias is not dropped. 3. when the base table is
droped.SYNONYM is dropped
automatically.
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
Define db2.
How and when does the db2 enforces the unique key?
Explain in brief how does db2 determine what lock-size to use?
What is runstats utility in db2?
What are iseries servers?
Define declaration generator (dclgen).
Explain the function done by data manager?
What is buffer pool in the db2 database?
What is the maximum size of varchar data type in db2?
What are the various isolation levels possible?
What is ibm db2 used for?
How to check sequence on a table in db2?
What is db2 optimizer?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is a db2 collection?
