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

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

Question Posted / guest

2 Answers
7161 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / guest

Temporary Tablespace is in generally used for sorting
purpose while Permanent tablespace is used to sore
permanent objects

Regards
Abhinav Phadnis

Is This Answer Correct ?

15 Yes

0 No

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

Answer / kranthi

Permanent tablespace is used to store permanent objects etc
temporary tablespace is used for sorting

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB Administration Interview Questions

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers STC,

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

What are the commands used in dcl? : sql server DBA

0 Answers

why we use cursors

1 Answers

How can you gather statistics on a table?

3 Answers

orra 1555 what is this error,why it is occur?

2 Answers Mphasis,

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers

how can you find out if a table can be redefined?