What is a result table?
Answer / s
Result table contains rows DB2 selects from one or more
base tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
How does DB2 store NULL physically?
What is explain plan in db2?
What is subquery ?
What is copy pending status in db2?
What is role in db2?
Explain how can you do the explain of a dynamic sql statement?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is a subselect? Is it different from a nested select?
What is syscat in db2?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?