What is a base table?

Question Posted / guest

Answers were Sorted based on User's Feedback

What is a base table?..

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

What is a base table?..

Answer / santosh

It is a db2 object.

Is This Answer Correct ?

0 Yes

0 No

More DB2 Interview Questions

How to resolve -818 sql code in DB2?

What is the syntax required for the creation of a cursor?

how do we solve soc 7 and soc4 ?

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

What do you mean by rollback?

The only place of VSAM KSDS in DB2 is?

What are the uses of db2 optimizer?

What is DB2 (IBM Database 2)?

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?

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

What is db2 and what is the use of db2 optimizer?

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

For more DB2 Interview Questions Click Here