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
- 7435 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 a crs resource?
internal architecture
What are statistics, under what circumstances they go out of date, how do you update them?
Which autogrowth database setting is good? : sql server DBA
how can you find out if a table can be redefined?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is dbcc? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What authentication modes does sql server support? : 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?
how can you process messages in order asynchronously?
What are the steps you will take to improve performance of a poor performing query?
What happens on checkpoint? : sql server DBA
