Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


wt is view ? wht r the restrictions for view ?

Answers were Sorted based on User's Feedback



wt is view ? wht r the restrictions for view ?..

Answer / 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

wt is view ? wht r the restrictions for view ?..

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

wt is view ? wht r the restrictions for view ?..

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

Post New Answer



More DB2 Interview Questions

What are the various data types available in db2?

0 Answers  


What are the three lock types?

2 Answers  


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?

3 Answers  


What are column-name qualifiers used?

1 Answers  


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....

4 Answers   Infosys,






Explain how can you do the explain of a dynamic sql statement?

0 Answers  


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 ?

5 Answers   IBM,


Before you give the explain statement, what are the prerogatives?

0 Answers  


What is SPUFI?

4 Answers  


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?

8 Answers   Syntel,


What is bind package and plan in db2?

0 Answers  


What is deadlock in db2?

0 Answers  






Categories