1Z0-921 by Oracle Valid Free Exam Practice Test

Question 1

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

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

Correct Answer: B

Question 2

Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

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

Correct Answer: B

Question 3

You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

A. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice. B. You need to agree to the maintenance windows. If not, you are not affected by the outage. C. You can expect an outage of your MySQL OCI instance during the planned time.. D. There are no maintenance operations planned. You need to do them manually.

Correct Answer: C

Question 4

Which three are levels in which MySQL Enterprise Monitor provides access control?

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

Correct Answer: A,B,D

Question 5

You are using the innoDB engine and the innodb_f ile_per_table option is set.
You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory.
What will happen to the inventory table?

A. The table will be optimized and replicated. B. The table storage space will be reduced. C. The table will be checked for errors and repaired. D. The table statistics will be stored.

Correct Answer: A

Question 6

You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

A. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances. B. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances. C. Go to the configuration section (MEM) and configure the default login credentials. D. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.

Correct Answer: B

Question 7

Which two methods help prevent MySQL security risks?

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

Correct Answer: A,D

Question 8

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.

Correct Answer: A

Oracle MySQL 2021 Implementation Essentials - 1Z0-921 Exam Practice Test