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   CTS,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

how can you initialize log miner?

0 Answers   Oracle,

---

---

what is asm?

0 Answers   Oracle,

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

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?

0 Answers   HSBC,

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---