1Z0-908試験無料問題集（142題）「Oracle MySQL 8.0 Database Administrator 認定」

出題：1

Examine these statements and output:

Which statement is true?

A. The user failed to define a username and the connecting username defaulted to ''@'%'.

B. The user is authenticated as the anonymous proxy user ''@'%'.

C. The user is logged in with --user=accounting as an option.

D. The user is authorized as the rsmith@localhost user.

E. The user is authorized as the accounting@localhost user.

正解：D 解答を投票する

出題：2

You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?

A. error log

B. audit log

C. general query log

D. binary log

E. slow query log

正解：D 解答を投票する

出題：3

You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

A. ib_logfile* files

B. *.CSM files

C. ibbackup files

D. *.sdi files

E. *.ibd files

正解：A,E 解答を投票する

出題：4

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, excluding master metadata, are backed up to the output file.

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

C. All databases are backed up to the output file.

D. All binary logs are deleted from the master.

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

F. All binary logs are backed up and then deleted.

正解：A,D 解答を投票する

出題：5

Examine these InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.
Which two statements are true? (Choose two.)

A. The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')

B. Failure of the instance deployed on host1 provokes an outage.

C. The primary instance can be specified by using the command
cluster.setPrimaryInstance(<host>:<port>).

D. The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.

E. The instance deployed on host2 is elected as the new primary instance.

F. The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.

正解：C,D 解答を投票する

出題：6

A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

A. undo_001

B. mysql.ibd

C. ibtmp1

D. ib_logfile0

E. ibdata1

F. ib_buffer_pool

正解：B,F 解答を投票する

出題：7

Examine this query and its output:

Which two statements are true? (Choose two.)

A. The root user had the largest number of modified rows for a SELECT statement.

B. User bob had the largest total time waiting for locks.

C. User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

D. The app user had the highest total number of rows read from storage engines.

E. The root user had the largest single wait time.

正解：C,D 解答を投票する

出題：8

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 --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

C. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

D. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

E. The mysqlcheck --optimize --all-databases command reclaims free space from table files.

正解：B,C 解答を投票する

出題：9

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

A. INFORMATION_SCHEMA.INNODB_METRICS

B. SHOW ENGINE INNODB STATUS;

C. SHOW TABLE STATUS;

D. SHOW STATUS;

E. INFORMATION_SCHEMA.INNODB_TABLESTATS

F. INFORMATION_SCHEMA.STATISTICS

正解：E,F 解答を投票する

出題：10

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?

A. Replication will work.

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

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

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

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

正解：B 解答を投票する

1Z0-908試験無料問題集「Oracle MySQL 8.0 Database Administrator 認定」