[2024年01月] 問題集簡単概要1z1-908試験問題Fast2test [Q72-Q89]

[2024年01月] 問題集簡単概要1z1-908試験問題Fast2test

1z1-908トレーニング認証最新版をゲットMySQL Database Administration

Oracle 1Z0-908試験は、MySQL 8.0データベース管理における候補者の知識とスキルの厳密で挑戦的なテストです。ただし、適切な準備と学習資料により、候補者は自信を持って準備を整え、試験に合格し、認定を取得することができます。

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

A. They are pulled from the master to the slave.
B. They contain events that describe all queries run on the master.
C. They contain events that describe database changes on the master.
D. They contain events that describe only administrative commands run on the master.
E. They are pushed from the master to the slave.

正解：C、E

質問 # 73
Examine these statements and output:

Which statement is true?

A. The user is authenticated as the anonymous proxy user ''@'%'.
B. The user is authorized as the rsmith@localhost user.
C. The user is logged in with --user=accounting as an option.
D. The user failed to define a username and the connecting username defaulted to ''@'%'.
E. The user is authorized as the accounting@localhost user.

正解：B

質問 # 74
Which three are types of information stored in the MySQL data dictionary? (Choose three.)

A. server runtime configuration
B. performance metrics
C. stored procedure definitions
D. server configuration rollback
E. InnoDB buffer pool LRU management data
F. view definitions
G. access control lists

正解：A、B、F

質問 # 75
Examine this query:

What information does this query provide?

A. total memory used across all connections associated with the user on thread number 10
B. total memory used by the first 10 threads
C. total memory used by connection number 10
D. total memory used by thread number 10
E. total memory used by the first 10 connections
F. total memory used across all connections associated with the user on connection number 10

正解：C

質問 # 76
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

A. Use systemdwith different settings for each instance.
B. Use resource groups to lock different instances on separate CPUs.
C. Use system tools to lock each instance to its own CPU.
D. Run mysqldwith --datadirdefined for each instance.
E. Run MySQL Server docker containers.
F. Start mysqldor mysqld_safeusing different option files for each instance.

正解：A、D、F

解説：
Explanation/Reference:

質問 # 77
Which two are characteristics of snapshot-based backups? (Choose two.)

A. Snapshot backups can be used only in virtual machines.
B. The frozen file system can be cloned to another virtual machine immediately into active service.
C. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
D. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.
E. A separate physical copy must be made before releasing the snapshot backup.

正解：A、E

質問 # 78
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.)

A. All databases are backed up to the output file.
B. All databases, excluding master metadata, are backed up to the output file.
C. All binary logs are deleted from the master.
D. All binary logs are backed up and then deleted.
E. All details regarding deleted logs and master metadata are captured in the output file.
F. All non-active binary logs are removed from the master.

正解：B、C

質問 # 79
How can mysql_multi be configured to allow MySQL instances to use the same port number?

A. The instances use different user accounts unique to each instance.
B. The instances use different socket names.
C. The instances have appropriate net masks set.
D. The instances listen on different IP addresses.

正解：D

質問 # 80
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

A. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
B. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
C. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
D. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
E. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

正解：B、E

質問 # 81
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?

A. Roll back the transaction and start the transaction again in the same session.
B. Close the connection, reconnect, and start the transaction again.
C. Re-execute the failed statement in your transaction.
D. Change the default database and re-execute the failed statement in your transaction.

正解：C

質問 # 82
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

A. cluster.setPrimaryInstance()
B. cluster.addInstance()
C. dba.configureInstance()
D. dba.checkInstanceConfiguration()
E. cluster.forceQuorumUsingPartitionOf()
F. dba.createCluster()
G. dba.configureLocalInstance()

正解：A、E

質問 # 83
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)

A. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
B. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency
C. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
D. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on;
E. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
F. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID;

正解：A、B

質問 # 84
Examine this statement, which executes successfully:

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?

A. ALTER TABLE world.city ADD INDEX (Population);
B. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
C. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
D. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
E. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
F. ALTER TABLE world.city ADD INDEX (Name);

正解：B

質問 # 85
You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:

Which action would allow the server to start?

A. Remove ib_logfile0 and ib_logfile1 files from the file system.
B. Create a new ib_logfile0 file of size 26214400.
C. First run mysqld --initialize to refresh the Size of ib_logfile.
D. Execute mysqladmin flush-logs.

正解：C

質問 # 86
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.)

A. Remove the group replication plugin from each instance before restoring.
B. Restore using the --set-gtid-purged=OFF option.
C. Create the backup by using the --set-gtid-purged=OFF option.
D. Remove the @@GLOBAL.gtid_purged statement from the dump file.
E. Stop all instances except the primary read/write master instance and run the restore.
F. Remove the @@GLOBAL.gtid_executed statement from the dump file.

正解：C、D

質問 # 87
Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)