nerdexam
Oracle

1Z0-061 · Question #187

View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements: Which statement is true regarding the above two SQL statements?

The correct answer is D. statement 1 and statement 2 execute successfully and give a different output. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements:

Which statement is true regarding the above two SQL statements?

Exhibits

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

Options

  • Astatement 1 gives an error, statement 2 executes successfully
  • Bstatement 2 gives an error, statement 1 executes successfully
  • Cstatement 1 and statement 2 execute successfully and give the same output
  • Dstatement 1 and statement 2 execute successfully and give a different output

How the community answered

(44 responses)
  • A
    7% (3)
  • B
    18% (8)
  • C
    5% (2)
  • D
    70% (31)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice