1Z1-921 by Oracle Actual Free Exam Q&As

Question 1

How does MySQL HeatWave improve query performance?
Response:

A. By automatically creating indexes on frequently used columns. B. By offloading analytics queries to an in-memory, highly parallel processing engine. C. By caching the entire database in memory. D. By replicating data across multiple servers.

Discussion 0

Correct Answer: B Vote an answer

Question 2

You execute this statement:
SELECT NULL=NULL;
What is the result?

A. TRUE B. 0 C. NULL D. 1 E. FALSE

Discussion 0

Correct Answer: C Vote an answer

Question 3

Which three prerequisites are needed for creating an Oracle Linux VM instance in the Oracle Cloud Infrastructure?

A. existing VCN B. Custom Image C. ssh key pair D. subnet configured on a Virtual Cloud Network (VCN) E. bare metal Oracle Linux shape F. Object Storage

Discussion 0

Correct Answer: B,E,F Vote an answer

Question 4

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.

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which two statements are correct about MySQL Enterprise Edition?

A. Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances. B. Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II). C. MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network. D. MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance. E. MySQL configuration can be changed in /etc/lib/myi.cnf.

Discussion 0

Correct Answer: B,E Vote an answer

Question 6

Which MySQL Enterprise Edition plug-in replaces real values with substitutes?

A. MySQL Enterprise No-Login Authentication B. MySQL Enterprise Data Masking and De-identification C. MySQL Enterprise Transparent Data Encryption (TDE) D. MySQL Enterprise Scalability E. MySQL Enterprise Audit

Discussion 0

Correct Answer: B Vote an answer

Question 7

Which two methods help prevent MySQL security risks?

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

Discussion 0

Correct Answer: B,F Vote an answer

Question 8

The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being monitored with suitable privileges to collect information about the server.
Which statement is correct?

A. MySQL Enterprise Monitor creates the required users automatically. B. The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS. C. Monitoring metrics need super and root privileges because they are not available for a less-privileged user. D. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

Discussion 0

Correct Answer: B Vote an answer

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