Which of the following statements are true?
A.
The MylSAM storage engine should be preferred when you expect many reads and few updates to occur
B.
The MylSAM storage engine should be preferred when you expect a mix of many reads and many updates to occur
C.
The InnoDB storage engine should be preferred when you expect many reads and few updates to occur
D.
The InnoDB storage engine should be preferred when you expect a mix of many reads and many updates to occur