Free Oracle 1z0-883 Exam Dumps Questions & Answers

A MySQL replication slave is set up as follows:
-User 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 the following entries:
2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry '3' for key'PRIMARY' , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log 56_master-bin.000003, end_log_pas 653,
Error_code: 1062 2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry '3' for key 'PRIMARY'
Error_code: 1062
2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START", We stopped at log '56_masterbin.000003' position 496
What are two possible causes for this error to occur?

• A.  The applications have the SUPER privilege, which allows them to update rows.
• B.  The slave was created with mysqldump -u root -p - skip-lock-table-all-databases > /data/data.sql
• C.  For tables with UNIQUE keys, statement-based replication must be used maintain integrity.
• D.  The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function.
• E.  The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?

• A.  It implements High Availability by using the .NET Connector's load balancing capabilities.
• B.  It is shared-nothing architecture.
• C.  It relies on the shared disk architecture being visible to both servers.
• D.  It is provided by means of IP- level disk replication.

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.
Which two conditions must be true?

• A.  The slave database cannot have more columns than the master. Only the master database can have more columns.
• B.  The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.
• C.  Each extra column in the copy with more columns must not have a default value.
• D.  Columns that are common to both versions of the table must be defined in the same order on the master and the slave.
• E.  Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.

Assume that you want to know which Mysql Server options were set to custom values.
Which two methods would you use to find out?

• A.  Check the output of SHOW GLOBAL VARIABLES and compare it with default values.
• B.  Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.
• C.  Check the command-line options provided for the Mysql Server and compare them with default values.
• D.  Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.

You are using the performance Schema to investigate replication on a slave:
Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime
FROM performance_schema.events_waits_summary_by_thread_by_event_name
INNER JOIN performance_schema_threads USING (THREAD_ID)
WHERE threads .NAME LIKE 'thread/sql/slave\-%'
GROUP BY THREAD_ID, threads.NAME;

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?

• A.  The server needs more cores to use all slave threads.
• B.  The slave is configured with slave_parallel_workers = 4.
• C.  The slave cannot process the relay log fast enough to use all threads.
• D.  At most two schemas are being updated concurrently.