1z1-320 by Oracle Actual Free Exam Q&As

Question 1

A keyfile has been generated as follows:
# openssl rand 32 -hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.
Which option can perform the backup with the keyfile provided in order to encrypt the backup files?

A. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile - - backup-dir=/var/tmp/backup backup-to-image B. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup C. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup - timestamp backup D. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile -
-backup-dir=/var/tmp/backup backup-to-image E. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile -
-backup-dir=/var/tmp/backup backup-to-image

Discussion 0

Correct Answer: E Vote an answer

Question 2

You have installed MySQL 5.6.20 on Windows 2012. This MySQL Instance is monitored without an Enterprise Monitor Agent. You cannot see any MySQL queries. How can you enable this feature?

A. Use UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name =
'statements_digest'; B. For query analyzing, it is mandatory to use a MySQL Enterprise Monitor agent on Windows 2012 Server. C. Use UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name='statements_digest'; D. MySQL query analyzing is available only in MySQL Version 5.7 and later. You need a later version of MySQL

Discussion 0

Correct Answer: C Vote an answer

Question 3

You have a text file named "xyz.csv" exported from another system.

You are asked to import data to a MySQL Database table named "country".
The table definition is as follows:

Identify the action that imports the data from Workbench or MySQL Client to the database correctly.

A. Use mysqlimport to load the mycountry.csv data file with the --csv option specified. B. Convert the data into MDI and restore the MySQL data from it. C. Create a DIRECTORY LINK object on the database and use INSERT into mycountry SELECT * from mycountry.csv. D. Use the LOAD DATA INFILE syntax to load data into the database table.

Discussion 0

Correct Answer: D Vote an answer

Question 4

Your newly created MySQL Cloud Service is not available from your application. Select the two correct options that apply.

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

Discussion 0

Correct Answer: C,E Vote an answer

Question 5

An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysqldump and mysql 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 are two 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. MySQL Enterprise Backup does not back up system data so that it is much faster. 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 from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed. E. 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.

Discussion 0

Correct Answer: D,E Vote an answer

Question 6

How do you restrict a user named joe from being able to connect from any IP address to a MySQL database?

A. You cannot deny access to a user based on his or her username. B. CREATE USER 'joe'@%' DENY ALL PRIVILEGES C. CREATE USER 'joe'@'0.0.0.0'SET Password=PASSWORD ('%!%') D. Insert Joe's name into the mysql.user_restriction table, and issue the FLUSH PRIVILEGES command. E. UPDATE mysql.user SET Password=PASSWORD ('Invalid') WHERE User= 'joe';

Discussion 0

Correct Answer: D Vote an answer

Question 7

Which two ports need to be opened on a network firewall to allow an outside client (on the other side of the firewall) to be able to access a MySQL instance inside the firewall?

A. Port 13306/tcp [MySQL], when using TCP/IP via a command-line client B. Port 22/tcp [SSH], when using TCP/IP over SSH C. Port 3306/tcp [MySQL], when tunneling is not used from within MySQL Workbench D. Port 18443/tcp [MySQL], when connecting from MySQL Workbench to a Windows MySQL server

Discussion 0

Correct Answer: B,C Vote an answer

Question 8

Which three features are available only on MySQL Enterprise Workbench?

A. Database Migration inclusive Support B. MySQL Audit Log Inspector C. Database Design D. Visual Performance Dashboard E. GUI for MySQL Enterprise Backup

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 9

When there are long-running queries, mysqbackup hangs there to wait for the completion of the queries. You know that the system has only user data on InnoDB and there is no DDL execution during the backup period.
There is no update/alternation to tables with non-InnoDB storage engines.
Which two ways allow the MySQL Enterprise Backup to be executed without being blocked or without locking?

A. Running mysqlbqckup from a remote machine enabled you to back up the database without locking. B. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries. C. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - - only-innodb option to back up only InnoDB tables, to avoid blocking. D. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds) and does not disturb the normal processing of mysqld much. However, use - -single-user-mode to back up the long-running queries to allow mysqlbackup to run successfully without locking. E. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - -no-locking option to backup up the non-InnoDB files. Note that MyISAM, .frm, and other files copied under the --no-locking setting cannot be guaranteed to be consistent, if they are updated during this final phase of the backup.

Discussion 0

Correct Answer: D,E Vote an answer

Question 10

Which three statements are true about MySQL Enterprise Backup?

A. It enables you to take non-locking backups. B. It provides the ability to create incremental backups. C. It performs logical backups. D. It performs hot or warm backups. E. It cannot backup encrypted tablespaces.

Discussion 0

Correct Answer: A,B,C Vote an answer

Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z1-320 Exam Practice Test