Which three are key advantages of standard MySQL replication? (Choose three.)A . supports native automatic failoverB . enables automatic resync of databases when discrepancies are detectedC . provides arbitrary geographic redundancy with minimal overhead to masterD . synchronously guarantees identical slave copyE . is easy to configure and has low performance overheadF . can...Continue reading
A MySQL replication slave is set up as follows: – Uses all InnoDB tables – Receives ROW-based binary logs – Has the read-only option The replication slave has been found in an error state. You check the MySQL error log file and find these entries: What are two possible causes for this error to...Continue reading
Which three allocate memory per thread in MySQL? (Choose three.)A . query cacheB . thread cacheC . read bufferD . internal temporary tableE . sort bufferF . InnoDB buffer pool instance View Answer Answer: C,E,F Explanation: Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html...
Examine the mydata table and SELECT statements: You issue: mysql> begin; mysql> update mydata set a=0 where b=3; How many rows are now protected by locks with the default InnoDB configuration?A . oneB . one row and a next-key lock for supremumC . one row and a gap-lockD . five View Answer Answer: D...
What is the order of tables shown in an EXPLAIN output?A . It lists tables from the smallest to the largest.B . It lists tables in the order in which their data will be read.C . It lists tables from the most optimized to the least optimized.D . It lists tables in the order...Continue reading
Which three statements correctly describe MySQL InnoDB Cluster? (Choose three.)A . The cluster can be operated in multimaster mode with conflict detection for DML statements.B . All MySQL client programs and connectors can be used for executing queries.C . It provides fully synchronous replication between the nodes.D . There is support for automatic failover...Continue reading
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)A . log-master-updatesB . rpl-recovery-rankC . server-idD . enable-master-startE . log-binF . master-logging View Answer Answer: C,E Explanation: Reference: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slavereplication-in-mysql...
You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)A . Start the MySQL Server in –safe-mode, which only loads...Continue reading
Which three tasks are handled by the optimizer? (Choose three.)A . Decide which indexes to use.B . Rewrite the WHERE clause.C . Parse the query.D . Change the order in which the tables are joined.E . Validate the query.F . Execute the query.G . Verify that the user is allowed to execute the query....Continue reading
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration: The MySQL Server is restarted without error. What effect will the new configuration have on existing account?A . They are not affected by this configuration change.B . They all connect via the...Continue reading