Answer / pradeep

a clustered index is a indexin which both index and data
rows will be arranged in some particular sequence

datarows will be arranged based on the index in leaf pages

What is pagespace?

1 Answers  

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

What is null value in db2?

0 Answers  

---

What will the FREE command do to a plan?

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?

2 Answers  

---

What is the FREE command?

1 Answers  

---

Describe major components of db2?

0 Answers  

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---

What is the syntax for creating a table in the db2 database?

0 Answers  

---

What is a DB2 bind?

3 Answers  

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

What is a trigger in the db2 database?

0 Answers  

---