Advanced Database Management System - Tutorials and Notes: Why views are important in database management system?

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Monday, 9 November 2020

Why views are important in database management system?

Views in database management system, MCQ in DBMS, solved quiz questions in DBMS, purpose of database views

 

Q1) Why views are important in database management system?

a) They improve query execution efficiency

b) They help with access control by allowing users to see only a particular subset of the data in the database.

c) They help users to see entire database without any complexities

d) They provide data independence

Answer: (b) and (d)

As view is a stored query, it restricts users from seeing the entire table. Even the actual table name is hidden from end users.

Views allow programs to be independent of the actual physical layout of the data

What is database view?

A database view is a subset of a database and is based on a query that runs on one or more database tables. Database views are saved in the database as named queries and can be used to save frequently used, complex queries.

A view is simply any SELECT query that has been given a name and saved in the database. For this reason, a view is sometimes called a named query or a stored query.

 

************************
Related posts:


Quiz questions with answers on DBMS introduction concepts

Advantage of database views

No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents