최신 1Z0-921 무료덤프 - Oracle MySQL 2021 Implementation Essentials

문제1

Which three statements describe MySQL Enterprise Backup?

A. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.

B. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.

C. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.

D. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.

E. MySQL Enterprise Backup provides the point-in-time recovery functionality.

정답: B,C,E

문제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. Only the t1 table is created.

B. Only the t2 table is created.

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

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

정답: D

문제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,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;

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

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

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

정답: E

문제4

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 under [mysqld] in the configuration file.

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

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

정답: C,D

문제5

What three are ways to export and import data in MySQL Workbench?

A. Backup Data Export and Import Wizard

B. Table Data Export and Import Wizard

C. Result Data Export and Import

D. Binary Data Export and Import Wizard

E. Data Modeling Import Export Wizard

F. SQL Data Export and Import Wizard

정답: B,C,F

문제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 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. 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.

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 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.

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 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.

정답: C

문제7

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH) For accessing a new MySQL Enterprise Edition on an Oracle Cloud Infrastructure (OCI) Instance you " Add SSH key " information during the OCI instance setup. You want to use Putty from your Windows Client to install MySQL.
What are the correct steps to accomplish this?

A. Use the provided private key for authentication.

B. Convert the private key to ppk format first and use the new private key for authentication.

C. Open Port 22 on your OCI Instance and configure Putty with the ssh private key.

D. Open Port 22 on your OCI Instance and convert the private key to ppk format. This new private key can be used for authentication.

정답: D

문제8

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

A. START SLAVE

B. RUN SLAVE

C. SLAVE START

D. SLAVE RUN

E. START RUN SLAVE

정답: C

최신 1Z0-921 무료덤프 - Oracle MySQL 2021 Implementation Essentials

우리와 연락하기

유용한 링크

최신 업데이트