What Does the Following SQL Query Do? SELECT INVOICE_NUM FROM INVOICE_LINE

question 29

Multiple Choice

What does the following SQL query do? SELECT INVOICE_NUM FROM INVOICE_LINE WHERE PROD_CODE IN (SELECT PROD_CODE FROM PRODUCTS WHERE (PROD_TYPE = 'Cupcake') ) ;

• A) cause an error because it includes more than one SELECT command
• B) lists all rows from the invoice line table that contain a "Cupcake" type product
• C) lists the invoice numbers for invoices containing line items with a "Cupcake" product type
• D) lists the product codes for all "Cupcake" type products that appear on invoices

---

Definitions:

Neutrality

The state of not supporting or helping either side in a conflict or disagreement; impartiality.

Passive Person

An individual who tends to accept or allow what happens or what others do without active response or resistance.

Elicit

To draw out a response, answer, or fact from someone in a subtle or skillful manner.

Close-Ended Questions

Questions structured to receive a specific, limited response, typically "yes" or "no".