1z1-908 試験問題を無料オンラインアクセス

Which two statements are true about MySQL Installer? (Choose two.)

• A.It performs product upgrades.
• B.It provides only GUI-driven, interactive installations.
• C.Manual download of separate product packages is required before installing them through MySQL Installer.
• D.It installs most Oracle MySQL products.
• E.It provides a uniform installation wizard across multiple platforms.

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

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

You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

• A.The mysqlcheck --optimize --all-databases command reclaims free space from table files.
• B.The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
• C.The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
• D.The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
• E.The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

Which two are true about binary logs used in asynchronous replication? (Choose two.)

• A.They contain events that describe database changes on the master.
• B.They contain events that describe only administrative commands run on the master.
• C.They contain events that describe all queries run on the master.
• D.They are pulled from the master to the slave.
• E.They are pushed from the master to the slave.

Which step or set of steps can be used to rotate the error log?

• A.Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
• B.Execute SET GLOBAL log_error = '<new error log file>'.
• C.Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
• D.Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.