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,

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

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

2 Answers   TCS,

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

Explain an ORA-01555

2 Answers  

---