engineering computer science MCQ #775

engineering computer science MCQ #775

1. Question 1

   Q1. What is the difference between a view and a materialized view?

   • A) View is a virtual table, materialized view is a physical table
   • B) View is a physical table, materialized view is a virtual table
   • C) View is used for data security, materialized view is used for query performance
   • D) View is used for query performance, materialized view is used for data security

   Answer: View is a virtual table, materialized view is a physical table

   Explanation: A view is a virtual table based on a query, while a materialized view is a physical table that stores the result of a query.