Which MySQL utility copies the master instance to a slave instance on the same host?

• A.mysqlfailover
• B.mysqldbcopy
• C.mysqlrplsync
• D.mysqlserverclone

Comment: *

Name: *

Email: *

Verification: *

Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

• A.It is a global buffer.
• B.It caches index blocks for MyISAM tables only.
• C.It caches index blocks for all storage engine tables.
• D.It is set on a per-connection basis.
• E.It caches index blocks for InnoDB tables only.

Comment: *

Name: *

Email: *

Verification: *

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

• A.setting the --open-files-limit=0 option when starting mysqld
• B.setting the --local-infile=0 option when starting mysqld
• C.executing REVOKE LOAD FROM *.*
• D.setting the --local-service=0 option when starting mysqld
• E.executing REVOKE FILE FROM *_*
• F.executing REVOKE FILE ON *_* FROM ` `@'%'

Comment: *

Name: *

Email: *

Verification: *

Which two methods will provide the total number of partitions on a table? (Choose two.)

• A.Query the INFORMATION_SCHEMA.PARTITIONS table
• B.Use the command: SHOW TABLE STATUS
• C.Query the performance_schema.objects_summary_global_by_type table
• D.Query the INFORMATION_SCHEMA.TABLES table for the partition_count
• E.Use the command: SHOW CREATE TABLE

Comment: *

Name: *

Email: *

Verification: *

Which three tasks are handled by the optimizer?

• A.Change the order in which the tables are joined.
• B.Rewrite the WHEREclause.
• C.Execute the query.
• D.Parse the query.
• E.Validate the query.
• F.Verify that the user is allowed to execute the query.
• G.Decide which indexes to use.

Comment: *

Name: *

Email: *

Verification: *