Answer / gogune suresh kumar

Returns multi set data(records) that are subsequently used in
data transformations.

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1 Answers  

---

what is the role of dip user in our database?

1 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

What are the commands used in dcl? : sql server DBA

1 Answers  

---

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

7 Answers   TCS,

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

What is fill factor? : sql server DBA

1 Answers  

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1 Answers  

---

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

1 Answers  

---