What is the difference between base table and view?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1938


What is catalog database in db2?

646


What is page size in db2?

563


What do you mean by commit and rollback?

594


define clustering index.

617






What is rebind in db2?

576


What is the difference between oracle and db2?

587


Explain about rct in db2?

640


Discuss about db2 bind?

673


What is the maximum size of varchar data type in db2?

645


i want to maintain uniqueness on pdf without make lf??????????

1635


Give the name of some fields form sqlca.

614


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

580


B37 abend during spufi?

982


What are the uses of db2 optimizer?

817