What is the difference between base table and view?

Answer Posted / priya

using views complex queries can be solved easily
as it provides multiple table join facility

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between plan and package in db2?

576


What is buffer pool?

613


What is dbrm? When it will be created?

600


What is database reorganization?

591


What is role in db2?

620






What is runstats and reorg in db2?

799


What types of tables are there in the db2 database?

556


Which components manage deadlocks in db2?

615


Which component is responsible for processing sql statements and selecting access paths?

671


What is data manager?

610


Explain the function done by data manager?

857


How to connect to db2 database from windows command line?

562


What is lock escalation in db2?

574


What is access path in db2?

564


what is the sqlcode -501

11308