UTpaper

Free mock tests & test series

Question 25Asked in UGC NET Computer Science, November 2017 (Paper II & III, Selected Questions)

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

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-complied query. Code :
  1. AOnly (A) is true
  2. BOnly (B) is true
  3. CBoth (A) and (B) are true
  4. DNeither (A) nor (B) are true
Show answerHide answer

Correct answer: (B) Only (B) is true

Explanation

A view is a virtual table through which a selective portion of the data from one or more tables can be seen; it does not contain data of its own. A stored procedure executed when an event occurs is a trigger, not a view. So only (B) is true.

From UGC NET Computer Science PYQ, November 2017 (Paper II & III, Selected Questions)

This is question 25 of UGC NET Computer Science PYQ, November 2017 (Paper II & III, Selected Questions). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.