What is the difference between SYNONYM and ALIAS?
Answer Posted / ss
YNONYM and ALIAS are alternate names to a table. A SYNONYM
is dropped when the table is dropped whereas an alias is
not dropped if the table it is defined is dropped.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Explain various types of locks in db2?
What is load replace in db2?
Can there be more than one cursor open for any program?
What is lock escalation in db2?
What does db2 plan contain?
Mention the different locking levels that are available in db2.
what is diffrence b/w file-aid tool and file-aid utility???
Which is faster delete or truncate?
What do you mean by cursor?
What is bind package and plan in db2?
What is dbrm library?
What is explain in db2?
Are views updateable?
What is an instance database?
What is the function of logging in the db2 database?