Oracle 1Z0-921 問題集

質問 1：
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. Altering the storage engine for all tables to memory to increase performance.
E. Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.
正解：A,D

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

質問 3：
Which three options are valid reasons for using a primary key in a table?
A. maintaining a history of row insertions or updates
B. automatic storage of data in a sorted order
C. increasing performance when using select statements
D. to make it easier to change the PRIMARY KEY value
E. exporting data faster with mysqldump
F. preventing duplicate keys
正解：C,E,F

質問 4：
Which statement would you use to remove the population column from the city table?
A. DELETE population FROM city;
B. ALTER TABLE city DELETE population;
C. DROP population FROM city;
D. ALTER TABLE city DROP population;
E. ALTER TABLE city LESS population;
正解：D

質問 5：
Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?
A. The opc user can be used to access MySQL only with the created SSH-Key.
B. The OCI instance is still in the "creation" process.
C. You forgot to create the correct SSL/TLC certificate during the setup process.
D. Only root is allowed to access from non-localhost.
E. You forgot to enable port 3306.
正解：E

質問 6：
Which three are levels in which MySQL Enterprise Monitor provides access control?
A. Asset visibility: the rights to access data collected from hosts or MySQL instances
B. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
C. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent
D. Specific data access: the rights to view specific types of potentially sensitive data
E. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services
正解：A,B,D

質問 7：
Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?
A. SQL Enterprise Monitor and MySQL Enterprise Authentication
B. MySQL Enterprise Monitor and MySQL Audit
C. MySQL Audit and MySQL Workbench
D. MySQL Workbench and MySQL Enterprise Firewall
正解：A

質問 8：
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