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
What is load utility in db2?
What is database manager in db2?
What is the use of predicate?
What is bind and rebind in db2?
Which command is used to remove all rows from a table?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to find the number of rows in a db2 table?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
what is the sqlcode -501
What is the difference between nvl and coalesce?
How to check last update on table in db2?
How does a cursor work?
What is meant by dclgen?
How do I add a column to a table in db2?
What is runstats and reorg in db2?