最新MySQL Database Administration 1Z1-888考試題庫，Oracle 1Z1-888課程的擬真試題下載

問題1
You want to create the first configuration file for a new installation of MySQL.
- You will start mysqldmanually (not automate it to start when the host machine starts or execute as a service).
- You will stop mysqldusing mysqladmin.
- You will interact with mysqldby using only the command-line client mysql.
Which option identifies a maximal set of sections where you can put the "max_allowed_packet=16M" parameter without creating a problem?

A. [mysqld] and [mysqladmin]

B. [mysql] and [mysqld]

C. [mysqladmin]

D. [mysqld]

E. [mysql] and [mysqladmin]

F. [mysql] and [mysqld] and [mysqladmin]

G. [mysql]

正確答案: G

說明：（僅 NewDumps 成員可見）

問題2
The account [email protected] has been created with privileges, as shown in the output:

The account [email protected] exists.
The account [email protected] does not exist.
Which three statements will succeed when executed by [email protected]? (Choose three.)

A. GRANT SELECT ON audit.* TO [email protected];

B. GRANT DELETE ON world.* TO [email protected];

C. GRANT SELECT ON world.* TO [email protected];

D. CREATE USER [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';

E. GRANT SELECT ON world.* TO [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';

F. GRANT SELECT ON world.* TO [email protected];

G. GRANT INSERT ON audit.* TO [email protected];

正確答案: B,D,G

問題3
Which statement describes how the relay log works?

A. It maintains a record of available master binary logs and the current executed log position.

B. When a slave receives a change from the master, it is recorded in the relay log first and processed later.

C. It stores changes on the master, and relays them to the slave.

D. when a slave receives a change from the master, it is processed first, and then recorded in the relay log.

正確答案: A

問題4
Multiversion Concurrency Control (MVCC) enables what type of backup?

A. Binary

B. Hot

C. Incremental

D. Logical

正確答案: B

說明：（僅 NewDumps 成員可見）

問題5
These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

A. mysql> CREATE USER `robert'@'localhost' IDENTIFIED BY `secret_password'; mysql>CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets';

B. mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY `valid_password' WITH PROXY `employee'@'localhost';

C. mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON
`employee'@'localhost' TO ''@'';

D. mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON `employee'@'localhost' TO `robert'@'localhost';

正確答案: C

問題6
You have a scheduled task on Linux that executes mysqldumpagainst the localhost server periodically.
When checking the logs of this event to ensure that things are working and that backups will restore, you notice an output that is concerning.
The command the scheduled task is executing as follows:
$ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living --protocol=TCP
> /backups/latest.sql
Warning: Using a password on the command-line interface can be insecure.
Which two methods are available to avoid the warning? (Choose two.)

A. Store your password in an option file eg: ~/.my.cnf and use --defaults-file so that it is read and used.
[client]
password=t100043va

B. Use the password validation plugin available to improve user name and password strength.

C. Connect through the --socket rather than the default --protocol=TCP for local connection.
$ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living --socket=/tmp/mysql.sock > /backups/ latest.sql

D. Use mysql_config_editor, which allows you to store encrypted login credentials in your home directory.

正確答案: B,D

說明：（僅 NewDumps 成員可見）

問題7
Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space.
What will happen when this occurs?

A. An error message will be returned to the client .Server Error: ER_IO

B. The server will crash.

C. The server suspends operations for all storage engines until space becomes available.

D. The server suspends that INSERT operation until space becomes available.

正確答案: D

問題8
What three are correct statements about MySQL backups? (Choose three.)

A. They are used to prevent data corruption.

B. They are used to set up a test system.

C. They are used to set up the initial binary log files.

D. They are used to recover data.

E. They are used to prevent data theft.

F. They are used to set up a replication slave.

正確答案: C,D,F

說明：（僅 NewDumps 成員可見）

問題9
You enable binary logging on MySQL Server with the configuration:
binlog-format=STATEMENT
log-bin
Which database updates are logged on the master server to the binary log by default?

A. all updates to the default database, except temporary tables

B. all updates not involving temporary tables

C. all updates to all databases

D. all updates except to the TEMPDB database

E. all updates except to the PERFORMANCE_SCHEMA database

正確答案: A

問題10
You are using the mysqldumpslow utility to view the contents of the slow query log.
You notice the letter N and the character string `S' in a number of locations in the output.
What does the N indicate?

A. the name of the user issuing the statement

B. the number of times the statement was executed

C. an abbreviation for NULL in a statement

D. an abstracted substitution for numbers indicated in WHERE clauses

正確答案: B

說明：（僅 NewDumps 成員可見）

先試後買

購買之前，你可以先嘗試下載一個試用版本。目前我們只提供PDF版本的試用DEMO，軟件版本只提供截圖。

專業認證

品質保證

輕松通過

Try Before Buy

最新的真實試題

相關鏈接

聯繫我們