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)- A6% (4)
- B15% (9)
- C3% (2)
- D74% (46)
- E2% (1)
Community Discussion
No community discussion yet for this question.