Free Oracle 1Z0-922 Exam Dumps Questions & Answers

When installing MySQL Enterprise Server, which configuration file is primarily used to set server parameters?

• A.  /var/mysql/settings.conf
• B.  /etc/mysql/server.cnf
• C.  /usr/mysql/config.cnf
• D.  /etc/my.cnf

What is the purpose of the --compress option in the mysqlbackup command?

• A.  To perform an incremental backup
• B.  To enable parallel processing of backups
• C.  To encrypt the backup
• D.  To reduce the size of the backup by compressing data files

Which MySQL Enterprise tool provides real-time protection against SQL-based attacks such as SQL injection?

• A.  MySQL Enterprise Firewall
• B.  MySQL Performance Schema
• C.  MySQL Enterprise Authentication
• D.  MySQL Enterprise Backup

What is the primary role of MySQL Enterprise Authentication?

• A.  To integrate MySQL with external authentication systems
• B.  To enforce password policies for users
• C.  To optimize query execution
• D.  To create backups of MySQL databases

Which feature of MySQL Enterprise Audit assists in detecting unauthorized access?

• A.  Logging failed login attempts
• B.  Backup automation
• C.  Query optimization
• D.  Data encryption