Oracle MySQL 2021 Implementation Essentials 認定 1Z0-921 試験問題:
1. Which two statements are true about MySQL Enterprise Authentication?
A) MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
B) MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
C) MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..
D) MySQL Enterprise Authentication determines what operation the user can perform.
E) MySQL Enterprise Authentication supports Windows Active Directory.
2. Which of the following statements is true regarding MySQL user account privileges?
Response:
A) The GRANT option allows a user to revoke privileges from other users.
B) The USAGE privilege allows a user to connect to the MySQL server but grants no other privileges.
C) The RELOAD privilege allows a user to delete data from a table.
D) A user with the SUPER privilege can only read data from the database.
3. What are Security Lists in Oracle Cloud Infrastructure?
A) Security lists are data encryption levels that control who can see the data.
B) They are essentially firewall rules that help control traffic between OCI instances.
C) They contain rules established by HIPAA for securing end-user data.
D) They are user-role designations that assign rights to certain internal users and external users.
E) They allow administrators access to applications in the cloud and external servers.
4. When should you perform a backup in a MySQL database?
Response:
A) Only during scheduled maintenance windows.
B) After critical data updates or before making significant changes to the database.
C) Only when the database size exceeds a certain limit.
D) After every successful query execution.
5. The user -os-user'@"localhost" was created to monitor connections and shut down the server, and was granted these privileges:
GRANT PROCESS, SHUTDOWN ON *.* TO "OS-user*@"localhost';
Which three are commands that the os-user can execute?
A) SHUTDOWN
B) SHOW PROCESSLIST;
C) SHOW STATUS;
D) KILL PROCESS;
E) SHOW BINLOG EVENTS;
F) GRANT PROXY
質問と回答:
質問 # 1 正解: A、E | 質問 # 2 正解: B | 質問 # 3 正解: B | 質問 # 4 正解: B | 質問 # 5 正解: A、C、D |