Answer Posted / yuvaevergreen

Steps in program preparation
>>Step 1: Process SQL statements
>>Step 2: Compile (or assemble) and link-edit the
application
>>Step 3: Bind the application
>>Step 4: Run the application

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

1136

---

What is dbrm in db2 database?

1093

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1083

---

What is db2 instance?

1057

---

What happens in bind step in a db2 program?

958

---

What is role in db2?

1083

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1065

---

What is temporal table in db2?

1021

---

What is precompiler in db2?

997

---

What does sqlcabc has?

1032

---

How do we specify index to include or not during bind process.

2107

---

How can you quickly find out the # of rows updated after an update statement?

1025

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1221

---

Are view updateable?

1021

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1077

---