1z1-908無料問題集「Oracle MySQL 8.0 Database Administrator」

質問 1

Which two statements are true about raw binary backups? (Choose two.)

（A）They are faster than logical backups because the process is a simple file or file system copy.

（B）They are required to obtain FIPS security compliance.

（C）The data format is identical to how MySQL stores the data on disk.

（D）They are converted to a highly compressible binary format.

（E）The resulting files are easily human readable.

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

質問 2

Which step or set of steps can be used to rotate the error log?

（A）Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

（B）Execute SET GLOBAL log_error = '<new error log file>'.

（C）Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.

（D）Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.

正解：A 解答を投票する

質問 3

Examine this statement, which executes successfully:

Now examine this query:

Which two statements can do this? (Choose two.)

（A）ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);

（B）ALTER TABLE employees -
ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

（C）ALTER TABLE employees -
ADD INDEX (birth_date DESC);

（D）ALTER TABLE employees -
ADD INDEX (birth_date);

（E）ALTER TABLE employees -
ADD INDEX ((MONTH(birth_date)));

（F）ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);

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

質問 4

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

（A）point-in-time recovery

（B）logging the duration and locks for all queries

（C）audit of all queries

（D）recording the order in which queries are issued

（E）replication

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

質問 5

You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?

（A）on master: --replicate-ignore-db=example

（B）on master: --binlog-ignore-db=example

（C）on slave: --binlog-ignore-db=example

（D）on slave: --replicate-wild-ignore=example.%

（E）on slave: --replicate-ignore-db=example

正解：A 解答を投票する

質問 6

Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?

（A）mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql

（B）mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql

（C）mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql

（D）mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql

正解：D 解答を投票する

質問 7

A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1.Confirm that secure_file_priv='/var/tmp'
2.mysql> DROP TABLE shop.customers;
3.shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)

（A）shell> cp /backup/customers.sdi /var/tmp

（B）mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

（C）mysql> ALTER TABLE shop.customers DISCARD TABLESPACE

（D）shell> cp /backup/customers.sdi /var/lib/mysql/shop/

（E）mysql> ALTER TABLE shop.customers IMPORT TABLESPACE

（F）mysql> IMPORT TABLE FROM /var/tmp/customers.sdi

（G）shell> cp /backup/customers.frm /var/lib/mysql/shop/

（H）mysql> SOURCE '/var/tmp/customers.sdi'

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

質問 8

Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?

（A）MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.

（B）MySQL Router is restarted.

（C）MySQL Router is configured based on the information in files in directory_path.

（D）MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

正解：A 解答を投票する

質問 9

You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?

（A）Use mysql_secure_installation to encrypt stored login credentials.

（B）Use a text editor to create a new defaults file and encrypt it from Linux prompt.

（C）Use mysql_config_editor to create an encrypted file.

（D）Use the AES_ENCRYPT() MySQL function on the option file.

正解：C 解答を投票する

質問 10

Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

（A）named pipes

（B）TCP/IP

（C）UDP

（D）X Protocol

（E）SOCKET

（F）shared memory

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

1z1-908 無料問題集「Oracle MySQL 8.0 Database Administrator」

弊社を連絡する

関連リンク

トップ試験