What command should be used to create an aggregated view of total sales by category in a retail database?

• A. CREATE VIEW CategorySales AS ...
• B. INSERT INTO CategorySales AS ...
• C. DROP VIEW CategorySales AS ...
• D. UPDATE VIEW CategorySales AS ...

Answer: (A)

To create an aggregated view of total sales by category in a retail database, using the appropriate command to construct a view is essential. The option that specifies "CREATE VIEW" is correct because it directly supports the creation of a virtual table that encapsulates a query. By defining a view named "CategorySales," you can include a SELECT statement that groups sales data by category and calculates the total for each group.

This construct allows users to conveniently query summarized data without needing to repeatedly write complex SQL queries each time they need this aggregated information. The ability to create a view is fundamental in database management, as it not only aids in simplifying complex queries but also enhances data access and security, allowing you to present specific data without exposing the underlying tables directly.

In contrast, the other options focus on manipulation or removal of existing views rather than creating a new one. For instance, inserting, dropping, or updating a view doesn't apply in the context of establishing a new aggregated view, which is why they do not serve the intended purpose of summarizing sales data by category.