Answer Posted / abirami

Sorry.. Answer 1 given by me is incorrect.

Correct Query is

select disntinct salary from tablename
Order by salary
Fetch first 10 rows only

Is the primary key a clustered index?

1206

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1155

---

List down the types of triggers in the db2 database?

1079

---

How to check table size in db2 sap?

1098

---

What are the full forms of spufi and dclgen and why are they used?

1138

---

What is temporal table in db2?

1102

---

What are host variables in db2?

1125

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2268

---

What is the difference between oracle and db2?

1174

---

What os does db2 run on?

1049

---

When reorg is used?

1184

---

Mention the definition of cobol in varchar field.

1315

---

What are packages in db2?

1076

---

What is universal database?

1121

---

Which component is used to execute the sql statements?

1147

---