Oracle 1Z0-921 問題集

質問 1：
Which two deployment architectures could you use for scaling-out database reads?
A. Implementing a three-node, single-primary InnoDB Cluster.
B. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.
C. Edit the configuration file and increase the value for parallel_read_workers and reboot the server
D. Altering the storage engine for all tables to memory to increase performance.
E. Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.
正解：A,D

質問 2：
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

質問 3：
What SQL keyword must be specified when creating a foreign key constraint?
A. a REFERENCES in the child table to the parent table
B. an index on the foreign key
C. unique PRIMARY key values for both child and parent tables
D. a TRIGGER on the child table for cascading delete statements
E. the SET_FOREGIN variable in the my .cnf file
正解：D

質問 4：
You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?
A. Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.
B. Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.
C. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
D. Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
正解：B

質問 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. GRANT PROXY
D. SHOW STATUS;
E. SHOW BINLOG EVENTS;
F. KILL PROCESS;
正解：A,D,F

質問 6：
Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?
A. monitoring the availability of the MySQL Instance
B. tracing import and export with mysqldump
C. starting and stopping the MySQL instance
D. deploying MySQL agent on supported target operating system
E. analyzing executed MySQL queries
F. creating e-mail alerts and SNMP traps for MySQL warnings
正解：B,D,F

質問 7：
Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:
A. Query Analyzer
B. MySQL Advisors
C. MySQL Dashboard
D. MySQL Query Analyzer
正解：D

質問 8：
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