Which table is preferred when there are many updates?
(a) MyISAM
(b) InnoDB
(c) MEMORY
(d) MERGE
(a) MyISAM
(b) InnoDB
(c) MEMORY
(d) MERGE
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
The correct choice is (b) InnoDB
Explanation: The InnoDB tables can provide better performance when there are many updates. Locking is done at the row level rather than at the table level. So the extent of the table that is locked is smaller.