Free Oracle 1Z0-908 Exam Dumps Questions & Answers

You issue this command:
SHOW SLAVE STATUS -
In the output, there is a value for Seconds_behind_master.
How is this time calculated?

• A.It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.
• B.It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.
• C.It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.
• D.It is the time between the I/O thread receiving details of the master's last transaction and the time it was written to the relay log on the slave.

Examine this query and its output:

Which two statements are true? (Choose two.)

• A.The root user had the largest number of modified rows for a SELECT statement.
• B.User bob had the largest total time waiting for locks.
• C.The app user had the highest total number of rows read from storage engines.
• D.User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.
• E.The root user had the largest single wait time.

You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?

• A.on master: --replicate-ignore-db=example
• B.on master: --binlog-ignore-db=example
• C.on slave: --replicate-ignore-db=example
• D.on slave: --binlog-ignore-db=example
• E.on slave: --replicate-wild-ignore=example.%

Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

• A.ARCHIVE
• B.InnoDB
• C.NDB
• D.MyISAM
• E.MEMORY

Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?

• A.mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql
• B.mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
• C.mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql
• D.mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql