| Other DB2 Interview Questions |
|| Asked @
|What is a clustered index?
|What will the FREE command do to a plan?
|what is SMP/E? and what are the major steps of it? thanks...
|What is a Resource Control Table(RCT)? Describe its
|Where would you find information about the type of database
authority held by the user?
|which is the most efficient tablespace??
d.none of the above.
please post answer with the reason.?
|Which one allows duplicate values Union or Union All ?
|How can you display the current date & current time ?
|What is the difference between Primary key and
|What are the functions in DB2?
|I have 3 cursors declared. Cursor1 retieves some data.
Based on this curso2 will also fetches some data. In cursor3
(using for some updation) I'm using the data retrieved by
the above 2 cursor. My question is, while working with
cursor3, periodically if I give commit, will all the three
crsors will be closed or only cursor3 will be closed?
|Suppose we have a query for update
set col1 = 'val1'
where col2=(select .... from ...)
suppose the subquery does not return any record, what will
happen to update?
|For more DB2 Interview Questions Click Here |