438 views
0 votes
0 votes
View in a database system are important because:

1. They improve the efficiency of query execution.

2. They help provide data independence.

3. They allow the schema to change without forcing existing applications to be recompiled.

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

(a) 2 and 4                                                                                (b) 1 and 4

(c) 1 and 3                                                                                (d)  2 and 3

1 Answer

0 votes
0 votes

1. They improve the efficiency of query execution.----> False because unless they are materialized, views do nothing for performance. 

2. They help provide data independence.   ------> True because views allow programs to be independent of the actual physical layout of the data

3. They allow the schema to change without forcing existing applications to be recompiled.  -----> True for similar reasons as in 2 When the schema changes, a view can be created that looks like the old schema.

4. They help with access control by allowing users to see only a particular subset of the data in database.    ------>  True 

Related questions

1 votes
1 votes
1 answer
1
0 votes
0 votes
0 answers
2
naman29 asked Sep 16, 2017
228 views
0 votes
0 votes
0 answers
3
abhinowKatore asked Mar 7, 2022
458 views
Which of the following pairs of string belonging to Σ* are distinguishable by the following dfa?