Crack4sure Logo
3 Months Free Update
3 Months Free Update
3 Months Free Update
Examine this command, which executes successfully:
cluster.addInstance(‘
Which three statements are true? (Choose three.)
A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1.Confirm that secure_file_priv=’/var/tmp’
2.mysql> DROP TABLE shop.customers;
3.shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)
Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, “Hello”); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)
Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)
You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:
Which action would allow the server to start?
Examine this statement, which executes successfully:
Now examine this query:
Which two statements can do this? (Choose two.)
Examine this query and output:
Which two statements are true? (Choose two.)
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:
Which option will allow this client to connect to MySQL Server?
Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?
Examine these InnoDB Cluster parameter settings:
Now examine the partial status:
A permanent network failure isolates host3.
Which two statements are true? (Choose two.)
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
How can mysql_multi be configured to allow MySQL instances to use the same port number?
Your my.cnf file contains these settings:
You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?
Which three sets of item information are visible in the mysql system database? (Choose three.)
You issue this command:
SHOW SLAVE STATUS -
In the output, there is a value for Seconds_behind_master.
How is this time calculated?
Which two statements are true about MySQL Enterprise Backup? (Choose two.)
Which two are valid uses for binary logs on a MySQL instance? (Choose two.)
Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:
Which two statements are true? (Choose two.)
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
You want to dump all databases with names that start with "db".
Which command will achieve this?
Which three are types of information stored in the MySQL data dictionary? (Choose three.)
Examine this command, which executes successfully:
mysqlpump -–user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
Examine this query and its output:
Which two statements are true? (Choose two.)
Examine these entries from the general query log:
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?
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?
Examine these commands and output:
Which connection ID is holding the metadata lock?
Examine the modified output:
Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user’s mysql credentials to satisfy this requirement? (Choose three.)
You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.
Examine the message sequence generated during the first start of MySQL 8.0.18:
Which step or set of steps will resolve the errors?
Examine this command and output:
Which two statements are true? (Choose two.)
TESTED 12 Sep 2025