Oracle 1Z0-920 問題集

質問 1：
How would you restrict a user Joe from accessing all MySQL database objects?
A. CREATE USER 'joe'@'0.0.0.0' SET Password=PASSWORD('% ! %')
B. CREATE USER ' joe'@1' %' DENY ALL PRIVILEGES
C. Insert Joe's name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.
D. UPDATE mysql.user SET Password=PASSWORD('Invalid') WHERE User='joe';
E. REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'joe'@'%';
正解：C

質問 2：
Which two statements are true about MySQL Enterprise Authentication?
A. MySQL Enterprise Authentication supports Windows Active Directory.
B. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
C. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
D. MySQL Enterprise Authentication determines what operation the user can perform.
E. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..
正解：A,B

質問 3：
MySQL is installed on a Linux server with the configuration:

Which two methods can change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?
A. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
D. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
正解：A,B

質問 4：
You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?
A. There are no maintenance operations planned. You need to do them manually.
B. You can expect an outage of your MySQL OCI instance during the planned time..
C. You need to agree to the maintenance windows. If not, you are not affected by the outage.
D. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
正解：B

質問 5：
Which four authentication protocols are allowed when using MySQL Enterprise Authentication?
A. Simple Authentication and Security Layer
B. authentication via Pluggable Authentication Modules (PAMs)
C. authentication using SHA-256 password hashing
D. SECURID authentication and authorization identity
E. Native Windows services
F. connections through the local host via the UNIX socket file
正解：B,C,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You just installed MySQL by Using a Package Manager on Linux.
Where are the default InnoDB redo log files stored?
A. /usr/redo
B. /etc/my.cnf
C. /usr/bin/logs
D. /usr/mysql
E. /var/lib/mysql
F. /var/lib/mysql/innodb
正解：A
解説: (Topexam メンバーにのみ表示されます)