Answer / s

predicate is a search condition coded in the SQL statement
to filter rows.

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---

what is difference between Plan and Package

1 Answers   Syntel,

---

What is a db2 schema?

0 Answers  

---

max number of columns in a db2 table?

6 Answers  

---

What is lock escalation?

2 Answers  

---

---

What is meant by a unit of recovery?

1 Answers  

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---

Where would you find information about the type of database authority held by the user?

2 Answers  

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

What is meant by index cardinality?

2 Answers  

---