View the Exhibit and examine the details of PRODUCT INFORMATION table.
You have the requirement to display PRODUCT_NAME from the table where the CATEGORY_ID column has values 12 or 13, and theSUPPLIER_ID column has the value 102088. You executed the following SQL statement:
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |