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

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

2 Answers
7336 Views
CTS, I also Faced
E-Mail Answers

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

Where would you look for errors from the database engine?

0 Answers IBM,

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers Oracle,

Which autogrowth database setting is good? : sql server DBA

0 Answers

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers

what is grd?

0 Answers Oracle,

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers

what is rebuild index??

2 Answers IBM, Sapient,

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

how can you record information about current session?

0 Answers Oracle,

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

1 Answers

how will you see when the database was started using sql prompt?

2 Answers IBM,

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers DELL, TCS,

For more DB Administration Interview Questions Click Here