[2026] Oracle MySQL 2021 Implementation Essentials

문제1

Which is true about inserting an additional line in a single document stored in MySQL document store?

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

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

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

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

정답: D

문제2

Which two statements are correct about MySQL Enterprise Edition?

A. MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.

B. MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.

C. Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.

D. Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II).

E. MySQL configuration can be changed in /etc/lib/myi.cnf.

정답: D,E

문제3

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.

정답: A

문제4

Which two deployment architectures could you use for scaling-out database reads?

A. Implementing a three-node, single-primary InnoDB Cluster.

B. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.

C. Edit the configuration file and increase the value for parallel_read_workers and reboot the server

D. Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.

E. Altering the storage engine for all tables to memory to increase performance.

정답: A,E

문제5

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. --uncompress

B. --copy-back-and-apply-log

C. --uncompress-and-apply-log

D. --apply-log-and-copy-back

E. --decompress

정답: A,B

문제6

What are Security Lists in Oracle Cloud Infrastructure?

A. They allow administrators access to applications in the cloud and external servers.

B. They are essentially firewall rules that help control traffic between OCI instances.

C. Security lists are data encryption levels that control who can see the data.

D. They are user-role designations that assign rights to certain internal users and external users.

E. They contain rules established by HIPAA for securing end-user data.

정답: B

문제7

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?

Oracle MySQL 2021 Implementation Essentials - 1Z1-921무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트