Is schema the same as database?

0 Answers  

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---

In terms of DB2 indexing, what is the root page?

1 Answers  

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

What is an intent lock?

3 Answers  

---

What is a thread?

3 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

What is EXPLAIN?

1 Answers  

---

How many types of page locks can be held in db2?

0 Answers  

---

What is the role of union all and union

0 Answers  

---

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

---