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

質問 1

Consider the query:
Mysql> SET @run = 15;
Mysql> EXPLAIN SELECT objective, stage, COUNT (stage)
FROM iteminformation
WHERE run=@run AND objective='7.1'
GROUP BY objective,stage
ORDER BY stage;

The iteminformation table has the following indexes; Mysql> SHOW INDEXES FROM iteminformation:

This query is run several times in an application with different values in the WHERE clause in a growing data set.
What is the primary improvement that can be made for this scenario?

（A）Drop the run_2 index because it has caused a conflict in the choice of key for this query.

（B）Execute the run_2 index because it has caused a conflict in the choice of key for this query.

（C）Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations.

（D）Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes.

（E）Add a composite index on (run,objective,stage) to allow the query to fully utilize an index.

正解：A 解答を投票する

質問 2

A user executes the statement;
PURGE BINARY LOGS TO 'mysql-bin.010';
What is the result?

（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 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

Which two statements describe the behavior of the server's SQL mode?

（A）The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE.

（B）The server's SQL mode, when globally set on a slave server, applies to events sent from the master.

（C）The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax.

（D）The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command.

正解：C、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

Which two statements are true about InnoDB auto-increment locking?

（A）InnoDB never uses table-level locks.

（B）InnoDB always protects auto-increment updates with a table-level lock.

（C）Some settings for innodb_autoinc_lock_mode can help reduce locking.

（D）InnoDB does not use locks to enforce auto-increment uniqueness.

（E）The auto-increment lock can be a table-level lock.

正解：B、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

An employee cannot access the company database. You check the connection variables:
Mysql> SHOW GLOBAL VARIABLES LIKE '%connect%';

8 rows in set (0.00 sec)
A look at the user privileges shows:
GRANT... TO 'bob'@'%, example.com' WITH MAX_USER_CONNECTIONS 0; GRANT... TO 'key'@'%, example.com' WITH MAX_USER_CONNECTIONS 1; GRANT... TO 'joe'@'%, example.com' WITH MAX_USER_CONNECTIONS 50; What is a valid explanation for why one of the users is unable to connect to the database?

（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）Bob has max_user_connections set to zero, which blocks all his connections

（D）Joe has exceeded the max_user_connections global limit.

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

正解：E 解答を投票する

質問 6

When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

（A）The BIT columns can be manipulated with the bitwise operators &, |, ~, ^, <<, and >>. The other integer types cannot.

（B）BIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved.

（C）BIT (8) takes less space than eight TINYINT fields.

（D）Multiple BIT columns pack tightly into a row, using less space.

正解：D 解答を投票する

質問 7

Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?

（A）MySQL Replication

（B）Distributed Replication Block Device

（C）Windows Server Failover Clustering

（D）MySQL Cluster

正解：A 解答を投票する

質問 8

Which hardware storage option, when set up with redundant disks, offers the least stability, availability, and reliability for Mysql data?

（A）NFS (Networked File System)

（B）iSCSI

（C）SAN (Storage Area Network)

（D）RAID 5

正解：C 解答を投票する

質問 9

You want a record of all queries that are not using indexes.
How would you achieve this?

（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

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option '-ssl'
What is the cause of the error?

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

正解：B 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験