All Questions

Views – Creating and using virtual tables.

MCQ Question 1 of 10

What is a view in a relational database?

A physical table storing dataA virtual table derived from a queryA temporary file on diskA stored procedure

Which SQL command is used to create a view?

CREATE TABLECREATE VIEWCREATE INDEXCREATE PROCEDURE

How can you retrieve data from a view?

SELECT queryINSERT query onlyUPDATE query onlyDROP query

Which type of view allows INSERT, UPDATE, or DELETE operations?

Simple viewComplex view with joins and aggregationsViews with GROUP BYViews with DISTINCT

What is an advantage of using a view?

Reduce query performanceSimplify complex queries and improve securityStore extra redundant dataIncrease storage requirements

Can a view be created from multiple tables using JOINs?

Yes, creating a virtual combined tableNo, views must use a single tableOnly for INNER JOINOnly for LEFT JOIN

How do views improve database security?

By encrypting tablesBy allowing users to see only specific columns or rowsBy storing duplicate dataBy limiting storage space

Which command is used to delete a view?

DROP TABLEDROP VIEWDELETE VIEWREMOVE VIEW

Which statement is true about views compared to tables?

Views physically store dataViews are virtual and derive data from base tablesTables cannot have indexesViews cannot be queried

How does a materialized view differ from a normal view?

It stores data physically for faster queriesIt cannot be queriedIt is always read-onlyIt automatically deletes base tables