Free Oracle 1Z0-921 Exam Dumps Questions & Answers

You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Which two are possible reasons for this problem?

• A.  All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.
• B.  The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
• C.  The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.
• D.  The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
• E.  The MASTER and SLAVE are grouped as one instance for monitoring.

You need to change the password level for a test system.
Which two allow to change this level before you create new test user/passwords?

• A.  SET GLOBAL force_password_complex_policy=0;
• B.  Add validate_password_policy=,new level, in the [mysqld] section of the MySQL configuration file.
• C.  Add validate_password=,new level, in the [security] section of the MySQL configuration file.
• D.  SET GLOBAL validate_password_policy=,new level,;

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

You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?

• A.  1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.
• B.  1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.
• C.  1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving--hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.
• D.  1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.

Which activity will take place if a table is created with both the compression and encryption options?

• A.  The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.
• B.  The compression is performed before tablespace data is encrypted.
• C.  The tablespace data is encrypted first and then compression is performed.
• D.  The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.