what types of copies can be made with the COPY Utility ?
What is check constraint in db2?
What is a view? Why use it?
What are the various data types available in db2?
Explain db2.
What is db2 command?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
Name the lockable units in DB2?
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?
How can you quickly find out the # of rows updated after an update statement?
What is load replace in db2?
how can we find nth max salary from A table