Which catalog tables contain authorization information?
When do you specify the isolation level? How?
what is SMP/E? and what are the major steps of it? thanks...
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is the physical storage length of date data type?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
How would you find out the total number of rows in a db2 table?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the use of predicate?
Which component is responsible for db2 startup and shutdown?
What is the result of open cursor statement?