Oracle 1z0-320 Free Practice Questions

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

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

Answer: CE

NEW QUESTION 2
The user ‘fwuser’@’localhost’ was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database.
You executed commands:

You want to clear the account whitelist for the ‘fwuser’@’localhost’ user. Which statement would you run to accomplish this?

• A. CALL mysql.sp_reload_firewall_rules (‘fwuser@localhost’);
• B. SET mysql.sp_set_firewall_mode= ‘RECORDING’;
• C. CALL mysql.sp_set_firewall_mode (‘fwuser@localhost’, ‘CLEAR’);
• D. DELETE TABLE INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST;

Answer: C

NEW QUESTION 3
A MySQL server (Linux-based installation, Port 3306, default) needs to be monitored. The MySQL server and the MySQL Enterprise Monitor (MEM) are located in different security zones, which are protected with a firewall. Which port must be opened for MEM agentless monitoring?

• A. Port 21/tcp (ftp) from MySQL Enterprise Monitor to MySQL server
• B. Port 18443/tcp (Tomcat) from MySQL server to MySQL Enterprise Monitor
• C. Port 22/tcp (SSH) from MySQL Enterprise Monitor to MySQL server
• D. Port 3306/tcp (MySQL) from MySQL Enterprise Monitor to MySQL server

Answer: B

NEW QUESTION 4
Which three statements are true about MySQL Enterprise Backup?

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

Answer: BDE

NEW QUESTION 5
Which three options describe the setup of MySQL High Availability solutions?

• A. Setting up three machines configured as follows:Machine A with 2 x Data NodesMachine Bwith 2 x mysqld nodeMachine C with 2 x ndb_mgmd node
• B. setting up Master and Slave with MySQL Semi-Sync Replication Plugin
• C. creating an NFS volume with multiple running MySQL Server Instances attaching the same NFS Volume with the same datadit
• D. setting up three machines configured as follows:Machine 1: Data Node and mysqld nodeMachine 2: Data Node and mysqld nodeMachine 3: ndb_mgmd
• E. providing the Active/Passive setup of MySQL Server running on two machines with Shared Storage together with OSclustering to provide storage and Virtual IP failover

Answer: CDE

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

Answer: CD

NEW QUESTION 7
The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing.
The binlog size keeps growing. Identify two methods to fix the issue.

• A. Execute the PURGE BINARY LOGS statement without argument.
• B. On the Master server, disable binlog by removing the - - log –bin option.
• C. Delete all binlog files manually on the file system to release storage spaces.
• D. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
• E. To safely purge binary log files, perform the following steps:1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.3. Determine the earliest log file among all the slave
• F. This is the target fil
• G. If all the slaves are up-to-date, this is the last log file on the list.4. Make a backup of all the log files you are about to delet
• H. (This step is optional, but always advisable.)5. Purge all log files up to but not including the target file by using the PURGE BINARY LOGS statement.

Answer: DE

NEW QUESTION 8
After the installation of the MySQL Server, you cannot find MySQL Utilities. How would you correct the problem?

• A. MySQL Utilities comes with MySQL Enterprise Monito
• B. Download MySQL Enterprise Monitor to install.
• C. MySQL Utilities is installed with MySQL Server Binar
• D. Put the MySQL bin folder into PATH to allow execution.
• E. MySQL Utilities is a package from MySQL Connecto
• F. Download the MySQL/Connector and install.
• G. MySQL Utilities comes with MySQL Enterprise Backu
• H. Download MySQL Enterprise Monitor to install.
• I. MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL server
• J. Downloadthe MySQL Utilities separately from www.mysql.com.

Answer: E

NEW QUESTION 9
You are using the MySQL Enterprise Audit plug-in, and the audit.log file is corrupted. What steps would you perform to create a new audit file?

• A. As the root user, execute the FLUSH AUDIT LOGS comman
• B. Refresh the audit plug-in with SET GLOBAL audit_log_status =REFRESH.
• C. Stop the MySQL serve
• D. Move or rename the existing audit.log fil
• E. Restart the MySQL server.
• F. Stop the MySQL serve
• G. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME ‘audit_log.so’; Delete the corrupted fil
• H. Restart the MySQL server.
• I. As the root user, execute the SET GLOBAL audit_log_flush=ON command.

Answer: C

NEW QUESTION 10
The user ‘OS-user’@’localhost’ was created to monitor connections and shut down the server, and was granted the following privileges:
GRANT PROCESS, SHUTDOWN ON *.* to ‘OS-user’@’localhost’;
Identify three commands that the OS-user can execute.

• A. SHOW STATUS;
• B. SHUTDOWN;
• C. SHOW BINLOG EVENTS;
• D. SHOW PROCESSLIST;
• E. KILL PROCESS;

Answer: ABE

NEW QUESTION 11
For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the “Create SSH Keys function” during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps.

• A. You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.
• B. Convert the private key to ppk format first, and use the new private key for authentication.
• C. Use the providedprivate key for authentication.
• D. Open Port 22 on your MySQL CS Instance and convert the private key to ppk forma
• E. This new private key can be used for authentication.

Answer: D

NEW QUESTION 12
Identify three levels in which MySQL Enterprise Monitor provides access control.

• A. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services
• B. Asset visibility: the rights to access data collected from hosts or MySQL instances
• C. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
• D. Specific data access: the rights to view specific typesof potentially sensitive data
• E. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent

Answer: BCD

NEW QUESTION 13
Your customer has provided you with the following server specifications: 64-bit, Oracle Linux 6, 24 Numa CPU cores, 48 GB memory, and sequential write-optimized drives in the /var/lib/seq-write directory. The customer wants you to optimize their MySQL 5.7.10 installation for the server resources available.
Identify three correct configurations for this server setup.

• A. mysql_numa_interleave=ON,innodb_buffer_pool_instances=8, innodb_log_file_size=24G
• B. innodb_data_file_path=/var/lib/seq-write, innodb_buffer_pool_size=36G, innodb_page_cleaners=8
• C. innodb_file_per_table=ON, innodb_numa_interleave=ON, lower_case_table_names=1
• D. plugin_load= “thread_pool.so”, innodb_page_cleaners=12, innodb_log_group_home_dir=/var/lib/seq-write
• E. innodb_log_file_size=12G, innodb_buffer_pool_instances=12, innodb_buffer_pool_size=48G
• F. innodb_buffer_pool_instances=12, innodb_buffer_pool_size=24G, innodb_log_file_size=12G

Answer: ABE

NEW QUESTION 14
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

• A. TDE supports at-rest encryption for InnoDB tables stored in file-per-table tablespaces.
• B. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the KEY VAULT file.
• C. Both MyISAM and InnoDB table can be encrypted by setting the keyring_engine =ALL variable in theMySQL configuration file.
• D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

Answer: A

NEW QUESTION 15
You have the MySQL 5.7 database running. MySQL Enterprise Backup 3.12 is installed and it is used to back up the MySQL 5.7 database. The backup has failed. Identify the reason.

• A. MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later isrequired to back up MySQL 5.7.
• B. MySQL Workbench must be installed with MySQL Enterprise Backup to enable the backup to run successfully.
• C. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.
• D. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x providing that the MySQL 5.7 is pre-registered in the MySQL Enterprise Backup configuration file.
• E. mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the - -upgrade on MySQL 5.7 database to allow the mysql.backup_progress and mysql.backup_history tables to be patched.

Answer: C

NEW QUESTION 16
Select three privileges that are necessary to successfully back up a server instance with the mysqlbackup command after the initial installation.

• A. CREATE TEMPORARY TABLES
• B. REPLICATION CLIENT
• C. GRAND OPTION
• D. RELOAD
• E. INDEX

Answer: ABD

NEW QUESTION 17
Assume that MySQL Enterprise Monitor is configured to monitor MySQL 5.6 or a later instance. Which three features are available?

• A. Deploying MySQL Agent on supported target operating system
• B. Tracing import and export with mysqldump
• C. Monitoring the availability of the MySQL instance
• D. Creating E-Mail Alerts and SNMP Traps for MySQL Warnings
• E. Starting and Stopping the MySQL Instance
• F. Analyzing executed MySQL queries

Answer: ABD

NEW QUESTION 18
The replication setup for Master and Slave MySQL 5.6 instances is configured and running correctly without using Global Transaction ID (GTID).
You are required to perform a replication change to implement GTID for the MASTER and SLAVE configuration.
Which two steps would you perform?

• A. Restart MySQL (MASTER and SLAVE)with the following options enabled:- - gtid_mode=ON- - log-bin- -log-slave-updates- - enforce-gtid-consistency
• B. On the SLAVE, alter the mysql master connection setting with:> CHANGE MASTER TO>MASTER_HOST = host,>MASTER_PORT = port,>MASTER_USER=user,>MASTER_PASSWORD= password,>MASTER_AUTO_POSITION=1
• C. On the SLAVE, alter the mysql master connection setting with:> ALTER system CHANGE MASTER TO>MASTER_HOST = host,>MASTER_PORT = port,>MASTER_USER = user,>MASTER_PASSWORD= password,>MASTER_AUTO_POSITION=1
• D. Enable GTID by executing the following on MASTER and SLAVE:>set global GTID_ENALBED=on;
• E. Execute the following on SLAVE to enable GTID:>start slave io_thread - -gtid-mode=on;

Answer: AB

NEW QUESTION 19
You are required to set up a backup user (mysqlbackup@localhost) on the MySQL Database. The user should have the backup and restore privileges and additional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables.
Which syntax accomplishes this?

• A. CREATE USER ‘mysqlbackup’@localhost’IDENTIFIED BY ‘new-password’;
• B. CREATE USER ‘mysqlbackup’@localhost’ IDENTIFIED BY ‘new-password’;GRANT RELOAD ON*.* TO ‘mysqlbackup’@’localhost’;GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’;GRANT REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’;GRANT SUPER ON *.* TO ‘mysqlbackup’@’ localhost;GRANT PROCESS ON *.* ‘mysqlbackup’@’localhost’;
• C. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;GRANT RELOAD ON *.* TO ‘’mysqlbackup’@’localhost’;GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@localhost’;
• D. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;GRANT RELOAD ON *.* to ‘mysqlbackup’@localhost’;GRANT CREATE, INSERT, DROP, UPDATE ON, mysql.backup_progress TO ‘mysqlbackup’@’localhost’;GRANT CREATE, INSERT, SELECT, DROP, UPDATE ONmysql.backup_history TO ‘mysqlbackup’@’localhost’;GRANT REPLICATION CLIENT ON *.* to ‘mysqlbackup’@’localhost’;GRANT SUPER ON *.* TO ‘mysqlbackup’@’localhost’;GRANT PROCESS ON *.* TO ‘mysqlbackup’@’localhost’;GRANT LOCK TABLES, SELECT, CREATE, ALTER ON *.* TO ‘mysqlbackup’@’localhost’;GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_sbt_history TO ‘mysqlbackup’@’localhost’;
• E. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;GRANT RELOAD ON *.* TO ‘mysqlbackup’@’localhost’;GRANT CREATE, INSERT,DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’;GRANT REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’;

Answer: A

NEW QUESTION 20
You have the following mysqlbackup-inc.cnf config file:

Which two commands allow MySQL Enterprise Backup to perform incremental backup based on the last full backup?

• A. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 –-user=mysqlbackup–-password –-with-timestamp backup
• B. # mysqlbackup–-defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup–-password –-incremental backup-to-image
• C. # mysqlbackup –-defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup–-password backup-incremental
• D. # mysqlbackup –defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup–-password backup-to-incremental
• E. # mysqlbackup –-defaults-file=mysqlbackup-inc.cnf –-port=3306 –-host=127.0.0.1 –-user=mysqlbackup–-password incremental

Answer: B

Explanation:
Reference https://downloads.mysql.com/docs/mysql-enterprise-backup-3.8-en.a4.pdf

NEW QUESTION 21
......