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
What happens to the current transaction if a ddl statement is executed?
Can I create users through internet explorer in oracle 10g?
What are the different editions of oracle?
what are archived logs?
definition of cluster and non-clustered index?
What is logical backup in oracle?
Differentiate between pre-select and pre-query?
How to drop a stored function?
What is the difference between pre-select and pre-query?
Please explain oracle data types with examples?
State and explain the different types of data models?
Explain an integrity constrains?
Can we create trigger on materialized view in oracle?
What is an oracle data file?
State some uses of redo log files?