What is QUIESCE?

2 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---

What will the DB2 optimizer do?

2 Answers  

---

What is correlated subquery?

1 Answers  

---

What is the use of predicate?

0 Answers  

---

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---

what are stage one indexable predicates?

1 Answers  

---

How to create db2 table in mainframe?

0 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 the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---