Online Access Free 1Z1-921 Practice Test

The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?

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

Which statement would you use to remove the population column from the city table?

• A.ALTER TABLE city LESS population;
• B.DELETE population FROM city;
• C.DROP population FROM city;
• D.ALTER TABLE city DROP population;
• E.ALTER TABLE city DELETE population;

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

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