Interested to Buy Any Domain ? << Click Here >> for more details...
wt is view ? wht r the restrictions for view ?
- 3 Answers
- 7777 Views
- Verizon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / rajesh
View is just a display of a DB2 table where the access to
that view can be controlled.
Restriction : In order to create a view a base table should
exist.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / anjireddy vintha
view is a logical object which is derived from parent
table. view will be deleted automatically when patent table
is deleted.
| Is This Answer Correct ? | 0 Yes | 3 No |
Mention data types used in db2 ?
How to access db2 tables in mainframe?
What is the use of runstats in db2?
How to create backup table in db2?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
Explain transactions, commits and rollbacks in DB2.
What are the isolation levels possible ?
What is lock contention?
What techniques will be used to avoid deadlock??
What os does db2 run on?
What is catalog database in db2?
What is the SQL Communications Area and what are some of its key fields?
COBOL 
