最新的Oracle 1Z0-888免費考試真題

問題1

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output?

A. No indexes are defined.

B. Date should be a TIMESTAMP field for better performance.

C. The User field is too long for most names.

D. Using default values for DATETIME causes table scans.

E. The engine type is not appropriate to the application use.

正確答案: A,E

問題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 world.* TO [email protected];

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

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

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

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

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

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

正確答案: B,E,F

問題3

Consider the join_buffer_size parameter in MySQL Server.
Which two statements are true about the join buffer?

A. The value should be increased from the default if the query joins large rows without using an index.

B. The join buffer is used to process sorts when complex joins are being performed.

C. The value should be increased if the client performs several SELECT operations.

D. The join buffer is global and can be changed only by restarting the server.

E. The join buffer is set per connection.

正確答案: A,B

問題4

You have created a backup of the 'sales' database with the command:

Which two procedures can be used to restore the 'orders' table from the backup? (Choose two.)

A.

B.

C.

D.

正確答案: A,B

問題5

Which two statements are true regarding MySQL security? (Choose two.)

A. The mysqld process should be run as root or administrator.

B. The root or administrator users should own all files and directories to which the server writes.

C. The mysqld process should not be run as root or administrator.

D. The mysql user needs to have sudo privileges.

E. The mysqld process owner should own all files and directories to which the server writes.

正確答案: B,C

問題6

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

A. allowing change of the server runtime configuration

B. allowing client accounts to take over the account of another user

C. allowing a client to kill other client connections

D. allowing a client to shut down the server

正確答案: C,D

問題7

The InnoDB tablespace is corrupted and you start the server with option --innodb_force_recover=4.
Which backup method would you use to reload the corrupted InnoDB tables?

A. A text backup. A binary backup will still contain the corrupted segments.

B. a binary backup that uses transportable tablespaces and allows you to reload a corrupted table

C. A text backup. InnoDB does not allow you to make binary backups while the server is running.

D. a binary backup taken with MySQL Enterprise Backup that can back up even corrupted tables

正確答案: C

說明：（僅 Fast2test 成員可見）

問題8

Which are three facts about backups with mysqldump?

A. are able to back up specific items within a database

B. are always faster to restore than binary backups

C. can back up a remote database server

D. allow a consistent backup to be taken

E. will lock all storage engines for duration of backup

F. create automatically compressed backups

正確答案: A,C,D

問題9

old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

A. All data in p1 and p3 partitions is removed and the table definition is changed.

B. It results in a syntax error because you cannot specify more than one partition in the same statement.

C. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.

D. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.

正確答案: C

問題10

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 except to the TEMPDB database

C. all updates not involving temporary tables

D. all updates except to the PERFORMANCE_SCHEMA database

E. all updates to all databases

正確答案: A

問題11

Which two general properties relate to the mysqlimport client program? (Choose two.)

A. It can be used to easily import full binary backups.

B. It provides a command-line interface to the LOAD DATA INFILE.

C. It can load files only on the server host.

D. It bypasses the server and writes directly to the data files.

E. It can load files both on the client host and the server host.

正確答案: B,E

說明：（僅 Fast2test 成員可見）

問題12

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. The server suspends operations for all storage engines until space becomes available.

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

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

D. The server will crash.

正確答案: B

問題13

You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST.
Which three statements are true? (Choose three.)

A. A connection must be instrumented to be included in the list of processes.

B. The PROCESS privilege is required.

C. The threads table contains all the required columns.

D. The performance impact is less than SHOW FULL PROCESSLIST.

E. The events_statements_current consumer must be enabled.

F. The sys.session view provides the process list with additional information.

正確答案: B,C,E

說明：（僅 Fast2test 成員可見）

問題14

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. an up-to-date replication slave

B. a file system-level snapshot

C. a backup created with mysqldump --all-databases

D. a backup created using FLUSH TABLES ... FOR EXPORT

E. a file system copy created while MySQL was shut down.

正確答案: B,C

最新的Oracle MySQL 5.7 Database Administrator - 1Z0-888免費考試真題

聯系我們

站內鏈接

最新更新