if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

Define db2.

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,

---

Are views updateable?

0 Answers  

---

How does a cursor work?

0 Answers  

---

What is the clustering index in the db2 database?

0 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  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

What information is used as input to the bind process?

2 Answers  

---

How to find schema of a table in db2?

0 Answers  

---

How do you check for a null value in a db2 column?

2 Answers  

---