Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 types of connection load-balancing?

0 Answers   Oracle,

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

what is the differnce between process and thread ?

1 Answers   IBM,

How would you force a log switch?

4 Answers  

What is transparent data encryption? : sql server DBA

0 Answers  

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

What is the difference between LMT & DLT?

1 Answers   CTS,

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

What is fill factor? : sql server DBA

0 Answers  

How can you enable a trace for a session?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories