Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

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

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

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 QuestionNext Question
What does coalescing a tablespace do?Name a tablespace automatically created when you create a database.