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,

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

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?

0 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

what is the use of home directory???

1 Answers   HP,

---

what is grd?

0 Answers   Oracle,

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

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

2 Answers  

---