Q#1: In DBMS, a view is:
(A) A virtual table derived from one or more base tables
(B) A physical copy of a table
(C) Only an index
(D) Only a backup file
Answer: (A) A virtual table derived from one or more base tables
Q#2: Views are used primarily to:
(A) Simplify complex queries and provide security
(B) Backup data
(C) Normalize tables
(D) Encrypt database
Answer: (A) Simplify complex queries and provide security
Q#3: A view can be created using the SQL command:
(A) CREATE VIEW
(B) CREATE TABLE
(C) CREATE INDEX
(D) CREATE DATABASE
Answer: (A) CREATE VIEW
Q#4: Views in DBMS do not store:
(A) Actual data
(B) Query definitions
(C) Column names
(D) Table references
Answer: (A) Actual data
Q#5: A view that allows modification of underlying tables is called:
(A) Updatable view
(B) Read-only view
(C) Materialized view
(D) Indexed view
Answer: (A) Updatable view
Q#6: A view that cannot be modified is called:
(A) Read-only view
(B) Updatable view
(C) Materialized view
(D) Indexed view
Answer: (A) Read-only view
Q#7: Materialized views store:
(A) Actual data physically for faster access
(B) Only query definitions
(C) Only indexes
(D) Only primary keys
Answer: (A) Actual data physically for faster access
Q#8: Indexed views are used to:
(A) Improve performance of frequently accessed queries
(B) Backup data
(C) Normalize tables
(D) Encrypt data
Answer: (A) Improve performance of frequently accessed queries
Q#9: A view can reference:
(A) One or more base tables or other views
(B) Only one table
(C) Only indexes
(D) Only primary keys
Answer: (A) One or more base tables or other views
Q#10: Dropping a view does not:
(A) Affect the base tables
(B) Delete base table data
(C) Remove indexes on tables
(D) Delete the database
Answer: (A) Affect the base tables
Q#11: Advantages of views include:
(A) Data security, simplicity, and abstraction
(B) Only backup
(C) Only encryption
(D) Only indexing
Answer: (A) Data security, simplicity, and abstraction
Q#12: A view can be used to:
(A) Restrict access to certain columns or rows
(B) Encrypt data only
(C) Backup only
(D) Normalize tables
Answer: (A) Restrict access to certain columns or rows
Q#13: A view can be based on:
(A) SELECT statements
(B) CREATE TABLE statements
(C) INSERT statements
(D) UPDATE statements
Answer: (A) SELECT statements
Q#14: Views can hide:
(A) Complexity of joins and aggregations
(B) Backup operations
(C) Encryption methods
(D) Indexes
Answer: (A) Complexity of joins and aggregations
Q#15: Nested views are:
(A) Views defined on other views
(B) Views with indexes
(C) Views with encryption
(D) Views for backup only
Answer: (A) Views defined on other views
Q#16: A read-only view can be made updatable using:
(A) Instead-of triggers
(B) Index only
(C) Backup only
(D) Encryption only
Answer: (A) Instead-of triggers
Q#17: Views can be used to:
(A) Provide different representations of the same data for different users
(B) Encrypt tables only
(C) Backup data only
(D) Normalize tables only
Answer: (A) Provide different representations of the same data for different users
Q#18: View resolution occurs when:
(A) The DBMS replaces the view with its underlying query during execution
(B) Table is deleted
(C) Data is backed up
(D) Table is normalized
Answer: (A) The DBMS replaces the view with its underlying query during execution
Q#19: Limitations of views include:
(A) Some views are non-updatable and may reduce performance
(B) Always require backup
(C) Always encrypt data
(D) Always create indexes
Answer: (A) Some views are non-updatable and may reduce performance
Q#20: WITH CHECK OPTION in a view ensures:
(A) Inserted or updated rows through the view satisfy the view condition
(B) Data is encrypted
(C) Backup is created
(D) Index is maintained
Answer: (A) Inserted or updated rows through the view satisfy the view condition
Q#21: View can be used to implement:
(A) Virtual private tables
(B) Encryption
(C) Backup
(D) Index only
Answer: (A) Virtual private tables
Q#22: Views help in:
(A) Data abstraction and hiding physical schema details
(B) Backup only
(C) Encryption only
(D) Indexing only
Answer: (A) Data abstraction and hiding physical schema details
Q#23: A view can include:
(A) Joins, aggregations, and groupings
(B) Only SELECT *
(C) Only single table
(D) Only indexes
Answer: (A) Joins, aggregations, and groupings
Q#24: Dropping a base table referenced by a view:
(A) Invalidates the view
(B) Automatically drops all views
(C) Encrypts the view
(D) Backs up the view
Answer: (A) Invalidates the view
Q#25: Views are helpful for:
(A) Security by restricting access to sensitive columns
(B) Encrypting data only
(C) Backup only
(D) Indexing only
Answer: (A) Security by restricting access to sensitive columns
Q#26: Recursive views are:
(A) Views that reference themselves
(B) Indexed views
(C) Materialized views
(D) Backup views
Answer: (A) Views that reference themselves
Q#27: A view can simplify:
(A) Complex SQL queries for end-users
(B) Encryption
(C) Backup operations
(D) Index maintenance
Answer: (A) Complex SQL queries for end-users
Q#28: Views do not store data physically unless:
(A) They are materialized
(B) They are indexed
(C) They are recursive
(D) They are nested
Answer: (A) They are materialized
Q#29: Updatable views require:
(A) Unique key reference to underlying table
(B) Backup only
(C) Encryption only
(D) Index only
Answer: (A) Unique key reference to underlying table
Q#30: Main purpose of views in DBMS is:
(A) Provide abstraction, security, and simplified access to data
(B) Backup only
(C) Encrypt only
(D) Index only
Answer: (A) Provide abstraction, security, and simplified access to data