DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

What is an alias and how does it differ from a

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.

(Continued on next question...)

Other Job Interview Questions