Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-908 - MySQL 8.0 Database Administrator

Page: 3 / 5
Total 140 questions

You are considering using file-system snapshots to back up MySQL.

Which three statements are true? (Choose three.)

A.

They take roughly twice as long as logical backups.

B.

They allow direct copying of table rows with operating system copy commands.

C.

They work best for transaction storage engines that can perform their own recovery when restored.

D.

The backup window is almost zero from the perspective of the application.

E.

They do not back up views, stored procedures, or configuration files.

F.

There is a slight performance cost while the snapshot is active.

G.

They do not use additional disk space.

Your MySQL server was upgraded from an earlier major version.

The sales database contains three tables, one of which is the transactions table, which has 4 million rows.

You are running low on disk space on the datadir partition and begin to investigate.

Examine these commands and output:

Which two statements are true? (Choose two.)

A.

Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions

will free up disk space.

B.

Executing ALTER TABLE transactions will enable you to free up disk space.

C.

Truncating the sales and leads table will free up disk space.

D.

Truncating the transactions table will free up the most disk space.

E.

The transactions table was created with innodb_file_per_table=OFF.

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 the AES_ENCRYPT() MySQL function on the option file.

B.

Use mysql_secure_installation to encrypt stored login credentials.

C.

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

D.

Use mysql_config_editor to create an encrypted file.

You recently upgraded your MySQL installation to MySQL 8.0.

Examine this client error:

Which option will allow this client to connect to MySQL Server?

A.

[mysqld]

default_authentication_plugin=sha256_password

B.

ALTER USER user -

IDENTIFIED WITH mysql_native_password

BY 'password';

C.

[mysqld]

default_authentication_plugin=caching_sha2_password

D.

ALTER USER user -

IDENTIFIED WITH caching_sha2_password

BY 'password';

E.

ALTER USER user -

IDENTIFIED WITH sha256_password -

BY 'password';

F.

[mysqld]

default_authentication_plugin=mysql_native_password

Consider this shell output and executed commands:

[root@oel7 ~]# ps aux | grep mysqld

mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid

[root@oel7 ~]# kill -15 2076

Which statement is true about MySQL server shutdown?

A.

kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.

B.

kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

C.

kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.

D.

mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

Which three are characteristics of a newly created role? (Choose three.)

A.

It can be dropped using the DROP ROLE statement.

B.

It is stored in the mysql.role table.

C.

It is created as a locked account.

D.

It can be renamed using the RENAME ROLE statement.

E.

It can be granted to user accounts.

F.

It can be protected with a password.

Which two statements are true about the binary log encryption feature? (Choose two.)

A.

It encrypts any connecting slaves connection thread.

B.

It can be set at run time.

C.

It requires a keyring plugin.

D.

When enabled it encrypts existing binary logs.

E.

It can be activated per session.

Examine this command, which executes successfully:

mysqlpump -–user=root --password > full_backup.sql

Which two databases will be excluded from this dump? (Choose two.)

A.

information_schema

B.

world

C.

employee

D.

sys

E.

mysql

Examine these statements, which execute successfully:

CREATE ROLE r_world_rd;

GRANT SELECT ON world.* TO r_world_rd;

CREATE USER john IDENTIFIED BY ‘P@ssw0rd’;

GRANT r_world_rd TO john;

Examine these statements issued by user John:

What is the reason for the error?

A.

The statement was blocked by MySQL Firewall.

B.

John has not activated the role.

C.

John needs to reconnect to the database.

D.

The DBA needs to execute FLUSH PRIVILEGES.

There are five MySQL instances configured with a working group replication.

Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

A.

The cluster will shut down to preserve data consistency.

B.

The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

C.

The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

D.

There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

E.

A manual intervention to force group members to be only the working two instances is required.