Nina Is Writing a MySQL Query to List the Descriptions

question 7

Multiple Choice

Nina is writing a MySQL query to list the descriptions of items in the CUPCAKES table, which are identified by PROD_ID values. The ORDER_LINE table includes product and quantity information from bakery orders, which are identified by ORDER_NUM values. What can she add to the following query to limit the list to descriptions of cupcakes purchased through order 342? SELECT DESCRIPTION FROM CUPCAKES WHERE

• A) PROD_ID IN(ORDER_LINE WHERE(ORDER_NUM = '342'));
• B) EXISTS (PROD_ID WHERE (ORDER_LINE.ORDER_NUM = '342'));
• C) PROD_ID IN(SELECT PROD_ID FROM ORDER_LINE WHERE(ORDER_NUM = '342'));
• D) PROD_ID EXISTS(SELECT PROD_ID FROM ORDER_LINE WHERE(ORDER_NUM = '342'));

---

Definitions:

Budgeted Overhead Cost

The forecasted or estimated costs of overhead that a company plans to incur over a period, factored into its budgeting process.

Machine-Hours

A measure of production time, referring to the number of hours machines are run to produce goods.

Oil Well Service Company

An oil well service company provides a range of services to the oil and gas industry, including drilling, maintenance, and completion services for oil wells.

Flexible Budget

A budget that adjusts or flexes with changes in volume or activity levels during a period.