Explain the use of table functions.

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

(Continued from previous question...)

30. Explain the use of table functions.

Table functions are designed to return a set of rows through PL/SQL logic but are intended to be used as a normal table or view in a SQL statement. They are also used to pipeline information in an ETL process.

(Continued on next question...)

Other Job Interview Questions

• What is a cluster Key?
• What is Object Auditing?
• Display Odd/ Even number of records
• What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table.
• List the Optional Flexible Architecture (OFA) of Oracle database? How can we organize the tablespaces in Oracle database to have maximum performance?
• Talk about “Exception Handling” in PL/SQL?
• What are the default extensions of the files created by menu module?
• What is the use of transactional triggers?
• How do you switch to DOS prompt from SQL prompt?
• From which designation is it preferred to send the output to the printed?
• More...