Prev Question
Next Question

View the Exhibit and examine the details of PRODUCT_INFORMATION table.
PRODUCT_NAME CATEGORY_ID SUPPLIER_ID
Inkjet C/8/HQ 12 102094
Inkjet C/4 12 102090
LaserPro 600/6/BW 12 102087
LaserPro 1200/8/BW 12 102099
Inkjet B/6 12 102096
Industrial 700/ID 12 102086
Industrial 600/DQ 12 102088Compact 400/LQ 12 102087
Compact 400/DQ 12 102088
HD 12GB /R 13 102090
HD 10GB /I 13 102071
HD 12GB @7200 /SE 13 102057
HD 18.2GB @10000 /E 13 102078
HD 18.2GB @10000 /I 13 102050
HD 18GB /SE 13 102083
HD 6GB /I 13 102072
HD 8.2GB@5400 13 102093
You have the requirement to display PRODUCT_NAME from the table where the CATEGORY_ID column has
values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL
statement:
SELECT product_name
FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088;
Which statement is true regarding the execution of the query?

A.
It would not execute because the same column has been used in both sides of the AND logical operator to
form the condition.

B.
It would not execute because the entire WHERE clause condition is not enclosed within the parentheses.

C.
It would execute and the output would display the desired result.

D.
It would execute but the output would return no rows.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *