nerdexam
Oracle

1Z0-061 · Question #6

Examine the structure of the transactions table: You want to display the date, time, and transaction amount of transactions that where done before 12 noon. The value zero should be displayed for…

The correct answer is B. Option B. See the full explanation below for the reasoning.

Question

Examine the structure of the transactions table:

You want to display the date, time, and transaction amount of transactions that where done before 12 noon. The value zero should be displayed for transactions where the transaction amount has not been entered. Which query gives the required result?

Exhibit

1Z0-061 question #6 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(55 responses)
  • A
    11% (6)
  • B
    82% (45)
  • C
    2% (1)
  • D
    5% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice