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
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
What are the different types of indexes available in sql server? : sql server DBA
What is the default fill factor value? : sql server DBA
who owns the operating system files created by the utl_file package?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
What the different types of replication and why are they used? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you record information about current session?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the different ways you can create databases in sql server? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
how can you connect from 10g user to 11g user??
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the importance of a recovery model? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com