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