Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 7149 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
which background process invoke at the time of upgradation tell me???
What are the different types of indexes available in sql server? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what functionality does oracle provide to secure sensitive information?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the operating modes in which database mirroring runs? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
how can you schedule a job in database?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How can you control the amount of free space in your index pages? : sql server DBA
What is a correlated sub-query? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
