Which two statements are true regarding partitioning in Mysql?
A.
Tables with BLOB and TEXT columns cannot be partitioned.
B.
Partitioning allows easier management of smaller data sets for certain queries.
C.
Partitioning allows different columns to be stored in separate files.
D.
The partitioning expression is an integer or function that returns an integer value or NULL
value.
E.
Partitioning is only available for those storage engines that implements it natively.
Explanation:
C is wrong.
From the RM:
This is known as horizontal partitioning—that is, different rows of a table may be assigned to different physical partitions. MySQL 5.6 does not support vertical partitioning, in which different columns of a table are assigned to different physical partitions
E is wrong.
For creating partitioned tables, you can use most storage engines that are supported by your MySQL server; the MySQL partitioning engine runs in a separate layer and can interact with any of these.
MySQL partitioning cannot be used with the MERGE, CSV, or FEDERATED storage engines.
I think A is wrong.
So, the correct answers must be B and D
B and E.
B is obvious as it is the intention of partitioning.
E because it says it is only supported by those engines which support it natively.
As per :
http://dev.mysql.com/doc/refman/5.6/en/partitioning-types.html
partioning key can return other than integer for hash. so not D.
B&E
B, E
Respectfully, I would go with B and D. Innodb partitioning is not implemented natively until 5.7.
I say ‘B’ and ‘D’. If you notice, ‘D’ says “The partitioning expression”. https://dev.mysql.com/doc/refman/5.6/en/partitioning-limitations.html specifies:
Arithmetic and logical operators. Use of the arithmetic operators +, -, and * is permitted in partitioning expressions. However, the result must be an integer value or NULL (except in the case of [LINEAR] KEY partitioning, as discussed elsewhere in this chapter; see Section 19.2, “Partitioning Types”, for more information).
+ 1
BE
https://dev.mysql.com/doc/refman/5.6/en/partitioning.html
A & E is perfect one…*