Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 42 of 50

Marks: +1, -0

View the Exhibit and examine the details of the PRODUCT_INFORMATION table.
Exhibit

You must 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 this SQL statement:

Which statement is true regarding the execution?

It would not execute because the entire WHERE clause is not enclosed within parentheses.
It would execute but would return no rows.
It would not execute because the same column has been used twice with the AND logical operator.
It would execute and return the desired result.

Validate

Go to Question:

Prev Question

Next Question