1.Temporary tablespaces can be used only for that particular session.Once

CTS int questions:
1.Temperory tablespace corrupted,how to resolve?If you need
to recover?
2.In tablespace begin backup mode,Its possible to add the
datafile?
3.How to partition the table using Hash partioning,what
happened internally?
4.During rman backup,some files are missing Rman will
continue the backup?
5.what are the errors occurs frequently?
6.which join method is best?why?
7.how to solve deadlock errors?

please reply anyone....

regards
siva

Question Posted / victory

2 Answers
7301 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / victory

1.Temporary tablespaces can be used only for that particular
session.Once u end the session there will be no more old
temp tbsp available. (as far as i know)
7.activate the deadlock detector and dlchktime which
automatically rollbacks one application randomly.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

internal architecture

2141

What the different topologies in which replication can be configured? : sql server DBA

1180

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1051

What is the difference between clustered and non-clustered index? : sql server DBA

1024

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?

2615

Explain about your sql server dba experience? : sql server DBA

1023

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

1137

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

995

What is the default fill factor value? : sql server DBA

1059

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1054

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1920

What the different types of replication and why are they used? : sql server DBA

1105

What is fill factor? : sql server DBA

1182

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1944

suppose you want to audit specific activities on sensitive data. How can you achieve that?

951