Western Governors University (WGU) ITEC2104 C175 Data Management - Foundations Practice Exam

The command used to list names of products sold by a specific salesperson exceeding a certain quantity is SELECT. This SQL statement is fundamental for querying information from a database. When constructing an SQL query, the SELECT command enables you to specify the columns you want to retrieve from the database tables. In this scenario, to list products sold by a specific salesperson, you typically start your query with SELECT, followed by the fields of interest, which would include the product names. Additionally, you would combine this with a WHERE clause to filter records based on the salesperson's identity and to specify the quantity exceeding a certain threshold. This allows for precise data retrieval that directly addresses the needs of the query by focusing only on relevant records. Thus, the SELECT command is crucial for retrieving and displaying the desired data from the database.