What is the difference between base table and view?

Answer Posted / ashok

base table has physical existence, whereas views r virtual
tables

Is This Answer Correct ?    38 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a system catalog table in db2?

588


Explain about rct.

654


What is reorg and runstats in db2?

696


How many databases can be created inside an instance in db2 ?

601


Explain about open switch business continuity software?

563






Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6856


What is dclgen (declaration generator)?

603


Which component is responsible for db2 startup and shutdown?

630


When reorg is used?

676


Can we insert update delete in view?

578


What are types of indexes?

593


Define declaration generator (dclgen).

667


What is syscat in db2?

580


How to find the maximum value in a column in the db2 database?

611


What is the purpose of using commit?

618