1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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 / siva

Answers were Sorted based on User's Feedback



CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In ..

Answer / 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

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In ..

Answer / ashok

1) no need to recover a temperory tablespace .if it is
corrupted we create a new temporary tablespace assign that
tablespace to database

2) yes we can add a datafile when tablespace in begin
backup mode also

4)yes

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB Administration Interview Questions

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

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

0 Answers  

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

How can you rebuild an index?

6 Answers  




Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

Datapump backup steps?

1 Answers  

What is the difference between online backup & offline backup?

3 Answers   CSC,

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

What is the dataguard background process??

1 Answers   iGate,

what is the use of ocr?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories