최신Oracle MySQL 8.0 Database Administrator - 1z1-908무료샘플문제

A. InnoDB tablespaces outside the datadir are able to be cloned.

B. The account used to perform this recovery needs the BACKUP_ADMIN privilege.

C. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.

D. It is always slower than {recoveryMethod: 'incremental'}.

E. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.

F. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.

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 only administrative commands run on the master.

D. They contain events that describe database changes on the master.

E. They are pushed from the master to the slave.

A. primary key or primary key equivalent on every table

B. replication filters

C. binary log ROW format

D. binary log MIXED format

E. binary log checksum

F. semi-sync replication plugin

G. slave updates logging

A. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

B. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

C. The cluster will shut down to preserve data consistency.

D. A manual intervention to force group members to be only the working two instances is required.

E. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

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

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

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

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

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

A. global_variables

B. variables_by_thread

C. user_variables_by_thread

D. session_variables

A. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

B. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

C. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

D. Updating index statistics is an I/O expensive operation.

E. Tables are scanned and index statistics recalculated when an instance is restarted.

F. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

A. It supports the creation of incremental backups.

B. It supports backing up only table structures.

C. It supports backup of a remote MySQL system.

D. It supports restoring to a remote MySQL system.

E. It can perform hot or warm backups.

F. It creates logical backups.