What do you mean by rollback?

0 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

What is UNION,UNION ALL?

2 Answers  

---

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

---

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

2 Answers   Accenture, Wipro,

---

Is the primary key a clustered index?

0 Answers  

---

What is meant by AUTO COMMIT?

3 Answers  

---

What is image copy in db2?

0 Answers  

---

Which catalog table stores referential constraints?

1 Answers  

---