1Z1-921試験無料問題集（78題）「Oracle MySQL 2021 Implementation Essentials 認定」

出題：1

The user 'fwuser'@'localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands:

You want to clear the account whitelist for the * fwuser" @* localhost* user. Which statement should you run to accomplish this?

A.

B.

C.

正解：C 解答を投票する

出題：2

What is Kubernetes in the context of MySQL?
Response:

A. A database management tool for MySQL.

B. A cloud service provided by Oracle for MySQL databases.

C. An open-source container orchestration platform.

D. A database engine for MySQL.

正解：C 解答を投票する

出題：3

You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?

A. CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;

B. CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE

C. CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)

D. CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)

E. CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;

正解：D 解答を投票する

出題：4

The slave connects to the master and asks for updated records. What command was issued for this to happen?

A. START SLAVE

B. SLAVE START

C. RUN SLAVE

D. SLAVE RUN

E. START RUN SLAVE

正解：B 解答を投票する

出題：5

You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?

A. Use MySQL Enterprise High Availability to access one of the available data tables

B. Execute the sakila-data. sqi script to populate the database

C. Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;

D. Use mysqldump to import data from the sakila_dummy database sample data set.

正解：C 解答を投票する

出題：6

After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?

A. The root_pw variable stored in the mysq1.install table.

B. As root, execute the show password command by using the SHA-256 password encryption plug-in.

C. The root password displayed on the screen via a [warning] message.

D. The root password inserted in the error log set by the --log-error=[file_name] variable

E. The root password is not given and is blank. You must manually set the root password.

正解：A,B 解答を投票する

出題：7

Which two statements about the download of MySQL Enterprise Backup are correct?

A. MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).

B. MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.

C. MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.

D. MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.

E. MySQL Enterprise Backup comes with all MySQL editions including community edition.

正解：B,E 解答を投票する

出題：8

What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?

A. Browser pop-ups

B. SMS-notification tab on the dashboard

C. Application-to-application messaging

D. Direct support call from an Oracle representative

E. Email

正解：B,E 解答を投票する

1Z1-921試験無料問題集「Oracle MySQL 2021 Implementation Essentials 認定」