Question
Download Solution PDFWhich 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.
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFThe correct answer is "option 2".
Key Points
- A view is a virtual table that is used to view or manipulate parts of the table.
- A view can select rows on the basis of certain conditions & fields from one or more tables present in the database is used to create a view.
- View is not a special stored procedure but is a virtual table that occurs after executing a pre-compiled query. Hence, View in DBMS is a virtual table.
Last updated on Jun 22, 2025
-> The UGC Net Admit Card has been released on its official website today.
-> The UGC NET June 2025 exam will be conducted from 25th to 29th June 2025.
-> The UGC-NET exam takes place for 85 subjects, to determine the eligibility for 'Junior Research Fellowship’ and ‘Assistant Professor’ posts, as well as for PhD. admissions.
-> The exam is conducted bi-annually - in June and December cycles.
-> The exam comprises two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions.
-> The candidates who are preparing for the exam can check the UGC NET Previous Year Papers and UGC NET Test Series to boost their preparations.