What is the difference between SYNONYM and ALIAS?
Answer Posted / nandivardhanreddy.n
when the table is dropped automatically synonym is dropped
and it is a private variable.
when the table is dropped alias is not dropped because it
is invalid and it is global variable.
synonym can accesed by the user who creates it
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Define declaration generator (dclgen).
What is nvl in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
List down the data types in the db2 database.
B37 abend during spufi?
What is db2 and what is the use of db2 optimizer?
How to find schema of a table in db2?
What is the connection string to connect to the DB2 Database ?
What is the usage of open cursor command?
What are the uses of db2 optimizer?
Explain correlated sub-queries.
What is host variable?
What is the advantage in De-normalizing tables in DB2?
List out the three types of page locks that can be held.