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
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is innodb buffer pool?
what are bind concepts in db2 cobol?
What is the result of open cursor statement?
How is deadlock resolved?
Which isolation level provides highest data integrity?
Are view updateable?
What are db2 tables?
How do I start db2 in windows?
Explain packages.
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is null value in db2?
List out the buffer pools in db2
What is meant by dclgen?
How do you stop a db2 database in linux?