Loading questions...
Updated
Which three requirements must be enabled for group replication? (Choose three.)
Which three are types of InnoDB tablespaces? (Choose three.)
You have semi-synchronous replication configured and working with one slave. rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true? (Choose two.)
The mysqld instance has the connection control plugin enabled with these settings: connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000
The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
A command is executed:
mysql> SET GLOBAL connection_control_min_connection_delay=3000;
What is the result?
Examine this statement and output:
Which two statements are true about MySQL Enterprise Backup? (Choose two.)
Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:
Examine this command and output:
What is the correct syntax for using transparent data encryption with an existing InnoDB table?
Examine this command, which executes successfully:
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:
How can mysql_multi be configured to allow MySQL instances to use the same port number?
What does the slave I/O thread do?
You have an installation of MySQL 8 on Oracle Linux.
Consider the outputs:
Which three are requirements for a secure MySQL Server environment? (Choose three.)
Examine this parameter setting:
audit_log=FORCE_LOG_PERMANENT
What effect does this have on auditing?
Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup --optimistic-busy-tables="^finance.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?
You issue this command:
SHOW SLAVE STATUS -
In the output, there is a value for Seconds_behind_master.
How is this time calculated?
All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)
You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)
Examine this snippet from the binary log file named binlog.000036:
Examine these entries from the general query log:
You want to dump all databases with names that start with "db".
Which command will achieve this?
Examine this statement, which executes successfully:
You want to improve the performance of this query:
Which change enables the query to succeed while accessing fewer rows?
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
Which two SQL statements can jsmith execute? (Choose two.)
Which statement is true?
Which statement is true?
Which statement is true?
What statement is true about the start attempt?
Which statement is true about disk temporary tables for this installation?
The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?