wt is view ? wht r the restrictions for view ?
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
|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 This Answer Correct ?||0 Yes||3 No|
What are the various data types available in db2?
What are the three lock types?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What are column-name qualifiers used?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
Explain how can you do the explain of a dynamic sql statement?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
Before you give the explain statement, what are the prerogatives?
What is SPUFI?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is bind package and plan in db2?
What is deadlock in db2?