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

COBOL SQL 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 Interview Questions

• What is the difference between static and dynamic SQL?
• What are the column name qualifiers?
• Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project ?
• Can you use MAX on a CHAR column?
• What is meant by null?
• Describe referential integrity?
• When is it necessary to create a table index?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What is a NULL value? What are the pros and cons of using NULLS ?
• Compare a subselect to a join?
• More...