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

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

what is the use of home directory???

1 Answers   HP,

What is a correlated sub-query? : sql server DBA

0 Answers  




mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

what are the benefits of flashback feature?

0 Answers   Oracle,

Explain the use of table functions.

1 Answers  

how can you find out if a table can be redefined?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories