Oracle
1Z0-883 · Question #93
Which two statements are true regarding partitioning in Mysql?
The correct answer is 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. See the full explanation below for the reasoning.
Question
Which two statements are true regarding partitioning in Mysql?
Options
- ATables with BLOB and TEXT columns cannot be partitioned.
- BPartitioning allows easier management of smaller data sets for certain queries.
- CPartitioning allows different columns to be stored in separate files.
- DThe partitioning expression is an integer or function that returns an integer value or NULL value.
- EPartitioning is only available for those storage engines that implements it natively.
How the community answered
(49 responses)- A6% (3)
- B2% (1)
- C80% (39)
- E12% (6)
Community Discussion
No community discussion yet for this question.