1z0-883 無料問題集「Oracle MySQL 5.6 Database Administrator」

（A）It deletes all binary log files before 'mysql-bin.010'.

（B）It deletes all binary log files up to and including 'mysql-bin.010'.

（C）It deletes all binary log files, except 'mysql-in.010'.

（D）It deletes all binary log files after 'mysql-bin.010'.

（A）STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
START SLAVE;

（B）STOP SLAVE;
RESET SLAVE;
BEGIN;
SKIP NEXT GTID;
COMMIT;
START SLAVE;

（C）STOP SLAVE;
BEGIN;
SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3";
COMMIT;
START SLAVE;

（D）STOP SLAVE;
SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3";
BEGIN;
COMMIT;
SET GTID_NEXT="AUTOMATIC";
START SLAVE

（A）SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= 'Country';

（B）SHOW ENGINE Country STATUS;

（C）SHOW CREATE TABLE Country;

（D）SHOW TABLE STATUS LIKE 'Country';

（E）SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= 'Country';

（A）The mysql_secure_installation script to update server security settings

（B）The mysql client with the - enable-cleartext-plugin option

（C）The install plugin command for the mysql_cleartext_password plugin

（D）The mysql client with the - ignore-password-hashing option

（E）The mysql_upgrade script

（A）Make a copy of the .frm, .myd, and the .myi files.

（B）Stop the server or lock the tables prior to the backup.

（C）Always stop the server prior to the backup.

（D）Stop the server or lock the databases prior to the backup.

（E）Make a copy of the binary log and tablespace files.

（A）InnoDB uses row and table-level locks, but row locks are not escalates,

（B）InnoDB only uses row locks, not page or table-level locks,

（C）InnoDB uses row-level or table-level locks depending on the number of rows affected.

（D）InnoDB locks only those rows that are updated.

（E）InnoDB row locks may be escalated to page or table-level locks.

（A）The RPM installation script sets a default password of password for new installations.

（B）New security measures mean that the mysql_secure_installation script must be run first on all new installations.

（C）The local root user must log in with a blank password initially: mysql -u root -p.

（D）The mysql_install_bd post-installation script used - random-password.

（A）The command prints all parameters for the login-path. The password is printed in plain text.

（B）The command prints all parameter for the login-path. The password is replaced with stars.

（C）The command prints all parameters for the login-path. The password is shown only when you provide the -password option.

（D）The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.

（A）Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming.

（B）Collecting information requires various disk-level operations and is time consuming.

（C）Aggregating details from various storage engine caches for the final output is time consuming.

（D）Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables.

（A）They will have to change their password the next time they login to the server.

（B）They are not affected by this configuration change.

（C）They all connect via the secure sha256_password algorithm without any configuration change.

（D）They will have their passwords updated on start-up to sha256_password format.