Answer / s

TABLESPACE,TABLE, PAGE,ROW

Answer / sadiq afroze

PAGE, TABLE, TABLESPACE

Answer / ram

Cursor Stability, Read Stability, Uncommited Read and Repeatable Read

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,

---

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

2 Answers   Accenture,

---

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

1 Answers   CSI, CTS,

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

Name the various locking levels available?

0 Answers  

---

---

What is bufferpool in db2?

0 Answers  

---

What is a thread?

3 Answers  

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

What is copy book?

1 Answers   Thomson Reuters,

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---