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
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 |
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
What is a LIKE table and how is it created?
If I have a view which is a join of two or more tables, can this view be updateable?
What is db2 isolation?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Can we update view in db2?
How to get the ddl of a table in db2?
What does the CHECK Utility do ?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What will the DB2 optimizer do?
What is the SQL query to select, delete and get count of duplicate rows in DB2?