You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

• A.MySQL keeps InnoDB metadata changes in .sdi files in datadir.
• B.MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
• C.The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
• D.MySQL writes SDI to the binary log for distributed backups.
• E.MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

Comment: *

Name: *

Email: *

Verification: *

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

• A.systemd found the mysqld service disabled and failed to start it.
• B.systemd waited for 30 seconds before timing out and start up failed.
• C.systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
• D.MySQL server continued to start up even though another process existed.
• E.MySQL server was not started due to a problem while executing process 2732.

Comment: *

Name: *

Email: *

Verification: *

You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?

• A.using stored procedures for any database access
• B.using PREPARED STATEMENTS
• C.avoiding concatenation of SQL statements and user-supplied values in an application
• D.installing and configuring the Connection Control plugin

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about InnoDB persistent index statistics?

• A.Tables are scanned and index statistics recalculated when an instance is restarted.
• B.Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
• C.Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
• D.Updating index statistics is an I/O expensive operation.
• E.Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
• F.Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

Comment: *

Name: *

Email: *

Verification: *

You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

• A.*.sdi files
• B.*.CSM files
• C.*.ibd files
• D.ib_logfile* files
• E.ibbackup files

Comment: *

Name: *

Email: *

Verification: *