What is a synonym? How is it used

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

(Continued from previous question...)

What is a synonym? How is it used

A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities when the code is migrated.
The synonym is linked to the AUTHID that created it.

(Continued on next question...)

Other Job Interview Questions

• What is the basic differnce between a join and a union?
• What is a foreign key?
• Suppose I have five SQL SELECT statements connected by UNION/UNION ALL ...
• Describe the elements of the SELECT query syntax?
• What is the difference between group by and order by ?
• Explain an outer join ?
• What are some SQL aggregates and other built-in functions?
• What is a cursor?
• Compare a subselect to a join?
• What are some SQL aggregates and other built-in functions?
• More...