Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle Exam 1Z0-497 Topic 7 Question 114 Discussion

Actual exam question for Oracle's 1Z0-497 exam
Question #: 114
Topic #: 7
[All 1Z0-497 Questions]

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;

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

Jesusita
7 days ago
The partitioning criteria is clearly cell_id, as specified in the PARTITION BY RANGE (cell_id) clause.
upvoted 0 times
...
Telma
7 days ago
I think the partitioning criteria is based on cell_id.
upvoted 0 times
...

Save Cancel