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
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 are the different ways you can create databases in sql server? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Which autogrowth database setting is good? : sql server DBA
Can you redefine a table online?
What is transparent data encryption? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the different sql server versions you have worked on? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
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?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you connect from 10g user to 11g user??
What is the difference between dropping a database and taking a database offline? : sql server DBA