nerdexam
Oracle

1Z0-497 · Question #91

In this SQL statement, what is the partitioning criteria? CREATE TABLE books_part PARTITION BY RANGE (cell_id) ( PARTITION p0l VALUES LESS THAN (2), PARTITION p02 VALUES LESS THAN (3)…

The correct answer is D. cell_id. See the full explanation below for the reasoning.

Question

In this SQL statement, what is the partitioning criteria? CREATE TABLE books_part PARTITION BY RANGE (cell_id) ( PARTITION p0l VALUES LESS THAN (2), PARTITION p02 VALUES LESS THAN (3) , . . . PARTITION pl4 VALUES LESS THAN (15), PARTITION pl5 VALUES LESS THAN (16), PARTITION pl6 VALUES LESS THAN (MAXVALUE) ) AS SELECT * FROM books;

Options

  • Abooks
  • Bpxx
  • CMAXVALUE
  • Dcell_id
  • EThere is no partitioning criteria.

How the community answered

(62 responses)
  • A
    6% (4)
  • B
    15% (9)
  • C
    3% (2)
  • D
    74% (46)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice