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:

Current Date

Current Date is a function or feature in many applications that automatically provides the present day's date according to the system or server's calendar.

Calendar Pane

A graphical interface feature that displays a calendar, allowing users to navigate through dates and manage appointments.

Navigation Pane

A user interface element that provides a convenient means to access different views or features within an application, often displayed as a sidebar.

Appointment Area

A space or segment in scheduling applications where appointments or meetings are displayed or edited.