What is a base table?
Answers were Sorted based on User's Feedback
Answer / s
Base table is created by using CREATE TABLE and the table
description is stored in Catalog table SYSTABLES. The
definition and data are persistant.
| Is This Answer Correct ? | 1 Yes | 0 No |
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
what is the use of bind parameter, Replace?
What is the difference between cursor and select statement?
Explain various types of locks in db2?
What is cursor stability?
How could one combine a set of incremental image copies into a single copy?
How does DB2 use multiple table indexes?
Is ibm db2 free?
What is the meaning of -805 SQL return code?
What does DML stand for and what are some examples of it?
How does db2 sample database connect?
Explain the function done by data manager?