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

（A）By enabling the Error Log and using the - log-queries-not-using-indexes option

（B）By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically

（C）By enabling the Error Log because not using indexes is an error

（D）By enabling the Slow Query Log and using the - log-queries-not-using-indexes option

（A）--old-passwords, to start Mysql to use the old password format while running without the grant tables

（B）--skip-networking, to prohibit access from remote locations

（C）--read-only,to set all data to read-only except for super users

（D）--reset-grant-tables, to start the server with only the mysql database accessible

（A）The partitioning expression is an integer or function that returns an integer value or NULL value.

（B）Partitioning allows easier management of smaller data sets for certain queries.

（C）Partitioning allows different columns to be stored in separate files.

（D）Partitioning is only available for those storage engines that implements it natively.

（E）Tables with BLOB and TEXT columns cannot be partitioned.

（A）ALTER TABLE games
COALESCE PARTITION (gMORES)
INTO
g01305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

（B）ALTER TABLE games
REORGANIZE PARTITION (gMORES)
INTO
g01305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

（C）ALTER TABLE games
ADD PARTITION g201350 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') );

（D）ALTER TABLE games
SPLIT PARTITION (gMORES)
INTO
g201305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

（E）ALTHER TABLE games
DROP PATITION gMORES,
ADD PARTITION
g201305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

（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）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.

（A）It can delete any anonymous accounts.

（B）It prompts you to set the root user account password.

（C）It verifies that all users are configuration with the longer password hash.

（D）It asks to remove the test database, which is generated at installation time.

（E）It checks whether file permissions are appropriate within datadir.

（A）A connection was blocked by a firewall or a similar security mechanism.

（B）A connection failed because the proxy user privileges did not match the login user.

（C）A connection as the user kate was successful.

（D）A connection failed due to authentication being unsuccessful.

（E）A connection was attempted via socket rather than TCP.

（A）The server's SSL certificate was invalid.

（B）The mysqld binary was not compiled with SSL support.

（C）The server was not started with the - enable--ssl-plugin option.

（D）-- ssl is not a valid server option.

（E）The --- ssl level was not specified.

（A）Allowing a client to shut down the server

（B）Allowing a client to kill other client connections

（C）Allowing change of the server runtime configuration

（D）Allowing client accounts to take over the account of another user