Oracle
1Z0-882 · Question #91
Consider the statement: CREATE TABLE t1 (a INT) PARTITION BY KEY /150611 ALGORITHM = 1/ What does this statement do?
The correct answer is C. Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL versions 5.6.11 or newer. See the full explanation below for the reasoning.
Question
Consider the statement:
CREATE TABLE t1 (a INT) PARTITION BY KEY /150611 ALGORITHM = 1/ What does this statement do?
Options
- ACreate the t1 table partitioned by KEY with the default algorithm in all versions.
- BCreate the t1 table partitioned by KEY using algorithm 1 only in MYSQL version 5.6.11 and the
- CCreate the t1 table partitioned by KEY using algorithm 1 only in MYSQL versions 5.6.11 or newer
- DCreate the t1 table partitioned by KEY using algorithm 1 only if the preceding statement returned
How the community answered
(37 responses)- A5% (2)
- B3% (1)
- C76% (28)
- D16% (6)
Community Discussion
No community discussion yet for this question.