Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 7462 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
What is dcl? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is the default fill factor value? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what are the benefits of flashback feature?
how can you get actual data change values from previous transactions in oracle?
What are the different ways you can create databases in sql server? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
which background process invoke at the time of upgradation tell me???
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
