1Z0-922問題集、Oracle実際の試験問題

質問 1

Which MySQL tool allows administrators to monitor resource usage such as memory, CPU, and disk I/O?

A. MySQL Enterprise Backup

B. Performance Schema

C. MySQL Replication

D. MySQL Query Optimizer

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 2

Which MySQL system database stores information about users and their privileges?

A. performance_schema

B. sys

C. mysql

D. information_schema

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 3

Which MySQL command is used to display a list of all active users connected to the database?

A. SHOW USERS;

B. SHOW PROCESSLIST;

C. SHOW CONNECTIONS;

D. SHOW PRIVILEGES;

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 4

Which two options are available for configuring backups using MySQL Enterprise Backup?

A. Encrypted backup

B. Compressed backup

C. Logical backup

D. Full backup

正解: A,D

解説: (PassTest メンバーにのみ表示されます)

質問 5

What is the key benefit of using compressed backups with MySQL Enterprise Backup?

A. Improved database performance during backups

B. Faster backup times

C. Reduced storage requirements for the backup files

D. Increased encryption levels for the backup

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 6

Which MySQL Enterprise Edition tool is used to monitor and track the performance of MySQL databases?

A. Enterprise Firewall MySQL Role-

B. Enterprise Monitor MySQL

C. Based Access Control

D. MySQL Enterprise Backup MySQL

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 7

How can you disable binary logging for a MySQL session?

A. SET BINLOG_DISABLE = 1

B. SET SQL_LOG_BIN = 0

C. SET BIN_LOG = OFF

D. SET BINLOG_LOGGING = 0

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 8

Which MySQL replication mode is most vulnerable to data loss in the event of a primary server crash?

A. Synchronous replication

B. Asynchronous replication

C. Multi-source replication

D. Semi-synchronous replication

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 9

In MySQL Group Replication, what happens when a primary server fails?

A. All transactions are rolled back

B. The failed primary server is automatically replaced by another server

C. The replica continues serving traffic

D. Replication stops until the primary is restored

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 10

When installing MySQL Enterprise Server, which configuration file is primarily used to set server parameters?

A. /usr/mysql/config.cnf

B. /var/mysql/settings.conf

C. /etc/my.cnf

D. /etc/mysql/server.cnf

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 11

Which two benefits are provided by MySQL InnoDB Cluster in terms of high availability?

A. Automatic failover in case of node failure

B. Consistent backups

C. Zero-downtime maintenance

D. Single-point-of-failure protection

正解: A,C

解説: (PassTest メンバーにのみ表示されます)

質問 12

What is the role of MySQL Router in a high availability environment?

A. It manages backup operations

B. It routes traffic to available and healthy nodes in the cluster

C. It balances load between primary and replica servers

D. It logs transactions for replication

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 13

How does MySQL InnoDB Cluster ensure data consistency across all nodes?

A. By optimizing query execution times

B. By performing asynchronous replication

C. By using Group Replication with quorum-based voting

D. By using statement-based replication

正解: C

解説: (PassTest メンバーにのみ表示されます)

Oracle MySQL Implementation Associate - 1Z0-922 模擬練習