Oracle 1z0-320 問題集

質問 1：
A MySQL server (Linux-based installation, Port 3306, default) needs to be monitored. The MySQL server and the MySQL Enterprise Monitor (MEM) are located in different security zones, which are protected with a firewall. Which port must be opened for MEM agentless monitoring?
A. Port 18443/tcp (Tomcat) from MySQL server to MySQL Enterprise Monitor
B. Port 3306/tcp (MySQL) from MySQL Enterprise Monitor to MySQL server
C. Port 21/tcp (ftp) from MySQL Enterprise Monitor to MySQL server
D. Port 22/tcp (SSH) from MySQL Enterprise Monitor to MySQL server
正解：A

質問 2：
You want to prevent any unauthorized users from gaining access to the personal information of your employees, which is stored in the EMPLOYEE table in a MySQL database. How would you use the MySQL Enterprise Edition Firewall to prevent the following SQL injection attack from exposing the salaries of all your employees?
SELECT fl_name, salary FROM EMPLOYEE WHERE fl_name= 'JHacker' OR 1=1;
A. Create a list of approved SQL users by using the INTERROGATION mode.
B. Create a blacklist of the SQL commands, which would restrict access to the EMPLOYEE table by using the DETECTING mode.
C. Create a whitelist of approved SQL commands by using the RECORDING mode, and enable protection by changing it to PROTECTION mode.
D. Create a FIREWALL STORED PROCEDURE to block any external user from executing this SQL statement.
正解：C

質問 3：
You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?
A. audit-log=FORCE_PLUS_PERMANENT
B. LOAD PLUGIN=AUDIT_LOG
C. plugin-load=audit_log.so
D. plugin-audit=ON, ALWAYS
E. audit_log_permanent=ON
正解：A,E

質問 4：
Identify three levels in which MySQL Enterprise Monitor provides access control.
A. Asset visibility: the rights to access data collected from hosts or MySQL instances
B. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
C. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent
D. Specific data access: the rights to view specific types of potentially sensitive data
E. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services
正解：A,B,D

質問 5：
When creating a FOREIGN KEY constraint, what SQL variable must be specified?
A. an INDEX on the FOREIGN KEY
B. UNIQUE PRIMARY KEY values for both child and parent tables
C. the SET_FOREIGN_KEY variable in the my.cnf file
D. a REFERENCE in the child table to the parent table
E. a TRIGGER on the child table for cascading DELETE statements
正解：E