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

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

What is the dataguard background process??

1 Answers   iGate,

Which autogrowth database setting is good? : sql server DBA

0 Answers  

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

How can we know the exact updation date of a particular database?

2 Answers   Satyam,




Give two examples of referential integrity constraints.

2 Answers  

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

how can you implement fine-grained auditing?

0 Answers   Oracle,

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories