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;

Abooks

Bpxx

CMAXVALUE

Dcell_id

EThere is no partitioning criteria.

Show Suggested Answer

Suggested Answer: D

by Beckie at Mar 20, 2025, 02:33 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

7 hours ago

D) cell_id is the correct answer. The partitioning is based on the range of the cell_id column.

upvoted 0 times

...

7 hours ago

I agree with Telma, the partitioning criteria is definitely based on cell_id.

upvoted 0 times

...

8 days ago

The partitioning criteria is clearly cell_id, as specified in the PARTITION BY RANGE (cell_id) clause.

upvoted 0 times

...

8 days ago

I think the partitioning criteria is based on cell_id.

upvoted 0 times

...