[2025年09月11日]1Z0-908試験問題集でOracle練習テスト問題 [Q17-Q37]

Rate this post

[2025年09月11日]1Z0-908試験問題集でOracle練習テスト問題

最新でリアルな1Z0-908試験問題集解答

Oracle 1Z0-908試験の準備をするためには、MySQLデータベース管理のコンセプトとテクニックをしっかりと理解している必要があります。また、MySQLデータベースでの実務経験があり、最新バージョンのMySQLにも精通している必要があります。候補者は、公式のOracle学習ガイド、練習試験、オンライントレーニングコースなど、さまざまな学習資料を活用して、試験の準備をし、成功する可能性を高めることができます。

質問 17
You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

Stop all instances except the primary read/write master instance and run the restore.

Remove the @@GLOBAL.gtid_purged statement from the dump file.

Create the backup by using the –set-gtid-purged=OFF option.

Remove the group replication plugin from each instance before restoring.

Remove the @@GLOBAL.gtid_executed statement from the dump file.

Restore using the –set-gtid-purged=OFF option.

質問 18
Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

It reconfigures InnoDB Cluster if the cluster was stopped.

It performs InnoDB Cluster instances rolling restart.

It only starts all InnoDB Cluster instances.

It is not mandatory that all instances are running and reachable before running the command.

It stops and restarts all InnoDB Cluster instances and initializes the metadata.

It only stops and restarts all InnoDB Cluster instances.

It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

質問 19
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;

RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

質問 20
Which two statements are true about MySQL Installer? (Choose two.)

It installs most Oracle MySQL products.

It performs product upgrades.

It provides only GUI-driven, interactive installations.

Manual download of separate product packages is required before installing them through MySQL Installer.

It provides a uniform installation wizard across multiple platforms.

質問 21
Examine this command and output:

Which statement is true?

Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

Firewall_access_granted is the number of connections granted from whitelisted hosts.

質問 22
You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories=’/innodb_extras’ Which statement is true?

It defines all innodb tablespace options relative to a starting parent directory.

It is not necessary because innodb_data_home_dir is already defined.

It allows scanning of other locations to discover more innodb tablespaces.

It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

It adds more temporary workspace in addition to the innodb_tmpdir location.

質問 23
You execute this command:
shell> mysqlpump –exclude-databases=% –users
Which statement is true?

It creates a logical backup of all MySQL user accounts.

It creates a logical backup of all metadata, but contains no table data.

It returns an error because the mysqldumpcommand should have been used.

It creates a logical backup of only the usersdatabase.

質問 24
Examine the modified output:

Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)

The master is most probably too busy to transmit data and the slave needs to wait for more data.

One or more large tables do not have primary keys.

This value shows only I/O latency and is not indicative of the size of the transaction queue.

The master is producing a large volume of events in parallel but the slave is processing them serially.

The parallel slave threads are experiencing lock contention.

質問 25
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?

Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.

Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.

Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.

Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.

Replication will work.

質問 26
Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
…..
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump –delete-master-logs –all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)

All databases are backed up to the output file.

All non-active binary logs are removed from the master.

All binary logs are deleted from the master.

All binary logs are backed up and then deleted.

All databases, excluding master metadata, are backed up to the output file.

All details regarding deleted logs and master metadata are captured in the output file.

質問 27
Examine these statements and output:

Which statement is true?

The user is logged in with –user=accountingas an option.

The user is authenticated as the anonymous proxy user ‘’@’%’.

The user is authorized as the accounting@localhostuser.

The user is authorized as the rsmith@localhostuser.

The user failed to define a username and the connecting username defaulted to ‘’@’%’.

質問 28
You execute this command:
shell> mysqlpump –exclude-databases=% –users
Which statement is true?

It creates a logical backup of all MySQL user accounts.

It creates a logical backup of all metadata, but contains no table data.

It returns an error because the mysqldump command should have been used.

It creates a logical backup of only the users database.

質問 29
Which two are true about binary logs used in asynchronous replication? (Choose two.)

They are pushed from the master to the slave.

They contain events that describe database changes on the master.

They contain events that describe all queries run on the master.

They contain events that describe only administrative commands run on the master.

They are pulled from the master to the slave.

質問 30
Examine this command and output:

Which two statements are true? (Choose two.)

The lock is at the metadata object level.

The lock is a shared lock.

The lock is an intentional lock.

The lock is at the table object level.

The lock is a row-level lock.

The lock is an exclusive lock.

質問 31
Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

sort_buffer_size

key_buffer_size

table_open_cache

read_buffer_size

innodb_buffer_pool_size

tmp_table_size

質問 32
Examine this query and output:

Which two statements are true? (Choose two.)

The countrytable is accessed as the first table, and then joined to the city table.

It takes more than 8 milliseconds to sort the rows.

The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.

35 rows from the city table are included in the result.

The query returns exactly 125 rows.

質問 33
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?
RESET MASTER;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-

bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER;

SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

質問 34
Which three requirements must be enabled for group replication? (Choose three.)

slave updates logging

semi-sync replication plugin

primary key or primary key equivalent on every table

binary log checksum

binary log ROW format

binary log MIXED format

replication filters

質問 35
You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your data.
Examine your backup requirement:
* The MySQL system being backed up can never be unavailable or locked to the client applications.
* The recovery from the backup must work on any system.
* Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

Take a physical backup of the MySQL system.

Use the Clone Plugin to copy the data to another MySQL system.

Take a logical backup of the MySQL system.

Take your backup from a slave of the MySQL system.

質問 36
Which two are true about binary logs used in asynchronous replication? (Choose two.)

They are pushed from the master to the slave.

They contain events that describe database changes on the master.

They contain events that describe all queries run on the master.

They contain events that describe only administrative commands run on the master.

They are pulled from the master to the slave.

質問 37
You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host
192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

–shared-memory-base-name=world

–protocol=UDP

–protocol=pipe

–password

–user=admin

–host=192.0.2.1

–socket=/tmp/mysql.sock

–port=3306

–database=world