nerdexam
Oracle

1Z0-061 · Question #173

View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the query statement: What would be the outcome of the above statement?

The correct answer is A. It executes successfully. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the query statement:

What would be the outcome of the above statement?

Exhibit

1Z0-061 question #173 exhibit

Options

  • AIt executes successfully.
  • BIt produces an error because the condition on CUST_LAST_NAME is invalid.
  • CIt executes successfully only if the CUST_CREDIT_LIMIT column does not contain any null
  • DIt produces an error because the AND operator cannot be used to combine multiple BETWEEN

How the community answered

(17 responses)
  • A
    71% (12)
  • B
    6% (1)
  • C
    6% (1)
  • D
    18% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice