1Z1-921問題集、Oracle実際の試験問題

質問 1

Which three statements are true about MySQL Enterprise Backup?

A. It cannot back up encrypted tablespaces.

B. It performs logical backups.

C. It performs hot or warm backups.

D. It provides the ability to create incremental backups.

E. It enables you to take non-locking backups.

正解: B,D,E

質問 2

Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

A. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.

B. MySQL Online Hot Backup to keep data consistent and always ready to be used.

C. MySQL Servers with Group Replication to replicate data to all members of the cluster.

D. MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.

E. MySQL Router to ensure client requests are load balanced and routed to the correct servers.

正解: C,D,E

質問 3

Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

A. authentication using SHA-256 password hashing

B. authentication via Pluggable Authentication Modules (PAMs)

C. Simple Authentication and Security Layer

D. Native Windows services

E. connections through the local host via the UNIX socket file

F. SECURID authentication and authorization identity

正解: A,B,D,E

質問 4

Which two statements are correct about MySQL Enterprise Edition?

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

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

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

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

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

正解: C,D

質問 5

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

A. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.

B. Execute the purge binary logs statement without argument.

C. To safely purge binary log files, perform these steps:

D. On the Master server, disable binlog by removing the --log-bin option.

E. Delete all binlog files manually on the file system to release storage spaces.

正解: A,C

質問 6

Which statement will display the status of the partitioning plug-in?

A. USE SYS SCHEMA; SHOW PLUGINS STATUS;

B. SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';

C. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';

D. SHOW PLUGINS WHERE Name= 'partition';

正解: C

質問 7

Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

A. Only the t2 table is created.

B. Only the t1 table is created.

C. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

D. Both the tables, t1 and t2, are created.

正解: D

質問 8

Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:

A. Query Analyzer

B. MySQL Advisors

C. MySQL Query Analyzer

D. MySQL Dashboard

正解: C

Oracle MySQL 2021 Implementation Essentials - 1Z1-921 模擬練習