AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

What is query_cache_limit?

0 Answers  

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

why we create view.

5 Answers  

---

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---

how can i pull up a query which was previously stored in qmf

3 Answers  

---

What are host variables in db2?

0 Answers  

---

What does reorg do in db2?

0 Answers  

---

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

---