Join the discussion
Question 1/77
What is the correct syntax for using transparent data encryption with an existing InnoDB table?
Correct Answer: A
Add Comments
- Other Question (77q)
- Q1. What is the correct syntax for using transparent data encryption with an existing InnoDB t...
- Q2. Which statement is true about InnoDB persistent index statistics?...
- Q3. Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchem...
- Q4. The mysqld instance has the connection control plugin enabled with these settings: connect...
- Q5. How can mysql_multi be configured to allow MySQL instances to use the same port number?...
- Q6. Consider this shell output and executed commands: [root@oel7 ~]# ps aux | grep mysqld mysq...
- Q7. Examine this snippet from the binary log file named binlog.000036: (Exhibit) The rental ta...
- Q8. Examine these statements, which execute successfully: TRUNCATE test; BEGIN; INSERT INTO te...
- Q9. Your MySQL installation is running low on space due to binary logs. You need to reduce you...
- Q10. Your MySQL environment has asynchronous position based-replication with one master and one...
- Q11. Which two are valid uses for binary logs on a MySQL instance? (Choose two.)...
- Q12. You are considering using file-system snapshots to back up MySQL. Which three statements a...
- Q13. Which two are features of MySQL Enterprise Firewall? (Choose two.)...
- Q14. A colleague complains about slow response time on your website. Examine this query and out...
- Q15. All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled. Yo...
- Q16. Examine this statement, which executes successfully: (Exhibit) Now examine this query: (Ex...
- Q17. Which statement is true about InnoDB persistent index statistics?...
- Q18. Examine these InnoDB Cluster parameter settings: (Exhibit) Now examine the partial status:...
- Q19. You issue this command: SHOW SLAVE STATUS - In the output, there is a value for Seconds_be...
- Q20. Examine Joe's account: CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*' GRANT ALL PRIVILEGES...
- Q21. A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation. Which...
- Q22. The data in this instance is transient; no backup or replication will be required. It is c...
- Q23. Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)...
- Q24. Examine this command, which executes successfully: (Exhibit) Which statement is true?...
- Q25. Which step or set of steps can be used to rotate the error log?...
- Q26. Examine this command and output: (Exhibit) Which two statements are true? (Choose two.)...
- Q27. Which three are characteristics of a newly created role? (Choose three.)...
- Q28. An existing asynchronous replication setup is running MySQL 8. Which two steps are a part ...
- Q29. Examine this MySQL Shell command: dba.rebootClusterFromCompleteOutage() Which two statemen...
- Q30. You plan to take daily full backups, which include the ndbinfo and sys (internal) database...
- Q31. Examine this query: (Exhibit) What information does this query provide?...
- Q32. What does the binlog dump thread do?
- Q33. You are using mysqlcheck for server maintenance. Which two statements are true? (Choose tw...
- Q34. Which two are true about binary logs used in asynchronous replication? (Choose two.)...
- Q35. You are backing up raw InnoDB files by using mysqlbackup. Which two groups of files will b...
- Q36. You have configured GTID-based asynchronous replication with one master and one slave. A u...
- Q37. You plan to take daily full backups, which include the ndbinfo and sys (internal) database...
- Q38. You encountered an insufficient privilege error in the middle of a long transaction. The d...
- Q39. Examine this statement, which executes successfully: (Exhibit) You want to improve the per...
- Q40. A user wants to connect without entering his or her username and password on the Linux com...
- Q41. Examine this query and output: (Exhibit) Which two statements are true? (Choose two.)...
- Q42. Your MySQL instance is capturing a huge amount of financial transactions every day in the ...
- Q43. Which statement is true about cold backups?
- Q44. Examine this command and output: (Exhibit) Which two options will improve the security of ...
- Q45. You have an InnoDB Cluster configured with three servers. Examine this command, which exec...
- Q46. Which two storage engines provide a view of the data consistent with the storage system at...
- Q47. Which four connection methods can MySQL clients specify with the --protocol option when co...
- Q48. Which two queries are examples of successful SQL injection attacks? (Choose two.)...
- Q49. Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT u...
- Q50. Which condition is true about the use of the hash join algorithm?...
- Q51. You wish to store the username and password for a client connection to MySQL server in a f...
- Q52. You are upgrading a MySQL instance to the latest 8.0 version. Examine this output: (Exhibi...
- Q53. Examine these entries from the general query log: (Exhibit) All UPDATE statements referenc...
- Q54. Examine the modified output: (Exhibit) Seconds_Behind_ Mastervalue is steadily growing. Wh...
- Q55. You wish to protect your MySQL database against SQL injection attacks. Which method would ...
- Q56. A clean shutdown was performed with innodb_fast_shutdown=0. While you were manipulating fi...
- Q57. Examine this MySQL client command to connect to a remote database: mysql -h remote.example...
- Q58. You have semi-synchronous replication configured and working with one slave. rpl_semi_sync...
- Q59. You have replication configured, which consists of one master and one slave on different h...
- Q60. Examine this command, which executes successfully: mysqlpump -–user=root --password > ...
- Q61. Your MySQL server was upgraded from an earlier major version. The sales database contains ...
- Q62. There are five MySQL instances configured with a working group replication. Examine the ou...
- Q63. You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnfparameters to s...
- Q64. Which three sets of item information are visible in the mysql system database? (Choose thr...
- Q65. You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade. E...
- Q66. An attempt to recover an InnoDB Cluster fails. Examine this set of messages and responses:...
- Q67. Examine this SQL statement: (Exhibit) Which set of privileges will allow Tom to execute th...
- Q68. You are upgrading a MySQL instance to the latest 8.0 version. Examine this output: (Exhibi...
- Q69. You plan to install MySQL Server by using the RPM download. Which two statements are true?...
- Q70. Which three are types of InnoDB tablespaces? (Choose three.)...
- Q71. Examine these commands and output: (Exhibit) Which connection ID is holding the metadata l...
- Q72. Which two are characteristics of snapshot-based backups? (Choose two.)...
- Q73. You want to check the values of the sort_buffer_sizesession variables of all existing conn...
- Q74. You made some table definition changes to a schema in your MySQL Server. Which two stateme...
- Q75. Which two statements are true about MySQL Installer? (Choose two.)...
- Q76. A colleague complains about slow response time on your website. Examine this query and out...
- Q77. You execute this command: shell> mysqlpump --exclude-databases=% --users Which statemen...
