Answer / hraju.mr

Hi Naresh,
DB2 is a relational database from IBM and mainly used for
applications like any othr database products from
Oracle.the Procedure here is similar to work with
almost.There are 2 different platforms that you can go
ahead with this technology....as application programmer and
DataBase Architecture.here the second one is the one which
includes the responsibilities of designing
database,Tablespaces ..taking backups running the
Utitlities both Online and Offline..ofcourse this is an
intersting subject that u can always rely upon..

If CPU is very slow What can u do to speed up?

1 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

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

5 Answers   CSC, Logica CMG,

---

---

What type of index should you use on a fact table?

1 Answers  

---

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

2 Answers   HP,

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

what are the differences of where and if in SAS?

0 Answers  

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---