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

出題：1

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

A. MySQL Enterprise Backup will back up from Slave automatically.

B. You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.

C. It provides multi-master access where the application can write and read data across the database servers.

D. It allows backup to be done on the slave without impacting the master.

E. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.

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

出題：2

Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

A. Both the tables, t1 and t2, are created.

B. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

C. Only the t2 table is created.

D. Only the t1 table is created.

正解：A 解答を投票する

出題：3

You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

A. Go to the configuration section (MEM) and configure the default login credentials.

B. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.

C. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.

D. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.

正解：C 解答を投票する

出題：4

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 解答を投票する

出題：5

Which of the following statements is true regarding MySQL user account privileges?
Response:

A. The RELOAD privilege allows a user to delete data from a table.

B. The GRANT option allows a user to revoke privileges from other users.

C. The USAGE privilege allows a user to connect to the MySQL server but grants no other privileges.

D. A user with the SUPER privilege can only read data from the database.

正解：C 解答を投票する

出題：6

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 解答を投票する

出題：7

Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

A. connections through the local host via the UNIX socket file

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. Simple Authentication and Security Layer

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

出題：8

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. KILL PROCESS;

B. SHOW BINLOG EVENTS;

C. GRANT PROXY

D. SHUTDOWN

E. SHOW PROCESSLIST;

F. SHOW STATUS;

正解：A,D,F 解答を投票する

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