Answer / s

When a plan is dropped it removes the entries from SCT02
table.

What is a cursor in programming?

0 Answers  

---

What is a view? Why use it?

2 Answers  

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

---

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

---

What is plan in cobol db2?

0 Answers  

---

What is drop table?

0 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

Which command is used to remove all rows from a table?

0 Answers  

---