Online Access Free 1Z0-908 Exam Questions

Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

• A.Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
• B.Increasing slave_parallel_workers will improve high availability.
• C.Each slave thread is responsible for updating a specific database.
• D.Setting transaction_allow_batching to on will improve data consistency.
• E.Setting slave_preserve_commit_order to on will improve data consistency.
• F.Cross-database constraints can cause database inconsistency.

Examine this query and output:

Which two statements are true? (Choose two.)

• A.It takes more than 8 milliseconds to sort the rows.
• B.The query returns exactly 125 rows.
• C.35 rows from the city table are included in the result.
• D.The country table is accessed as the first table, and then joined to the city table.
• E.The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.

Which three sets of item information are visible in the mysql system database? (Choose three.)

• A.rollback segments
• B.plugins
• C.audit log events
• D.information about table structures
• E.time zone information and definitions
• F.help topics
• G.performance monitoring information

Which three requirements must be enabled for group replication? (Choose three.)

• A.binary log checksum
• B.replication filters
• C.primary key or primary key equivalent on every table
• D.slave updates logging
• E.binary log MIXED format
• F.semi-sync replication plugin
• G.binary log ROW format

t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?

• A.mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
• B.If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
• C.If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.
• D.If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.