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
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What are the differences between number and binary_float in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to best split csv strings in oracle 9i?
How to use "if" statements on multiple conditions?
What is java oracle used for?
How does Oracle guarantee data integrity of data changes?
Explain temporal data types in oracle
When do you get a .pll extension in oracle? Explain its importance
How to export several tables together?
How to shutdown your 10g xe server from command line?
How to calculate date and time differences in oracle?
How do I start tns listener?
How can I introduce multiple conditions in like operator?
State the various uses of dbcc command?