Database Administrator (DBA) Question: Download Questions PDF
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
Answer:
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.
Download Database Administrator (DBA) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What does coalescing a tablespace do? | Name a tablespace automatically created when you create a database. |