Free Oracle 1Z1-921 Exam Dumps Questions & Answers

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.MySQL Enterprise Backup does not back up system data so that it is much faster.
• B.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.
• C.mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.
• D.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.
• E.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.

You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup. You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

• A.--apply-log-and-copy-back
• B.--uncompress
• C.--copy-back-and-apply-log
• D.--decompress
• E.--uncompress-and-apply-log

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 private key
• C.SSH public key
• D.Public IP address
• E.User Password
• F.The opc user

You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

• A.You can expect an outage of your MySQL OCI instance during the planned time..
• B.Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
• C.You need to agree to the maintenance windows. If not, you are not affected by the outage.
• D.There are no maintenance operations planned. You need to do them manually.

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

• A.Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
• B.Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.
• C.Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
• D.Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.