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

You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

• A. 
• B. 
• C. 
• D. 
• E. 

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.  --uncompress
• B.  --decompress
• C.  --copy-back-and-apply-log
• D.  --apply-log-and-copy-back
• E.  --uncompress-and-apply-log

Which two methods help prevent MySQL security risks?

• A.  Transmit plain (unencrypted) data over networks.
• B.  Allow unauthorized clients to connect to the server.
• C.  Use the secure installation script "mysql_alays_secure_installation".
• D.  Use a firewall to control access to MySQL ports.
• E.  Ensure that MySQL accounts have short and easy passwords.
• F.  Grant only permissions that a user requires.

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

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