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 is the purpose of creating view is sql server 2000

Answer Posted / mehtab ullah

Purpose of view

Views hide data complexity.
Views add security by restricting access to the columns of a
table.
Views simplify the complex queries for the user.
View is a way to isolate application from changes in
definitions of base tables.
View is derived from the perant table.
View do not occupy any space in the memory .

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I view views in sql server?

937


What is raid, and how it can influence database performance?

1008


Explain how you can configure a running aggregate in SSRS?

155


Is foreign key unique?

957


What does <> symbol mean?

918


What does it mean to normalize data?

894


What language is sql server written in?

985


how many triggers you can have on a table? : Sql server database administration

904


How can you list all the table constraints in a database?

881


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

936


What is database mirroring?

1038


query processing

2102


What is a file group?

1018


What is the importance of concurrency control?

1176


Define the one-to-one relationship while designing tables.

856