Which of the following are correct? A REPLACE statement may be used…
A.
… in place of a combination of DELETE and INSERT statements.
B.
… when the replacement of rows must be done in one atomic operation.
C.
… only on MyISAM tables.
D.
… only by the root user.