What is difference between Rename and Alias?

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

(Continued from previous question...)

What is difference between Rename and Alias?

Rename is actually changing the name of an object whereas Alias is giving another name (additional name) to an existing object.

Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.

(Continued on next question...)

Other Job Interview Questions

• What are things you do to reduce patch timing ?
• What is a cursor?
• What is difference between AD_BUGS and AD_APPLID_PATCHES ?
• Whats is location of access_log file ?
• What is an UTL_FILE? What are different procedures and functions associated with it?
• What is FNDSM ?
• What is plssql/database cache ?
• Why I need two Concurrent Processing Nodes or in what scenarios PCP is Used ?
• What are main configuration files in Web Server (Apache) ?
• What is RRA/FNDFS ?
• More...