Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7543 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
how can you generate profile of pl/sql applications to identify performance bottlenecks?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what functionality does oracle provide to secure sensitive information?
What purpose does the model database server? : sql server DBA
What is the default fill factor value? : sql server DBA
what is logical system in sap basis
How can you control the amount of free space in your index pages? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what is the role of dip user in our database?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
internal architecture
how can a session indicate its interest in receiving alerts?
how can you get actual data change values from previous transactions in oracle?
How do you open a cluster administrator? : sql server DBA
