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

A. ALTER USER baduser@hostname PASSWORD DISABLED;

B. ALTER USER baduser@hostname DEFAULT ROLE NONE;

C. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

D. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

E. ALTER USER baduser@hostname ACCOUNT LOCK;

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

B. It reconfigures InnoDB Cluster if the cluster was stopped.

C. It only starts all InnoDB Cluster instances.

D. It only stops and restarts all InnoDB Cluster instances.

E. It performs InnoDB Cluster instances rolling restart.

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

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

A. It decrypts data for use in memory.

B. It enforces encryption from disk to memory and over network transmission.

C. It supports all indexes transparently.

D. It does not support the transportable tablespaces feature.

E. It supports only non-blob datatypes.

A. QN = 3

B. QN = 5

C. QN = 1

D. QN = 2

E. QN = 4

A. They do not use additional disk space.

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

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

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

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

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

G. They take roughly twice as long as logical backups.

A. blocking of potential threats by configuring pre-approved whitelists

B. modifying SQL statement dynamically with substitutions

C. provides stateless firewall access to TCP/3306

D. automatic locking of user accounts who break your firewall

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

A. [mysqld]
default_authentication_plugin=sha256_password

B. ALTER USER user -
IDENTIFIED WITH caching_sha2_password
BY 'password';

C. [mysqld]
default_authentication_plugin=caching_sha2_password

D. ALTER USER user -
IDENTIFIED WITH mysql_native_password
BY 'password';

E. ALTER USER user -
IDENTIFIED WITH sha256_password -
BY 'password';

F. [mysqld]
default_authentication_plugin=mysql_native_password