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.
(A) Only (a) is true
(B) Only (b) is true
(C) Both (a) and (b) are true
(D) Neither (a) nor (b) are true
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
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.