nerdexam
Oracle

1Z0-873 · Question #5

Which of the following best describes how MySQL utilizes the grant table buffers?

The correct answer is A. The grant table buffer loads grant table information into memory for fast access. The grant tables store information about MySQL user accounts and the privileges they have. The server loads a copy of the grant tables into memory for fast access-control checking.

Security

Question

Which of the following best describes how MySQL utilizes the grant table buffers?

Options

  • AThe grant table buffer loads grant table information into memory for fast access.
  • BThe grant table buffer loads what users are currently logged in and performing queries.
  • CThe grant table buffer holds requests waiting to check the grant table to perform access-control.

How the community answered

(18 responses)
  • A
    83% (15)
  • B
    11% (2)
  • C
    6% (1)

Explanation

The grant tables store information about MySQL user accounts and the privileges they have. The server loads a copy of the grant tables into memory for fast access-control checking.

Topics

#grant tables#access control#MySQL security#memory buffers

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice