nerdexam
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)
  • A
    5% (2)
  • B
    3% (1)
  • C
    76% (28)
  • D
    16% (6)

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice