rajeev kumar

• Apr 19th, 2013

 

if you have created view and if you want to update something in view it will also be update in table

rinusybase

 Profile Answers by rinusybase 

• May 6th, 2013

 

Define frequently used joins, projections, and selections as views so that users need not specify all the conditions and qualifications each time an operation is performed on that data.

Display different data for different users, even when they are using the same data at the same time. This advantage is particularly important when users of many different interests and skill levels share the same database.

Techiee

• Jun 12th, 2013

 

1. Hiding Unwanted(users do not have right to see those columns e.g login, password column in table) columns from the user.

2. Reduce the complexity of tables from using joins etc. in your query.

asifeqbal

 Profile Answers by asifeqbal 

• Mar 19th, 2015

 

1. We can restrict the users access to the stored data by using Views. User can be given permission to access database through views that contain the specific data the user is authorized to see.

2. A view is logical representation of data from several different tables. So that multi table queries by using Joins are converted into Single queries against View.

3. Views can give a user a "personalized" view of the database structure.

4. A view can present a consistent, unchanged image of the structure of the database, even if the underlying source tables are split, restructured, or renamed.

5. If data is accessed and entered through a view, the DBMS can automatically check the underlying source tables to ensure that it meets the specified integrity constraints.

6. If update something in view it will also be update in underlying source tables.