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

出題：1

The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

A. innodb_log_file_size=1G

B. buffer_pool_size=24G

C. innodb_flush_log_at_trx_commit=1

D. max_connections=10000

E. innodb_undo_directory=/dev/shm

F. sync_binlog=0

G. innodb_doublewrite=0

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

出題：2

Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?

A. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql

B. mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql

C. mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql

D. mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql

正解：B 解答を投票する

出題：3

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

A. cluster.setPrimaryInstance()

B. cluster.forceQuorumUsingPartitionOf()

C. dba.configureInstance()

D. cluster.addInstance()

E. dba.createCluster()

F. dba.checkInstanceConfiguration()

G. dba.configureLocalInstance()

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

出題：4

Examine this statement and output:

Which two SQL statements can jsmith execute? (Choose two.)

A. UPDATE world.country SET Name=CONCAT('New ',Name);

B. UPDATE world.country SET Name='one' LIMIT 1;

C. UPDATE world.country SET Name='new' WHERE Name='old';

D. UPDATE world.country SET Name='all';

E. UPDATE world.country SET Name='first' ORDER BY Name LIMIT

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

出題：5

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

A. InnoDB Data Dictionary

B. user privileges

C. table data

D. doublewrite buffer

E. primary indexes

F. change buffer

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

出題：6

Which two statements are true about MySQL Enterprise Backup? (Choose two.)

A. It supports backing up only table structures.

B. It supports the creation of incremental backups.

C. It can perform hot or warm backups.

D. It supports backup of a remote MySQL system.

E. It supports restoring to a remote MySQL system.

F. It creates logical backups.

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

出題：7

Which three are characteristics of a newly created role? (Choose three.)

A. It can be granted to user accounts.

B. It is created as a locked account.

C. It is stored in the mysql.role table.

D. It can be protected with a password.

E. It can be dropped using the DROP ROLE statement.

F. It can be renamed using the RENAME ROLE statement.

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

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

出題：8

Which two statements are true about MySQL server multi-source replication? (Choose two.)

A. It needs to be re-instanced after a crash to maintain consistency.

B. It does not attempt to detect or resolve replication conflicts.

C. It uses only time-based replication conflict resolution.

D. It is not compatible with auto-positioning.

E. It must use GTID replication.

F. It relies on relay_log_recovery for resilient operations.

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

出題：9

Examine this output:

Which change should optimize the number of buffer pool instances for this workload?

A. Decrease the number of buffer pool instances to 1.

B. Increase the number of buffer pool instances to 12.

C. Decrease the number of buffer pool instances to 4.

D. Increase the number of buffer pool instances to 32.

E. Increase the number of buffer pool instances to 16.

正解：D 解答を投票する

出題：10

Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

A. It supports all indexes transparently.

B. It does not support the transportable tablespaces feature.

C. It supports only non-blob datatypes.

D. It enforces encryption from disk to memory and over network transmission.

E. It decrypts data for use in memory.

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

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