nerdexam
Oracle

1Z0-883 · Question #59

Consider the Mysql Enterprise Audit plugin. You are checking user accounts and attempt the following query: Mysql> SELECT user, host, plugin FROM mysql.users; ERROR 1146 (42S02): Table `mysql.users'…

The correct answer is C. NAME="Query". See the full explanation below for the reasoning.

Question

Consider the Mysql Enterprise Audit plugin. You are checking user accounts and attempt the following query:

Mysql> SELECT user, host, plugin FROM mysql.users; ERROR 1146 (42S02): Table `mysql.users' doesn't exist Which subset of event attributes would indicate this error in the audit.log file?

Options

  • ANAME="Query"
  • BNAME="Error"
  • CNAME="Query"
  • DNAME="Error"
  • ENAME="Error"

How the community answered

(46 responses)
  • A
    2% (1)
  • B
    9% (4)
  • C
    83% (38)
  • D
    4% (2)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice