Answer / sadiq afroze

Number of rows in the table, Percent of rows in clustering
sequence, Number of distinct values of indexed column,
Number of rows moved to a nearby/fairway page due to row
length increase

What is the purpose of using commit?

0 Answers  

---

how can we find nth max salary from A table

5 Answers   IBM,

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

What is meant by dclgen?

0 Answers  

---

What is nvl in db2?

0 Answers  

---

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---

Mention the various locks that are available in db2.

0 Answers  

---

what is the responsibility of the construction superintendent

0 Answers   Almco,

---

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

What is cloudant database?

0 Answers  

---

What is filter factor?

2 Answers  

---