UGC-NET | UGC-NET CS 2017 Dec 2 | Question 16

Which of the following is/are true with reference to ‘view’ in DBMS ?
(a) A ‘view’ is a special stored procedure executed when certain event occurs.
(b) A ‘view’ is a virtual table, which occurs after executing a pre-compiled query.
code:
(A) Only (a) is true
(B) Only (b) is true
(C) Both (a) and (b) are true
(D) Neither (a) nor (b) are true

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

Quiz of this Question