Answer Posted / d.manohar reddy

26BYTES

What is difference between alias and synonym in db2?

1131

---

What is the use of db2 optimizer?

1107

---

List out the buffer pools in db2

1071

---

what is db2 restart?

2147

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1143

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

1071

---

List out the three types of page locks that can be held.

1145

---

What is image copy in db2?

1007

---

What are catalog tables in db2?

1044

---

What is database manager in db2?

1011

---

How to execute stored procedures?

1125

---

How do I connect my db2 database to ibm?

1042

---

What type of database is db2?

965

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1182

---

Explain the contention situations caused by locks?

1065

---