1Z0-921問題集、Oracle実際の試験問題

質問 1

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' SET PASSWORD AS 'Sh@256Pa33';

B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

C. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';

D. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

正解: B,C

質問 2

Which three are characteristics of the JSON data type?

A. It validates the JSON syntax on insert or merge.

B. It supports indexing directly against the JSON-defined column.

C. A set of SQL functions substantially support the SQL utilization of the data type.

D. It is based on the TEXT data type.

E. Key or array references enable quick read-access to look up document elements directly.

F. Comparisons of JSON values are not case-sensitive.

正解: A,B,E

質問 3

Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?

A. You must have an Internet gateway to connect to a public address on an Oracle Linux instance.

B. You can connect directly to the VCN without a define subnet.

C. You can connect directly to an instance over the internet, without a public IP address.

D. Your instance does not have a public IP address, so you cannot connect with a public subnet.

E. You must have an IPSec VPN to connect to an Oracle Linux instance.

正解: B,C

質問 4

You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

A. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.

B. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.

C. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.

D. Use mysqldump with the - -changesonly option.

E. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.

正解: B,D

質問 5

You have created your Compute instance using an Oracle-provided Oracle Linux image.
You want to log in to your OCI Compute instance using SSH. Which three items do you need for this process?

A. The root user

B. SSH public key

C. The opc user

D. Public IP address

E. SSH private key

F. User Password

正解: C

質問 6

You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?

A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.

B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.

C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving--hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.

D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.

正解: B

質問 7

Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

A. The OCI instance is still in the "creation" process.

B. You forgot to enable port 3306.

C. You forgot to create the correct SSL/TLC certificate during the setup process.

D. Only root is allowed to access from non-localhost.

E. The opc user can be used to access MySQL only with the created SSH-Key.

正解: B

質問 8

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

A. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.

B. Execute the purge binary logs statement without argument.

C. To safely purge binary log files, perform these steps:

D. On the Master server, disable binlog by removing the --log-bin option.

E. Delete all binlog files manually on the file system to release storage spaces.

正解: A,C

Oracle MySQL 2021 Implementation Essentials - 1Z0-921 模擬練習