Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

wt is view ? wht r the restrictions for view ?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find the maximum value in a column in the db2 database?

1084


What is dbrm? When it will be created?

1029


What is the difference between cursor and select statement?

1102


What is iseries database?

1048


What is a db2 tablespace?

1065


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1044


Explain the contention situations caused by locks?

1070


Name the lockable units in DB2?

1128


Explain the benefits you can get from mainframe connect?

972


What does db2 plan contain?

1021


Why db2 is called db2?

1041


What is precompiler in db2?

1022


i want to maintain uniqueness on pdf without make lf??????????

2158


What is copy pending status in db2?

1127


Is the primary key a clustered index?

1149