Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / guest

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

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

What happens on checkpoint? : sql server DBA

0 Answers  

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

What the different components in replication and what is their use? : sql server DBA

0 Answers  

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

Give two examples of referential integrity constraints.

2 Answers  

For more DB Administration Interview Questions Click Here
Categories