Which command does a DBA use to display the top 10 best-selling products including their names and total sales amounts?

• A. CREATE VIEW TopProducts AS ...
• B. CREATE TABLE TopSellingProducts AS ...
• C. ALTER VIEW TopProducts AS ...
• D. DROP TABLE TopProducts AS ...

Answer: (A)

The command that a DBA would use to display the top 10 best-selling products, along with their names and total sales amounts, is to create a view. Creating a view allows you to encapsulate a query that retrieves specific data from one or more tables, which can include aggregated values like total sales.

In this case, the creation of a view named "TopProducts" would enable users to access the results of a query without needing to repeatedly write out the entire SQL statement each time the data is needed. A view can present a simplified interface for users or applications to pull essential data.

For example, the corresponding SQL could include a SELECT statement with GROUP BY and ORDER BY clauses to aggregate sales data and rank the products based on total sales. Once the view is created, users can simply query the view to see the top 10 products without dealing with the underlying complexity. This is useful for presenting summaries in a way that is both efficient and straightforward.

The other options provided, such as creating a table, altering a view, or dropping a table, are not relevant for displaying data directly in the manner specified. Creating a table would imply storing static data instead of dynamic results, altering a view does not directly output the desired information, and