MySQL 5.7 Database Administrator (1Z1-888) Free Practice Test

Question 1

Consider:

What does the range value in the type column mean?

A. You can use an index and return rows that fall within a range of values.

B. This type of index uses the range hash.

C. The table will be scanned over a certain range of values.

D. There is a range of indexes that can be used.

Correct Answer: B

Question 2

Which two options describe how MySQL Server allocates memory?

A. Global memory resources are allocated at server startup.

B. Each thread allocates memory from a global pool.

C. Thread memory is pre-allocated up to thread_cache_size for performance.

D. Each connection may have its own per-thread memory allocations.

Correct Answer: A,D

Question 3

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

A. Invoke mysql with the --initialize option.

B. Run the mysql_unpack.sql file

C. Run the create_system_tables.sql file

D. Invoke mysqld with the --initialize option.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.
Which 2 things should you investigate?

A. Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

B. Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

C. Check the difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"

D. Check the difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.

E. Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

Correct Answer: A,D

Question 5

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. max_connections requires the GLOBAL scope.

B. Users can control only the max_user_connections variable.

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

D. Its current user does not have the SUPER privilege.

Correct Answer: A

Question 6

A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERTstatement commits.
Which list of locations is in the sequence of disk writes for this transaction?

A. redo log, binary log, doublewrite buffer, and tablespace

B. doublewrite buffer, redo log, tablespace, and binary log

C. redo log, doublewrite buffer, tablespace, and binary log

D. binary log, redo log, doublewrite buffer, and tablespace

Correct Answer: D

Question 7

A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

A. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

B. using GRANT ... REQUIRE SSL for a secure connection

C. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

D. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER `/C=.....' AND REQUIRE SUBJECT `/C=.....'

Correct Answer: D

Question 8

The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

A. The session_statustable is equivalent to status_by_threadfor the current thread.

B. The variable values in global_statusare the sum of those in status_by_threadgrouped by the variable name.

C. The global_statustable is equivalent to the SHOW GLOBAL STATUSstatement.

D. The variable values in status_by_accountare the sum of those in status_by_hostand status_by_user grouped by the variable name.

E. All these tables have the same number of rows.

Correct Answer: A,D

Question 9

To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

A. Set the X509 option in the [client] section of the MySQL server's configuration file.

B. Distribute client digital certificates to the client computers being used to log in by the user accounts.

C. Restart the server with the --require-x509 option.

D. Provide users access to the server's private key.

E. Install the X509 plug-in on the server.

Correct Answer: A

Question 10

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