Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

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

679 Students Passed

96% Average Score

97% Same Questions

Viewing page 3 out of 5 pages

Viewing questions 21-30 out of questions

Questions # 21:

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host 192.0.2.1:3306. You wish to connect directly to the world database.

Which four options need to be specified to complete this task with a single command? (Choose four.)

Options:

--shared-memory-base-name=world

--protocol=UDP

--protocol=pipe

--password

--user=admin

--host=192.0.2.1

--socket=/tmp/mysql.sock

Answer

D, E, F, H

Explanation

To connect to the MySQL server on the remote host, you need to specify the following options:

–password or -p: The password of the MySQL account used for connecting to the server. If you do not provide a password value, the client program will prompt you to enter one1.

–user or -u: The MySQL user name to use when connecting to the server. In this case, it is admin1.

–host or -h: The host on which the MySQL server is running. In this case, it is 192.0.2.11.

–port or -P: The TCP/IP port number for connection. The default value is 3306, but you need to specify it explicitly if the server is listening on a different port1.

–database or -D: The name of the database to use as the default database. In this case, it is world1.

Questions # 22:

You have semi-synchronous replication configured and working with one slave. rpl_semi_sync_master_timeout has never been reached.

You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.

Which two statements are true? (Choose two.)

Options:

No committed transactions are lost.

The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.

As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.

Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.

Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.

A small amount of committed transactions may be lost in case they were committed just before the disk failure.

Answer

B, F

Questions # 23:

Examine these commands and output:

Question # 23

Which connection ID is holding the metadata lock?

Options:

Answer

Questions # 24:

Examine this query:

Question # 24

What information does this query provide?

Options:

total memory used across all connections associated with the user on connection number 10

total memory used by the first 10 connections

total memory used by thread number 10

total memory used across all connections associated with the user on thread number 10

total memory used by connection number 10

total memory used by the first 10 threads

Answer

Questions # 25:

User account baduser@hostname on your MySQL instance has been compromised.

Which two commands stop any new connections using the compromised account? (Choose two.)

Options:

ALTER USER baduser@hostname PASSWORD DISABLED;

ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

ALTER USER baduser@hostname ACCOUNT LOCK;

ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

ALTER USER baduser@hostname DEFAULT ROLE NONE;

Answer

C, D

Questions # 26:

Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

Options:

This file is for storing MySQL Server configuration options in ISON format.

This file is for logging purposes only and is never processed.

It is read and processed at the beginning of startup configuration.

It is read and processed at the end of startup configuration.

It is always updated with changes to system variables.

This file is for storing MySQL server_uuid values only.

Answer

D, E

Questions # 27:

Examine this MySQL Shell command:

dba.rebootClusterFromCompleteOutage()

Which two statements are true? (Choose two.)

Options:

It reconfigures InnoDB Cluster if the cluster was stopped.

It performs InnoDB Cluster instances rolling restart.

It only starts all InnoDB Cluster instances.

It is not mandatory that all instances are running and reachable before running the command.

It stops and restarts all InnoDB Cluster instances and initializes the metadata.

It only stops and restarts all InnoDB Cluster instances.

It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

Answer

B, D

Questions # 28:

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

Examine the output of the group members:

Question # 28

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

Options:

The cluster will shut down to preserve data consistency.

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

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

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.

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

Answer

A, B

Questions # 29:

Examine this list of MySQL data directory binary logs:

binlog.000001 binlog.000002

.....

binlog.000289

binlog.000300

binlog.000301

binlog.index

Now examine this command, which executes successfully:

mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql

Which two are true? (Choose two.)

Options:

All databases are backed up to the output file.

All non-active binary logs are removed from the master.

All binary logs are deleted from the master.

All binary logs are backed up and then deleted.

All databases, excluding master metadata, are backed up to the output file.

All details regarding deleted logs and master metadata are captured in the output file.

Answer

A, C

Explanation

A-All databases are backed up to the output file. This is true because the --all-databases option tells mysqldump to dump all databases. C-All binary logs are deleted from the master. This is true because the --delete-master-logs option tells mysqldump to delete all binary logs on the master server2. However, it’s important to note that deleting the MySQL binary logs with mysqldump --delete-master-logs can be dangerous if your server is a replication source server, because replicas might not yet fully have processed the contents of the binary log

Questions # 30:

Which three statements are true about MySQL replication? (Choose three.)