Base table is the Physical table and views are the virtual tables where i

What is the difference between base table and view?

Question Posted / bhushan

Answer Posted / bhushan

Base table is the Physical table and views are the virtual
tables where its physical existence will not be there.

Is This Answer Correct ?

21 Yes

2 No

Please Help Members By Posting Answers For Below Questions

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11645

What is the clustering index in the db2 database?

970

How can the duplicate values be eliminated from db2 select?

1067

What is db2 purescale?

963

What is the difference between drop table and delete table?

1155

How to run db2 command in windows?

1158

What is the difference between spufi and qmf?

1072

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2884

What is the difference between cursor stability and repeatable read isolation levels?

1140

What is reorg and runstats in db2?

1172

What is ibm db2 database?

969

What is the role of data manager in the db2 database?

1069

What are concurrency issues?

1050

What is the max length of sqlca?

1183

What r the comman abends in db2, jcl and cobol???????

2223