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 load utility in db2?

881


What is database manager in db2?

749


What is the use of predicate?

784


What is bind and rebind in db2?

875


Which command is used to remove all rows from a table?

766


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

833


How to find the number of rows in a db2 table?

842


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

820


what is the sqlcode -501

12100


What is the difference between nvl and coalesce?

807


How to check last update on table in db2?

810


How does a cursor work?

745


What is meant by dclgen?

845


How do I add a column to a table in db2?

834


What is runstats and reorg in db2?

1012