Oracle MySQL 2021 Implementation Essentials - 1Z0-921 Free Exam Questions

A. MySQL is a document database allowing PDF and Word documents

B. MySQL provides a native data type to store JSON data as a document

C. MySQL provides a native data type to index PDF documents

D. MySQL provides a NoSQL API to access the document store

E. MySQL can store XML as a schema-less database

A. ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;

B. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);

C. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);

D. ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;

A. Any new lines can only be inserted at the end of the document.

B. You cannot insert a single line, you have to replace the entire document with a new document.

C. You specify the new element,s position in the JSON_ARRAY_INSERT statement.

D. The path specified must be an array position past the end of an array using the JSON_POSITION statement.

A. Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.

B. Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.

C. Increasing the storage capacity so that the database can store more data to scale.

D. Allocating more CPU to the database instance to improve throughput performance.

E. Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.

A. monitoring the availability of the MySQL Instance

B. tracing import and export with mysqldump

C. analyzing executed MySQL queries

D. creating e-mail alerts and SNMP traps for MySQL warnings

E. deploying MySQL agent on supported target operating system

F. starting and stopping the MySQL instance

A. The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.

B. The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.

C. You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.

D. The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.

A. CREATE USER ,joe'@,0.0.0.0, SET Password=PASSWORD(,% ! %,)

B. Insert Joe,s name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

C. REVOKE ALL PRIVILEGES, GRANT OPTION FROM ,joe,@,%,;

D. UPDATE mysql.user SET Password=PASSWORD(,Invalid,) WHERE User=,joe';

E. CREATE USER , joe,@1' %' DENY ALL PRIVILEGES

A. MySQL Enterprise Backup provides the point-in-time recovery functionality.

B. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.

C. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.

D. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.

E. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.