100% Oracle 1Z1-921 Guaranteed Success With Testing Engine

Oracle MySQL 2021 Implementation Essentials Sample Questions:

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

A) You forgot to enable port 3306.
B) The opc user can be used to access MySQL only with the created SSH-Key.
C) Only root is allowed to access from non-localhost.
D) The OCI instance is still in the "creation" process.
E) You forgot to create the correct SSL/TLC certificate during the setup process.

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) Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
B) Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
C) Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
D) Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';

3. Which statement will display the status of the partitioning plug-in?

A) SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';
B) SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';
C) SHOW PLUGINS WHERE Name= 'partition';
D) USE SYS SCHEMA; SHOW PLUGINS STATUS;

4. Which is a correct example of creating an Enterprise Encryption function?

A) INSERT INTO t1 (key_co1) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY(,RSA,, 1024));
B) CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME ,openss1_udf.so,;
C) SET @function = CREATE_ASYMMETRIC_PRIV_KEY(@algo, @key_len);
D) VALIDATE FUNCTION create_asymmetric_priv_key WITH ,openssl_udf.so';

5. An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.
What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?

A) mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.
B) MySQL Enterprise Backup does not back up system data so that it is much faster.
C) mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.
D) mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.
E) MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.

Solutions: