Which SQL programming technique should a software company use to report total quantity sold by category for a specific month?

• A. Set-based logic and functions
• B. Procedural programming and triggers
• C. Data Definition Language and views
• D. Transaction Control Language and updates

Answer: (A)

The use of set-based logic and functions is the most suitable SQL programming technique for reporting total quantity sold by category for a specific month. Set-based logic allows for the processing of multiple rows of data in a single operation, which is essential when summarizing or aggregating data, such as calculating totals.

In this scenario, a typical SQL query would involve the use of the SUM() function along with a GROUP BY clause. This enables the user to group records by product category and compute the total quantity sold in a specified month. The structure of SQL is inherently designed around working with sets of data, making it efficient for such aggregate functions.

Other options are less appropriate for this task. Procedural programming and triggers focus more on controlling the flow of execution based on events rather than directly handling set-based queries. Data Definition Language is concerned with the schema and structural aspect of a database, such as creating or altering tables, and views are more about presenting data rather than aggregating it. Lastly, Transaction Control Language is used for managing the state of the database transactions, which does not align with the need for summarizing data for reporting purposes.