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
- 2 Answers
- 6546 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What purpose does the model database server? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Which autogrowth database setting is good? : sql server DBA
What is dbcc? : sql server DBA
what are the types of connection load-balancing?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how can you connect from 10g user to 11g user??
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Why would you use sql agent? : sql server DBA
how can you schedule a job in database?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you initialize log miner?
What is the difference between clustered and non-clustered index? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
