Free Oracle 1Z0-908 Exam Dumps Questions & Answers

Examine this snippet from the binary log file named binlog.000036:

The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?

• A.mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql
• B.mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql
• C.mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql
• D.mysqlbinlog --stop-position=500324 binlog.000036 | mysql

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

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

Which command enables rule-based MySQL Auditing capabilities?

• A.shell> mysql < audit_log_filter_linux_install.sql
• B.shell> mysqld --initialize --log-raw=audit.log
• C.mysql> INSTALL PLUGIN audit_log;
• D.mysql> INSTALL COMPONENT audit_log;

Which three statements are true about MySQL replication? (Choose three.)

• A.Binary logs contain only transactions originating from a single MySQL instance.
• B.Replication can use only TCP/IP connections.
• C.Any instance can have multiple slaves, but it can have only one master.
• D.Each instance in a replication topology must have a unique server ID.
• E.A replication user must have the SELECT privilege for all tables that need to be replicated.
• F.Each slave must have its own MySQL user for replication.
• G.Binary logging must be enabled on the master in order to replicate to other instances.

What does the binlog dump thread do?

• A.It reads the relay log and executes the events contained in them.
• B.It monitors and schedules the rotation/deletion of the binary logs.
• C.It connects to the master and asks it to send updates recorded in its binary logs.
• D.It acquires a lock on the binary log for reading each event to be sent to the slave.