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,

---

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?

3 Answers  

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

cursor with hold explain ?

1 Answers   Verizon,

---

how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

Is db2 a database?

0 Answers  

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

What is the FREE command?

1 Answers  

---

What are leaf pages?

3 Answers  

---

What is DCLGEN?

2 Answers  

---