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

質問 1

Which statement is true about FLUSH LOGS command?

（A）It flushes dirty pages in the buffer pool to the REDO logs.

（B）It requires the RELOAD, FILE, and DROP privileges.

（C）It closes and reopens all log files.

（D）It closes and sends binary log files to slave servers.

正解：C 解答を投票する

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

質問 2

Consider typical High Availability (HA) solutions that do not use shared storage.
Which three HA solutions do not use shared storage?

（A）Mysql NDB Cluster

（B）Windows Cluster and Mysql

（C）Solaris Cluster and Mysql

（D）Mysql Replication

（E）Distributed Replicated Block Device (DRBD) and Mysql

正解：A、D、E 解答を投票する

質問 3

You have been notified that the 'apps' . 'reports' table has been accidentally truncated.
You have single file mysqldump backup available taken prior to the truncate. The backup contains all the tables from the instance, and the 'apps' . 'reports' table must be restored without affecting the other remaining databases and tables.
Which restore option is suitable in this scenario?

（A）Execute mysqldump on the backup,sql file and apply - filter arguments to obtain only the 'apps' . 'reportys' table.

（B）Restore the backup to another databases instance and obtain a copy of the reports table individually.

（C）Execute LOAD DATA INFILE 'backup.sql' SCHEMA='apps' TABLE= 'reports'

（D）Extract the 'apps' . 'reports' table from the backup using the SOURCE command.

正解：B 解答を投票する

質問 4

Consider the Mysql Enterprise Audit plugin.
You are checking user accounts and attempt the following query:
Mysql> SELECT user, host, plugin FROM mysql.users;
ERROR 1146 (42S02): Table 'mysql.users' doesn't exist
Which subset of event attributes would indicate this error in the audit.log file?

（A）NAME="Error"
STATUS="0"
SQLTEXT="Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>

（B）NAME="Query"
STATUS="1146"
SQLTEXT="select user,host from users"/>

（C）NAME="Error"
STATUS="1146"
SQLTEXT="select user,host from users"/>

（D）NAME="Error"
STATUS="1146"
SQLTEXT="Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>

（E）NAME="Query"
STATUS="1146"
SQLTEXT=" Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>

正解：B 解答を投票する

質問 5

Which two requirements would lead towards a high availability solution?

（A）When application is a single point of failure

（B）When data loss is unacceptable

（C）When data must be refactored

（D）When application concurrency is static

（E）When uptime is critical

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

質問 6

What are three facts about backups with mysqldump?

（A）Allow a consistent backup to be taken

（B）Are able to back up specific items within a database

（C）Can back up a remote database server

（D）Create automatically compressed backups

（E）Are always faster to restore than binary backups

（F）Will lock all storage engines for duration of backup

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

質問 7

MySQL is installed on a Linux server and has the following configuration:
[mysqld]
User=mysql
Datadir=/data/mysql
As the 'root' user, change the datadir location by executing:
Shell> cp -R /var/lib/mysql/data/mysql/
Shell> chown -R mysql /data/mysql/
What is the purpose of changing ownership of datadir to the 'mysql' user?

（A）MySQL needs to be run as the root user, but file cannot be owned by it.

（B）MySQL cannot be run as the root user.

（C）The mysqld process requires all permissions within datadir to be the same.

（D）MySQL requires correct file ownership while remaining secure.

正解：D 解答を投票する

質問 8

Which two capabilities are granted with the SUPER privilege?

（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

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

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

質問 9

Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?

（A）Mysqlslow

（B）Mysqldump

（C）Mysqlaccess

（D）Mysqldumpslow

（E）Mysqlshow

正解：D 解答を投票する

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

質問 10

Which two are true regarding MySQL binary and text backups?

（A）Text backups are human-readable while binary backups are not.

（B）Binary backups are usually faster than text backups.

（C）Binary backups are usually slower than text backups.

（D）Binary backups are not portable across different operating systems.

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

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

弊社を連絡する

関連リンク

トップ試験