UGC NET CSE | November 2017 | Part 2 | Question: 16

Question

Which of the following is/are true with reference to ‘view’ in DBMS?

1. A ‘view’ is a special stored procedure executed when certain event occurs
2. A ‘view’ is a virtual table, which occurs after executing a pre-compiled query

• A. Only (i) is true
• B. Only (ii) is true
• C. Both (i) and (ii) are true
• D. Neither (i) nor (ii) are true

Answer 1

By definition, VIEW is a virtual table, through which a selective portion of the data from one or more tables can be seen. A view does not contain data of its own.

Answer 2

A ‘view’ is virtual table and it is not a special stored procedure. View only occurs after executing a pre-complied query.
So, option (B) is correct.

Answer 3

A ‘view’ is virtual table and it is not stored own data or special stored, View only occurs after executing a pre-complied query.
So that here option (B) is correct.