Oracle 1Z0-883 dumps - 100% Pass Guarantee!

A simple master-to-slave replication is currently being used. The following information is extracted from the

SHOW SLAVE STATUS output:

Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database:

'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') ' Skip_Counter: 0

Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1

You execute a "SHOW CREATE TABLE mytable" on the slave:

CREATE TABLE `mytable' (

`ID' int(11) NOT NULL DEFAULT `0',

`name' char(10) DEFAULT NULL,

PRIMARY KEY (`ID')

)

The table mytable on the slave contains the following:

You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error.

Which statement should be used?

A. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

B. SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT=" AUTOMATIC';

C. SET GLOBAL enforce_gtid_consistency=ON

D. SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9";

E. SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";

Consider the Mysql Enterprise Audit plugin.

The following event detail is found in the audit log:

CONNECTION_ID=”3”

STATUS=”1045” USER=”kate” PROXY_USER=”” HOST=”localhost” IP=”” DB=””/>

Which two points can be concluded from the given event?

A. A connection was blocked by a firewall or a similar security mechanism.

B. A connection was attempted via socket rather than TCP.

C. A connection failed because the proxy user privileges did not match the login user.

D. A connection as the user kate was successful.

E. A connection failed due to authentication being unsuccessful.

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. At most two schemas are being updated concurrently.

B. The server needs more cores to use all slave threads.

C. The slave cannot process the relay log fast enough to use all threads.

D. The slave is configured with slave_parallel_workers = 4.

In a test database, you issue the SELECT ... INTO OUTFILE statement to create a file with your t1 table

data.

You then TRUNCATE this table to empty it.

Mysql> SELECT * INTO OUTFILE `/tmp/t1.sql' from t1; mysql> TRUNCATE t1;

Which two methods will restore data to the t1 table?

A. Mysql> LOAD DATA INFILE `/tmp/t1.sql' INTO TABLE t1;

B. $ mysqladmin u root p h localhost test restore /tmp/t1.sql

C. $ mysql u root p h localhost test < /tmp/t1.sql

D. $ mysqlinport u root p h localhost test /tmp/t1.sql

E. Mysql> INSERT INTO t1 VALUES FROM `/tmp/t1.sql';

MySQL is installed on a Linux server and has the following configuration:

[mysqld]

User=mysql

Datadir=/data/mysql

As the `root' user, change the datadir location by executing:

Shell> cp R /var/lib/mysql/data/mysql/

Shell> chown R mysql /data/mysql/

What is the purpose of changing ownership of datadir to the `mysql' user?

A. MySQL cannot be run as the root user.

B. MySQL requires correct file ownership while remaining secure.

C. MySQL needs to be run as the root user, but file cannot be owned by it.

D. The mysqld process requires all permissions within datadir to be the same.