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


Please Help Members By Posting Answers For Below Questions

What are the full forms of spufi and dclgen and why are they used?

654


What is meant by explain?

660


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

743


Which command is used to connect to a database in DB2 ? Give the Syntax.

599


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

706






What r the comman abends in db2, jcl and cobol???????

1818


How can you count the number of rows from a table tab?

633


Mention the downsides of page level lock.

707


What is syscat in db2?

574


Define buffer pool.

625


Explain about mirror activator disk mirroring?

558


What are the rules for db2 programming?

641


What is ibm db2 used for?

598


How can deadlocks be resolved?

540


Which is faster delete or truncate?

675