To answer this question, you need to understand the concept of a View. Let's go through each option to understand why it is correct or incorrect:
Option A) To protect some of the columns of a table from other users - This option is correct. A View can be used to restrict access to certain columns of a table, allowing only authorized users to view those columns.
Option B) Occupies data storage space - This option is incorrect. A View does not occupy data storage space because it is a virtual table that is derived from the underlying base table. It does not store any data itself.
Option C) To hide complexity of a query - This option is correct. A View can be used to simplify complex queries by creating a virtual table that represents a subset of the data from one or more tables. This allows users to interact with the View instead of directly querying the underlying tables.
Option D) To hide complexity of calculations - This option is correct. A View can be used to encapsulate complex calculations or transformations, making it easier for users to access the results of those calculations without needing to understand the underlying logic.
The correct answer is B) Occupies data storage space. This option is incorrect because a View does not occupy data storage space.