What is the difference between a TEMPORARY table

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

(Continued from previous question...)

41. What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

A temporary tablespace is used for temporary objects such as sort structures while permanent tablespaces are used to store those objects meant to be used as the true objects of the database.

(Continued on next question...)

Other Job Interview Questions

• If a break order is set on a column would it affect columns which are under the column?
• Give the reasoning behind using an index.
• What does COMMIT do?
• What is the difference between OLE Server & OLE Container?
• Compare and contrast TRUNCATE and DELETE for a table.
• What are the Large object types suported by Oracle?
• What is a property clause?
• Explain the use of TKPROF? What initialization parameter should be turned on to get full TKPROF output?
• What happens if the constraint name is left out of a constraint clause?
• What is a DBA?
• More...