1Z0-888 無料問題集「Oracle MySQL 5.7 Database Administrator」

（A）Decide which indexes to use.

（B）Validate the query.

（C）Parse the query.

（D）Execute the query.

（E）Verify that the user is allowed to execute the query.

（F）Change the order in which the tables are joined.

（G）Rewrite the WHERE clause.

（A）CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS `imbatman';

（B）CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY `iambatman';

（C）CREATE USER WITH sha256_password `sha256_user'@'192.0.2.10' IDENTIFIED AS `webdesign' USING `imbatman';

（D）CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY `imbatman';

（E）CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password
`imbatman';

（F）CREATE USER `webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
`imbatman';

（A）All users are blocked because max_user_connections is accumulated over the host account information.

（B）connect_timeout is too small to allow a connection to occur.

（C）Joe has exceeded the max_user_connections global limit.

（D）Bob has max_user_connections set to zero, which blocks all his connections.

（E）Kay is already connected elsewhere and attempting to log in again.

（A）Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

（B）Set binlog_format=MIXED with the --replicate-ignore-temp-table option.

（C）Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

（D）Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

（E）Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.

（A）Hot

（B）Binary

（C）Logical

（D）Incremental

（A）It is amount of buffers available during a transaction.

（B）It caches data and indexes for InnoDB tables.

（C）It is a pool of memory for SQL query sort operations from within the InnoDB engine.

（D）It holds changes made during a transaction before they are written to the log.

（E）It caches only the indexes for InnoDB tables.

（A）Query the performance_schema.objects_summary_global_by_type table

（B）Query the INFORMATION_SCHEMA.TABLES table for the partition_count

（C）Use the command: SHOW CREATE TABLE

（D）Query the INFORMATION_SCHEMA.PARTITIONS table

（E）Use the command: SHOW TABLE STATUS

（A）It provides a FIPS-compliant keyring for storing MySQL login details.

（B）A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.

（C）A .mylogin.cnf file can store at most one login path.

（D）mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.

（E）It is an alternative to storing the MySQL login details in a my.cnf file.

（F）It provides means to help avoid accidentally exposing the MySQL login details.

（A）mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON `employee'@'localhost' TO `robert'@'localhost';

（B）mysql> CREATE USER `robert'@'localhost' IDENTIFIED BY `secret_password'; mysql>CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets';

（C）mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY `valid_password' WITH PROXY `employee'@'localhost';

（D）mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON
`employee'@'localhost' TO ''@'';

（A）limiting logins to originate from the application server or the server's subnet

（B）installing MySQL on the application server, and running the database and application on the same server

（C）starting the server with -bind-address=0.0.0.0 specified

（D）disabling connections from named pipes or socket files (depending on the operating system of the server)

（E）enabling and using SSL for connections to the MySQL database

（F）running the server with -skip-networking specified