List down the types of triggers in the db2 database?

0 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

Highlight all the advantages that are attached to a package.

0 Answers  

---

What are the benefits of using the db2 database?

0 Answers  

---

---

What do you mean by commit and rollback?

0 Answers  

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

How will you return the number of records in table?

0 Answers  

---

How does coalesce work?

0 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

What is performance tuning db2?

0 Answers  

---