wt is view ? wht r the restrictions for view ?
Answer Posted / ratheesh nellikkal
A view we can treat it as a virtual table.
It doesn't have any physical existance.
A View can be created entirely from a single table or from
a number of tables with appropriate joins.
The mail Restriction in a view is that if a view made up of
more than one table then it can not update it.
(Obviously if the base table is not exists the db2 will
trow an error and u can not create the view)
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is a db2 collection?
What is meant by union and union all?
Why do we use cursor?
List down the types of triggers in the db2 database?
How to execute stored procedures?
Highlight all the advantages that are attached to a package.
How to retrieve rows from a db2 table in embedded sql?
What is a page in db2?
What is a cursor in programming?
What are the full forms of spufi and dclgen and why are they used?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Is db2 a mainframe database?
What is dbrm library?
What is data manager?
What is role in db2?