Follow Our FB Page << >> 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

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