Interested to Buy Any Domain ? << Click Here >> for more details...
wt is view ? wht r the restrictions for view ?
- 3 Answers
- 7793 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 |
Name the different types of Table spaces.
what is different three logs in DB2?
where can we use index and subscript ? with example ?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
How can we retrieve the total number of records in RPG & CLLE?
Could anyone clearly explain the diference between sub query and correlated sub query?
What is the difference between base table and view?
Can you Average the Characters ?
What are the Isolation levels possible ?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is deadlock?
What is COPY PENDING status?
COBOL 
