oracle 1z0-908 practice test

MySQL 8.0 Database Administrator Exam


Question 1

Which two storage engines provide a view of the data consistent with the storage system at any
moment? (Choose two.)

  • A. MyISAM
  • B. NDB
  • C. MEMORY
  • D. ARCHIVE
  • E. InnoDB
Answer:

AC

Reference:
https://zetcode.com/mysql/storageengines/

Discussions

Question 2

Your MySQL installation is running low on space due to binary logs. You need to reduce your log
space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)

  • A. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
  • B. Set binlog_expire_logs_seconds in my.cnf.
  • C. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
  • D. Use SET PERSIST binlog_expire_logs_seconds=<value>.
  • E. Use PURGE BINARY LOGS to <binlog_name>.
  • F. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.
Answer:

AD

Reference:
https://severalnines.com/database-blog/my-mysql-database-out-disk-space

Discussions

Question 3

A colleague complains about slow response time on your website.
Examine this query and output:

What is the most likely cause for the high number of lock waits?

  • A. You use the MyISAM storage engine for most common tables.
  • B. You use the InnoDB storage engine and statements wait while data is inserted.
  • C. The Innodb Buffer pool is full.
  • D. Your table accesses wait for the operating system level flush.
Answer:

B

Reference:
https://severalnines.com/database-blog/how-fix-lock-wait-timeout-exceeded-error-
mysql

Discussions

Question 4

You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your dat
a. Examine your backup requirement:
The MySQL system being backed up can never be unavailable or locked to the client applications.
The recovery from the backup must work on any system.
Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

  • A. Take a physical backup of the MySQL system.
  • B. Use the Clone Plugin to copy the data to another MySQL system.
  • C. Take a logical backup of the MySQL system.
  • D. Take your backup from a slave of the MySQL system.
Answer:

C

Discussions

Question 5

A MySQL server is monitored using MySQL Enterprise Monitors agentless installation.
Which three features are available with this installation method? (Choose three.)

  • A. MySQL Replication monitoring
  • B. network-related information and network characteristics
  • C. MySQL Query Analysis data
  • D. CPU utilization
  • E. security-related advisor warnings
  • F. operating system memory utilization
  • G. disk usage and disk characteristics including disk advisors warnings
Answer:

CEG

Discussions

Question 6

You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
A. The mysqlcheck --check --all-databases command takes table write locks while performing a series
of checks.
B. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
C. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
D. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
E. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual
table corruptions.

Answer:

DE
(none)
Explanation

Discussions

Question 7

Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

  • A. Remove group read/write privileges from the private_key.pem file.
  • B. Remove world read privileges from the server-cert.pem certificate file.
  • C. Change the group ownership of the mysql directory to the mysql user group.
  • D. Remove world read privileges from the public_key.pem file.
  • E. Change the parent directory owner and group to mysql.
  • F. Remove the world read/execute privilege from the accounting directory.
Answer:

CE

Discussions

Question 8

Examine this command, which executes successfully:
cluster.addInstance(<user>@<host>:<port>, {recoveryMethod: clone})
Which three statements are true? (Choose three.)

  • A. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
  • B. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
  • C. InnoDB tablespaces outside the datadir are able to be cloned.
  • D. It is always slower than {recoveryMethod: ‘incremental’}.
  • E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
  • F. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
Answer:

ADF

Discussions

Question 9

Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

  • A. sort_buffer_size
  • B. key_buffer_size
  • C. table_open_cache
  • D. read_buffer_size
  • E. innodb_buffer_pool_size
  • F. tmp_table_size
Answer:

ABF

Reference:
https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/server-system-variables.html

Discussions

Question 10

You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information
from both master and slave:

Which statement is true?

  • A. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
  • B. Replication will fail because the master does not have the required transaction with bbbbbbbb- bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
  • C. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
  • D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
  • E. Replication will work.
Answer:

A

Reference:
https://bugs.mysql.com/bug.php?id=86643

Discussions
To page 2