Oracle 1Z0-921 問題集

質問 1：
Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?
A. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent
B. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
C. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
D. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
E. A browser-based wizard to remotely deploy the MySQL Monitor Agent
正解：B,C,D

質問 2：
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.

正解：C

質問 3：
You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?
A. Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.
B. Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.
C. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
D. Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
正解：B

質問 4：
Which three statements are true about MySQL Enterprise Backup?
A. It enables you to take non-locking backups.
B. It performs logical backups.
C. It performs hot or warm backups.
D. It cannot back up encrypted tablespaces.
E. It provides the ability to create incremental backups.
正解：A,B,E

質問 5：
Which statement will display the status of the partitioning plug-in?
A. SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';
B. USE SYS SCHEMA; SHOW PLUGINS STATUS;
C. SHOW PLUGINS WHERE Name= 'partition';
D. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';
正解：D

質問 6：
Which two are advantages of using Document Store in MySQL?
A. MySQL can store XML as a schema-less database
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 is a document database allowing PDF and Word documents
正解：A,D

質問 7：
You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?
A. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
B. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
C. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
D. Use mysqldump with the - -changesonly option.
E. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.
正解：C,D

質問 8：
MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. Which three are MySQL Enterprise Masking and De-identification functions?
A. strict or relaxed masking
B. random data substitution
C. whitelisting and substitution
D. dictionary substitution
E. misspelling
正解：A,B,D