Free 1Z0-882 Web TestEngine Demo

Q13 Single choice

Consider the statement:

CREATE TABLE t1 (a INT) PARTITION BY KEY

/*150611 ALGORITHM = 1*/

What does this statement do?

A
Create the t1 table partitioned by KEY with the default algorithm in all versions.
B
Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL version 5.6.11 and the default algorithm in other versions.
C
Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL versions 5.6.11 or newer and the default algorithm in older versions.
D
Create the t1 table partitioned by KEY using algorithm 1 only if the preceding statement returned error condition 50611.

1Z0-882 Web TestEngine demo