nerdexam
Oracle

1Z0-061 · Question #177

View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement: The above query generates an error on execution. Which clause in the above SQL statement…

The correct answer is C. GROUP BY. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement:

The above query generates an error on execution. Which clause in the above SQL statement causes the error?

Exhibits

1Z0-061 question #177 exhibit 1
1Z0-061 question #177 exhibit 2

Options

  • AWHERE
  • BSELECT
  • CGROUP BY
  • DORDER BY

How the community answered

(53 responses)
  • A
    15% (8)
  • B
    2% (1)
  • C
    75% (40)
  • D
    8% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice