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
- 7302 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 do you troubleshoot errors in a sql server agent job? : 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
Which autogrowth database setting is good? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How would you extract DDL of a table without using a GUI tool?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Explain about your sql server dba experience? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Explain materialized views and how they are used.
who owns the operating system files created by the utl_file package?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How do you open a cluster administrator? : sql server DBA
