Answer Posted / orawhiz
Temporary segments are created by ORACLE when a SQL statement
needs a temporary work area to complete execution. When the
statement finishes execution, the temporary segment extents are
released to the system for future use.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Compare and contrast between sql and sql server and explain its various functions?
What privilege is needed for a user to create views in oracle?
Can we write dml statement in function in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
What is the difference between a primary key & a unique key?
How to convert characters to times in oracle?
What is oracle rowcount?
How to select some rows from a table in oracle?
In which language oracle has been developed?
How to convert numbers to characters in oracle?
What is an oracle function?
Explain the features of oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to call a stored function with parameters?
What is an oracle and why it is used?