Oracle MySQL 8.0 Database Administrator - 1Z0-908무료 덤프문제 풀어보기

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

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

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

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

A. The slave needs to be restored from backup.

B. The slave relay logs should be deleted; then execute START SLAVE;

C. The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D. The relay logs from the master should be used to replace the corrupted relay logs.

A. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.

B. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.

C. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.

D. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.

A. It manages the configuration of the MySQL Firewall feature.

B. It provides an interface to change my.cnf files.

C. It can move datadir to a new location.

D. It manages the configuration of user privileges for accessing the server.

E. It manages the configuration of client programs.

F. It will use [client] options by default unless you provide --login-path.

G. It can be used to create and edit SSL certificates and log locations.

A. world

B. mysql

C. employee

D. information_schema

E. sys

A. server runtime configuration

B. InnoDB buffer pool LRU management data

C. server configuration rollback

D. table definitions

E. view definitions

F. access control lists

G. stored procedure definitions

H. performance metrics

A. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

B. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

C. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

D. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

A. Look for queries with low total latency times in the Latency section in the times series graph.

B. Look for queries with big prolonged spikes in row activity/access graph in the times series graph.

C. Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.

D. Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.

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 is not compatible with auto-positioning.

D. It must use GTID replication.

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

F. It relies on relay_log_recovery for resilient operations.

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 root user had the largest single wait time.

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

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