What is an alias and how does it differ from a synonym?

Answer Posted / krishna kant kumar

Alias is used in present session only but synonym is used in next session also because it is a database object.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are packages in db2?

595


What are host variables in db2?

625


How do I copy a table in db2?

573


Define db2.

672


How do you select a row using indexes in db2?

645






What is db2 plan table?

620


What is dbrm library?

578


What is the use of commit in db2?

630


If I have a view which is a join of two or more tables, can this view be updateable?

689


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

636


What is cursor in dbms?

589


List out the three types of page locks that can be held.

687


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

654


What is consistency token in db2?

640


What are the various data types available in db2?

632