What is the difference between SYNONYM and ALIAS?
Answer Posted / kp
Synonym is private to the user who has defined the Synonym
and also the synonym cannnot refer to a remote table
Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
What are the full forms of spufi and dclgen and why are they used?
What is meant by explain?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What r the comman abends in db2, jcl and cobol???????
How can you count the number of rows from a table tab?
Mention the downsides of page level lock.
What is syscat in db2?
Define buffer pool.
Explain about mirror activator disk mirroring?
What are the rules for db2 programming?
What is ibm db2 used for?
How can deadlocks be resolved?
Which is faster delete or truncate?