Answer Posted / samir kumar sahoo.

in DROP TABLE command it will remove the table containts as
well as table structure from the database catalog, also it
release all the storage space it has acquired previously.
we can't rollback it as it is a ddl command.

but in case of DELETE TABLE command it just delete all the
records but not relaese the spaces it acquires .it can be
rollback as it is a dml command.

What is the function of logging in the db2 database?

1123

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4314

---

What action db2 takes when a program aborts in the middle of a transaction?

1156

---

What is a bind in db2?

1042

---

Are views updateable?

1160

---

What is db2 optimizer?

1236

---

What are bind parameters in db2?

1046

---

Why db2 is called db2?

1041

---

Which isolation level provides maximum concurrency?

1152

---

What is cascading rollback?

1214

---

What is dbrm? What it contains? When it will be created?

1051

---

What are the contents of dclgen?

1112

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9211

---

What is the advantage in De-normalizing tables in DB2?

1178

---

How do you eliminate duplicate values in db2?

1192

---