nerdexam
Oracle

1Z0-883 · Question #48

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of…

The correct answer is A. -- quick. See the full explanation below for the reasoning.

Question

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

Options

  • A-- quick
  • B-- skip-buffer
  • C-- single-transaction
  • D-- tab

How the community answered

(48 responses)
  • A
    77% (37)
  • B
    13% (6)
  • C
    6% (3)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice