1. Home
  2. Oracle
  3. MySQL Database Administration
  4. 1z0-908
  5. MySQL 8.0 Database Administrator Questions and Answers

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

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 5 pages
Viewing questions 1-10 out of questions
Questions # 1:

Which two statements are true about MySQL Enterprise Backup? (Choose two.)

Options:
A.

It supports backing up only table structures.

B.

It can perform hot or warm backups.

C.

It creates logical backups.

D.

It supports the creation of incremental backups.

E.

It supports backup of a remote MySQL system.

F.

It supports restoring to a remote MySQL system.

Questions # 2:

An existing asynchronous replication setup is running MySQL 8.

Which two steps are a part of implementing GTID replication? (Choose two.)

Options:
A.

Enable GTID by executing this on the master and the slave:

SET GLOBAL GTID_ENABLED=on;

B.

Execute this on the slave to enable GTID:

START SLAVE IO_THREAD WITH GTID;

C.

Restart MySQL (master and slave) with these options enabled:

--gtid_mode=ON

--log-bin

--log-slave-updates

--enforce-gtid-consistency

D.

Execute this on the slave to enable GTID:

RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;

E.

On the slave, alter the MySQL master connection setting with:

ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

F.

On the slave, alter the MySQL master connection setting with:

CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

Questions # 3:

Your MySQL environment has asynchronous position based-replication with one master and one slave.

The slave instance had a disk I/O problem, so it was stopped.

You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.

You restart MySQL Server.

How can replication be restored?

Options:
A.

The slave relay logs should be deleted; then execute START SLAVE;

B.

The relay logs from the master should be used to replace the corrupted relay logs.

C.

The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D.

The slave needs to be restored from backup.

Questions # 4:

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

Which three statements are true? (Choose three.)

Options:
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.

Questions # 5:

Which statement is true about InnoDB persistent index statistics?

Options:
A.

Updating index statistics is an I/O expensive operation.

B.

Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

C.

Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

D.

Execution plans based on transient index statistics improve precision when

innodb_stats_persistent_sample_pages is increased.

E.

Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

F.

Tables are scanned and index statistics recalculated when an instance is restarted.

Questions # 6:

Which two are features of MySQL Enterprise Firewall? (Choose two.)

Options:
A.

recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

B.

blocking of potential threats by configuring pre-approved whitelists

C.

modifying SQL statement dynamically with substitutions

D.

automatic locking of user accounts who break your firewall

E.

provides stateless firewall access to TCP/3306

Questions # 7:

A valid raw backup of the shop.customers MyISAM table was taken.

You must restore the table. You begin with these steps:

1.Confirm that secure_file_priv=’/var/tmp’

2.mysql> DROP TABLE shop.customers;

3.shell> cp /backup/customers.MY* /var/lib/mysql/shop/

Which two actions are required to complete the restore? (Choose two.)

Options:
A.

shell> cp /backup/customers.sdi /var/tmp

B.

shell> cp /backup/customers.sdi /var/lib/mysql/shop/

C.

mysql> SOURCE ‘/var/tmp/customers.sdi’

D.

mysql> IMPORT TABLE FROM /var/tmp/customers.sdi

E.

shell> cp /backup/customers.frm /var/lib/mysql/shop/

F.

mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

G.

mysql> ALTER TABLE shop.customers IMPORT TABLESPACE

Questions # 8:

You have configured GTID-based asynchronous replication with one master and one slave.

A user accidentally updated some data on the slave.

To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

Question # 8

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

Options:
A.

RESET MASTER;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

B.

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;

SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

C.

RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;

SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;

D.

RESET MASTER;

SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;

SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

E.

RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

Questions # 9:

Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

Options:
A.

Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

B.

Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.

C.

Logical upgrades are much faster because they do not require restarting the mysqld process.

D.

Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.

E.

Physical upgrades are much faster because they do not require restarting the mysqld process.

F.

Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

Questions # 10:

Examine this output:

Question # 10

Which change should optimize the number of buffer pool instances for this workload?

Options:
A.

Increase the number of buffer pool instances to 16.

B.

Increase the number of buffer pool instances to 32.

C.

Decrease the number of buffer pool instances to 1.

D.

Increase the number of buffer pool instances to 12.

E.

Decrease the number of buffer pool instances to 4.

Viewing page 1 out of 5 pages
Viewing questions 1-10 out of questions