Which statement describes a function of a database view?

Which statement describes a function of a database view?

• A. They store data physically
• B. Simplifies data structure for end users
• C. They replace tables in queries
• D. Requires additional programming

Answer: (B)

Database views provide a simplified, user-friendly representation of data by offering a focused, virtual view drawn from one or more base tables. A view is a virtual table defined by a query, so it does not store data itself—the data comes from the underlying tables when you query the view. This lets end users work with a cleaner dataset (such as a subset of columns or a join of related tables) as if it were a single table, without needing to understand the complex underlying structure. A view is not a physical replacement for the base tables in queries, and while creating a view requires defining SQL, using the view typically reduces the need for additional programming because users interact with a simpler, predefined data presentation.

Database views provide a simplified, user-friendly representation of data by offering a focused, virtual view drawn from one or more base tables. A view is a virtual table defined by a query, so it does not store data itself—the data comes from the underlying tables when you query the view. This lets end users work with a cleaner dataset (such as a subset of columns or a join of related tables) as if it were a single table, without needing to understand the complex underlying structure. A view is not a physical replacement for the base tables in queries, and while creating a view requires defining SQL, using the view typically reduces the need for additional programming because users interact with a simpler, predefined data presentation.