As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

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  

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

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

0 Answers   Oracle,

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

what is logical system in sap basis

0 Answers  

---

how can you record information about current session?

0 Answers   Oracle,

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---