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

質問 1

While attempting to set up a new replication slave on host `192.168.0.25' with the user `replication', you encounter this error:

What should you do to resolve this error?

（A）Add the user [email protected] with the correct password to the slave.

（B）Edit the my.ini file on the slave so that the master-host variable is equal to the IP address of the master, and restart the slave.

（C）Add the user [email protected] with the correct password to the master.

（D）Edit the DNS table on the master to include the domain name for the IP address of 192.168.0.25.

正解：C 解答を投票する

質問 2

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a
.mylogin.cnf file.
Which two are true about the login path feature?

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

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

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

質問 3

The /myfolder/my.cnf file has option set:
[mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?

（A）MySQL starts and Binary Logging is enabled.

（B）MySQL fails to start due to conflicting options on the command line.

（C）MySQL fails to start due to the conflicting options in the configuration files.

（D）MySQL starts but Binary Logging is disabled.

正解：B 解答を投票する

質問 4

The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a / backuppartition available on NFS where backups are stored.
You investigate and gather this information:

Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.

You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?

（A）Execute OPTIMIZE TABLEso that the InnoDB engine frees unused pages on disk back to the file system:

（B）Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:

（C）Take a backup, stop the server, remove the data files, and restore the backup:

（D）Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:

正解：B 解答を投票する

質問 5

A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance?

（A）a backup created using FLUSH TABLES ... FOR EXPORT

（B）a file system copy created while MySQL was shut down.

（C）a backup created with mysqldump --all-databases

（D）an up-to-date replication slave

（E）a file system-level snapshot

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

質問 6

One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.
The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200;
Why does the command fail?

（A）Its current user does not have the SUPER privilege.

（B）max_connections is not a dynamic variable. You need to change the config file and restart the database.

（C）Users can control only the max_user_connections variable.

（D）max_connections requires the GLOBAL scope.

正解：D 解答を投票する

質問 7

Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

（A）It relies on the shared disk architecture being visible to both servers.

（B）It implements High Availability by using the NET Connector's load balancing capabilities.

（C）It is a shared-nothing architecture.

（D）It is provided by means of IP-level disk replication.

正解：A 解答を投票する

質問 8

You have issued this statement:
GRANT PROXY ON 'a' FOR 'b';
When user account 'b' issues a query, the query returns an access denied error.
What could have caused that error?

（A）When connecting, user account 'b' is not entering the correct password for user account 'a'.

（B）User account 'b' has not been granted permission to access the data being queried.

（C）User account 'a' has not been granted permission to access the data being queried.

（D）You have not set the proxy_user variable in the configuration file.

正解：A 解答を投票する

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

質問 9

In which order does MySQL process an incoming INSERT statement?

（A）It optimizes the query, checks whether the user is authorized to perform it, and then writes to the binary log.

（B）It checks whether the user is authorized to perform the query, optimizes it, and then writes to the binary log.

（C）It writes the query to the binary log, optimizes it, and then checks whether the user is authorized to perform the query.

（D）It checks whether the user is authorized to perform the query, writes to the binary log, and then optimizes it.

正解：C 解答を投票する

質問 10

You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
* Total dataset size is 200G with an average schema size of 2G.
* The data is transient and is not backed up and can be repopulated easily.
* Performance and responsiveness of the DB is paramount.
* The query pattern for the DB instance is split 90/10 read/write.
* DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)

（A）Innodb_flush_log_at_trx_commit=1

（B）max_heap_table_size = 2G
tmp_table_size=2G

（C）sync_binlog=10

（D）innodb_flush_method=O_DIRECT

（E）innodb_flush_log_at_trx_commit=0

（F）query_cache_size = 2G
query_cache_enabled=1

（G）innodb_buffer_pool_size=200G
log_bin=mysql -bin

（H）table_open_cache = 64
innodb_buffer_pool_instances=64

正解：D、F、G、H 解答を投票する

質問 11

Which two are considered good security practices when using passwords? (Choose two.)

（A）Choose short passwords to save on storage space.

（B）Do not use dictionary-based words.

（C）Use one-way encryption for storage of passwords.

（D）Use simple keyboard actions that give mixed letters.

（E）Store passwords external to the database.

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

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

質問 12

You want to immediately stop access to a database server for remote user
'mike'@'client.example.com'. This user is currently not connected to the server.
Which two actions can you take to stop any access from the user? (Choose two.)

（A）Execute the mysql_secure_installation command.

（B）Use REVOKE ALL PRIVILEGES FROM `mike'@'client.example.com';

（C）Use GRANT USAGE ON *.* TO `mike'@'client.example.com' MAX_USER_CONNECTIONS=0;

（D）Use ALTER USER `mike'@'client.example.com' PASSWORD EXPIRE;

（E）Use DROP USER `mike'@'client.example.com';

（F）Use ALTER USER `mike'@'client.example.com' ACCOUNT LOCK;

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

質問 13

Which two capabilities are granted with the SUPER privilege? (Choose two.)

（A）allowing change of the server runtime configuration

（B）allowing a client to shut down the server

（C）allowing client accounts to take over the account of another user

（D）allowing a client to kill other client connections

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

質問 14

You are using GTIDSin replication. You need to skip a transaction with the GTIDof aaa-bbb-ccc-ddd- eee:3on a slave.
Which procedure would you execute from a MySQL prompt?

（A）

（B）

（C）

（D）

正解：B 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験