nerdexam
Oracle

1Z0-882 · Question #75

Assuming a table Country exists with a column Name, which of the following are valid uses of the LIMIT clause?

The correct answer is B. SELECT Name FROM Country LIMIT 100,50 C. SELECT Name FROM Country LIMIT 35. See the full explanation below for the reasoning.

Question

Assuming a table Country exists with a column Name, which of the following are valid uses of the LIMIT clause?

Options

  • ASELECT Name FROM Country LIMIT 100-50
  • BSELECT Name FROM Country LIMIT 100,50
  • CSELECT Name FROM Country LIMIT 35
  • DSELECT Name FROM Country LIMIT @limitcount
  • ESELECT Name FROM Country LIMIT RAND()

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    80% (28)
  • D
    6% (2)
  • E
    11% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice