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

What are the advantages of VIEW?

Answer Posted / anil_abbireddy

1. data security : complex view can not be modified ie.
base tables cannot be visible.
2. it provides easy way to query data from different data
sources like a single table
3.it is very usefull when developing complex reports basing
on multiple tables.

Is This Answer Correct ?    38 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does group by remove duplicates?

1106


how to start mysql server? : Sql dba

1258


what is bcp? When does it used? : Sql dba

1051


Can we rollback truncate?

1070


what is collation? : Sql dba

1222


what are all the common sql function? : Sql dba

1121


Can we use distinct and group by together?

1129


What is the current version of sql?

1091


Do we need to rebuild index after truncate?

1126


How do I remove duplicates in two columns?

1174


what is dbms? : Sql dba

1053


Is primary key clustered index?

1008


define sql insert statement ? : Sql dba

1092


What is the current version of postgresql?

1153


what are the advantages of sql ? : Sql dba

1136