Free Oracle 1Z1-921 Exam Dumps Questions & Answers

When should you perform a backup in a MySQL database?
Response:

• A.  Only when the database size exceeds a certain limit.
• B.  After critical data updates or before making significant changes to the database.
• C.  After every successful query execution.
• D.  Only during scheduled maintenance windows.

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. 

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

• A.  starting and stopping the MySQL instance
• B.  analyzing executed MySQL queries
• C.  deploying MySQL agent on supported target operating system
• D.  creating e-mail alerts and SNMP traps for MySQL warnings
• E.  monitoring the availability of the MySQL Instance
• F.  tracing import and export with mysqldump

What are the two main components required to set up persistent storage for MySQL on Kubernetes?
Response:

• A.  PVC (Persistent Volume Claim) and ConfigMap
• B.  PVC (Persistent Volume Claim) and PV (Persistent Volume)
• C.  Secret and Deployment
• D.  Pod and ReplicaSet

Which three are characteristics of the JSON data type?

• A.  A set of SQL functions substantially support the SQL utilization of the data type.
• B.  It validates the JSON syntax on insert or merge.
• C.  Key or array references enable quick read-access to look up document elements directly.
• D.  It supports indexing directly against the JSON-defined column.
• E.  It is based on the TEXT data type.
• F.  Comparisons of JSON values are not case-sensitive.