Interested to Buy Any Domain ? << Click Here >> for more details...
wt is view ? wht r the restrictions for view ?
- 3 Answers
- 7651 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 |
Can we able to find all the Table names under a Particular Plan?
What is a recovery log?
what types of copies can be made with the COPY Utility ?
What is ibm db2 connect?
Explain various types of locks in db2?
What is buffer pool?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How do I add a column to an existing table in db2?
On the create tablespace, what does the CLOSE parameter do?
what is the Foreign key? explain?
what is a trigger and types of triggers
What parameters are used to control the free space in DB2?
COBOL 
