1z0-908 MySQL 8.0 Database Administrator Questions and Answers

Connection 24 experiences a lock wait timeout.

Connection 25 experiences a lock wait timeout.

A deadlock occurs immediately.

All statements execute without error.

A deadlock occurs after innodb_lock_wait_timeout seconds.

installing and configuring the Connection Control plugin

avoiding concatenation of SQL statements and user-supplied values in an application

using stored procedures for any database access

using PREPARED STATEMENTS

REQUIRED

VERIFY_CA

VERIFY_IDENTITY

PREFERRED

DISABLED

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

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

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

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

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

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

GRANT ALL PRIVILEGES ON ‘world’.‘city’ TO ‘tom’@’%’;

GRANT SELECT (‘code’) ON ‘world’.‘country’ TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.* TO ‘tom’@’%’;

GRANT ALL PRIVILEGES ON ‘world’.‘country’ TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.‘city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.* TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.‘city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.‘country’ TO ‘tom’@’%’;

It executes flush tables with read lock.

It enforces consistent backups for all storage engines.

The backup created is a consistent data dump.

This option uses the READ COMMITTED transaction isolation mode.

It is a cold backup.

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

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

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

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

Snapshot backups can be used only in virtual machines.

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;

performance metrics

table definitions

access control lists

view definitions

server runtime configuration

server configuration rollback

stored procedure definitions

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

blocking of potential threats by configuring pre-approved whitelists

modifying SQL statement dynamically with substitutions

automatic locking of user accounts who break your firewall

provides stateless firewall access to TCP/3306

The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.

It is possible to filter a Query Analyzer view graph by database and by table.

The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager's built-in Agent installation.

It is possible to export statements included in a graph selection in CSV format.

Users could overwrite configuration files.

Data files could be deleted.

SQL injections could be used to insert bad data into the database.

MySQL binaries could be damaged, deleted, or altered.

Extra startup time would be required for the MySQL server to reset the privileges.

UPDATE world.country SET Name='all';

UPDATE world.country SET Name='one' LIMIT 1;

UPDATE world.country SET Name='new' WHERE Name='old';

UPDATE world.country SET Name=CONCAT('New ',Name);

UPDATE world.country SET Name='first' ORDER BY Name LIMIT

Roll back the transaction and start the transaction again in the same session.

Re-execute the failed statement in your transaction.

Change the default database and re-execute the failed statement in your transaction.

Close the connection, reconnect, and start the transaction again.

Remove ib_logfile0 and ib_logfile1 files from the file system.

Execute mysqladmin flush-logs.

First run mysqld --initialize to refresh the Size of ib_logfile.

Create a new ib_logfile0 file of size 26214400.

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.

It manages the configuration of the MySQL Firewall feature.

It manages the configuration of client programs.

It can move datadir to a new location.

It manages the configuration of user privileges for accessing the server.

It will use [client] options by default unless you provide --login-path.

It can be used to create and edit SSL certificates and log locations.

It provides an interface to change my.cnf files.

dba.configureInstance()

cluster.setPrimaryInstance()

dba.configureLocalInstance()

cluster.forceQuorumUsingPartitionOf()

cluster.addInstance()

dba.createCluster()

dba.checkInstanceConfiguration()