Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Home
Oracle
MySQL Database Administration
1z0-908
MySQL 8.0 Database Administrator Questions and Answers

Pass the Oracle MySQL Database Administration 1z0-908 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-908 Premium Access

View all detail and faqs for the 1z0-908 exam

Go to Exam

364 Students Passed

95% Average Score

91% Same Questions

Viewing page 1 out of 5 pages

Viewing questions 1-10 out of questions

Questions # 1:

You have configured MySQL Enterprise Monitor to monitor your MySQL server.

Which four features are available? (Choose four.)

Options:

starting and stopping the MySQL instance

tracing import and export with mysqidump

deploying the MySQL agent on supported target operating system

creating e-mail alerts and SNMP traps for MySQL warnings

monitoring the availability of the MySQL instance

analyzing executed MySQL queries

monitoring of NDB Cluster API nodes

Answer

B, D, E, F

Questions # 2:

A clean shutdown was performed with innodb_fast_shutdown=0.

While you were manipulating files, all files were accidentally deleted from the top-level data directory.

Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

Options:

ibtmp1

undo_001

ib_buffer_pool

ibdata1

mysql.ibd

ib_logfile0

Answer

C, E

Questions # 3:

The mysqld instance has the connection control plugin enabled with these settings: connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000

The minimum and maximum delays need to be increased to 3000 and 5000, respectively.

A command is executed:

mysql> SET GLOBAL connection_control_min_connection_delay=3000;

What is the result?

Options:

The minimum value increases to 3000 and the maximum value increases to 4000.

Only the minimum connection value is increased to 3000.

The minimum connection value is changed to 2000.

An error is returned.

Answer

Explanation

root@localhost[(none)]> show variables like '%connection_control_max_connection_delay%';

+-----------------------------------------+-------+

| Variable_name | Value |

+-----------------------------------------+-------+

| connection_control_max_connection_delay | 2000 |

+-----------------------------------------+-------+

1 row in set (0.00 sec)

root@localhost[(none)]> SET GLOBAL connection_control_min_connection_delay=3000;

ERROR 1231 (42000): Variable 'connection_control_min_connection_delay' can't be set to the value of '3000'

Questions # 4:

You have an installation of MySQL 8 on Oracle Linux.

Consider the outputs:

Question # 4

Which statement is true about disk temporary tables for this installation?

Options:

Only internal temporary tables from the optimizer will be created in tmpdir.

Temporary tables will use the InnoDB temporary tablespace located in datadir.

Temporary tables are created in tmpdir only if configured to use MyISAM.

Temporary tables are created in tmpdir only after they reach tmp_tabie_size.

Temporary tables will use the InnoDB temporary tablespace located in /tmp.

Answer

Explanation

In MySQL 8.0, the default storage engine for temporary tables is InnoDB. The InnoDB temporary tablespace is located in the data directory and is used for all temporary tables. The tmpdir variable is used for other temporary files, such as binary log files and slow query log files1. The tmp_table_size variable only affects the maximum size of internal in-memory temporary tables, not disk-based temporary tables2. The TABLESPACE clause for CREATE TEMPORARY TABLE is deprecated and does not affect the location of the temporary tablespace3. References:

1: https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html

2: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmp_table_size

3: https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html

Questions # 5:

Which three are requirements for a secure MySQL Server environment? (Choose three.)

Options:

Restrict the number of OS users that have access at the OS level.

Ensure appropriate file system privileges for OS users and groups.

Minimize the number of non-MySQL Server-related processes running on the server host.

Encrypt the file system to avoid needing exact file-system permissions.

Keep the entire software stack on one OS host.

Run MySQL server as the root user to prevent incorrect sudo settings.

Answer

B, D, E

Questions # 6:

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

Options:

ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';

ALTER TABLE t1 ENCRYPTION='Y';

ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;

ALTER TABLE t1 SET TDE = 'ON';

Answer

Explanation

Run a tablespace encryption operation. In this example, a general tablespace named ts1 is encrypted. mysql> ALTER TABLESPACE ts1 ENCRYPTION = 'Y'; https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html

Questions # 7:

Which condition is true about the use of the hash join algorithm?