Oracle MySQL 8.0 Database Administrator - 1z1-908 Exam Practice Test

A. It supports restoring to a remote MySQL system.

B. It supports backing up only table structures.

C. It supports backup of a remote MySQL system.

D. It supports the creation of incremental backups.

E. It creates logical backups.

F. It can perform hot or warm backups.

A. mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql

B. mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql

C. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql

D. mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql

A. help topics

B. audit log events

C. information about table structures

D. plugins

E. performance monitoring information

F. time zone information and definitions

G. rollback segments

A. Use the Clone Plugin to copy the data to another MySQL system.

B. Take a logical backup of the MySQL system.

C. Take a physical backup of the MySQL system.

D. Take your backup from a slave of the MySQL system.

A. sort_buffer_size

B. tmp_table_size

C. table_open_cache

D. read_buffer_size

E. innodb_buffer_pool_size

F. key_buffer_size

A. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.

B. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.

C. Snapshot backups can be used only in virtual machines.

D. The frozen file system can be cloned to another virtual machine immediately into active service.

E. A separate physical copy must be made before releasing the snapshot backup.

A. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

B. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

C. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

D. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

A. You must manually initialize the data directory.

B. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.

C. You can find the root password in the error log after the first start.

D. You can provide the root password interactively.

E. The functionality is split among several RPM package files.

F. MySQL uses the RPM relocatable installation target feature.