What is a recovery log?

1 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

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

15 Answers   Cap Gemini,

---

What is the syntax for creating a table in the db2 database?

0 Answers  

---

Define sqlca.

0 Answers  

---

---

How to fetch the last row from the table in SQL (db2)?

0 Answers  

---

Which component is used to execute the sql statements?

0 Answers  

---

Explain correlated sub-queries.

0 Answers  

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

---

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

2 Answers   Accenture,

---

What is table space in db2?

0 Answers  

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---