Cause all that matters here is passing the Oracle 1Z0-883 exam. Cause all that you need is a high score of 1Z0-883 MySQL 5.6 Database Administrator exam. The only one thing you need to do is downloading Testking 1Z0-883 exam study guides now. We will not let you down with our money-back guarantee.

Q1. Which two are correct steps in taking a binary backup of MyISAM tables? 

A. Always stop the server prior to the backup. 

B. Stop the server or lock the tables prior to the backup. 

C. Stop the server or lock the databases prior to the backup. 

D. Make a copy of the .frm, .myd, and the .myi files. 

E. Make a copy of the binary log and tablespace files. 

Answer: B,D 

Reference: http://dev.mysql.com/doc/refman/5.6/en/backup-methods.html 


Q2. You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. 

C: > mysqld – install Mysql56 – defaults – file = C : my –opts.cnf 

What is the expected outcome? 

A. Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: my-opts.cnf configuration file. 

B. Mysql is installed as the Windows service name Mysql56, and uses c: my-opts.cnf as the configuration file 

C. An error message is issued because – install is not a valid option for mysqld. 

D. A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: my-opts.cnf. 

Answer:


Q3. Which two capabilities are granted with the SUPER privilege? 

A. Allowing a client to kill other client connections 

B. Allowing a client to shut down the server 

C. Allowing change of the server runtime configuration 

D. Allowing client accounts to take over the account of another user 

Answer: A,B 

Reference: http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html 


Q4. Identify a performance impact when using the Performance Schema. 

A. There is no impact on performance. 

B. There is an overhead for querying the Performance Schema but not for having it enabled. 

C. There is a constant overhead regardless of settings and workload. 

D. The overhead depends on the settings of the Performance Schema. 

Answer:


Q5. Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. 

Which two statements are correct? 

A. Both technologies use the TCP/IP stack as their primary transmission medium. 

B. DRBD uses shared-disk technology. 

C. Both technologies guarantee an identical copy of data on the secondary node. 

D. Only MySQL can maintain a time-delayed copy of data on the secondary node. 

Answer:


Q6. Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new 

application, which heavily reads and writes data. 

This requires the following config file options: 

Sync_binlog=1 

Innodb_flush_log_at_trx_commit=1 

Innodb_doublewrite=1 

However, this configuration is expected to introduce disk I/O overhead. 

What three changes will reduce disk I/O overheads? 

A. Use of soft links for database directories on the same physical disk 

B. Use of separate directories on the same physical disk for log files and data files 

C. Placement of InnoDB log files and datadir on separate physical disks 

D. Allocation of RAM to the buffer pool such that more of the data can fit in RAM 

E. Use of delay_key_write=ON for batch index update 

Answer: D,E 


Q7. Consider the following statement on a RANGE partitioned table: 

ALTER TABLE orders DROP PARTITION p1, p3; 

What is the outcome of executing the above statement? 

A. Only the first partition (p1) will be dropped as only one can be dropped at any time. 

B. All data in p1 and p3 partitions are removed, but the table definition remains unchanged. 

C. A syntax error will result as you cannot specify more than one partition in the same statement. 

D. All data in pi and p3 partitions are removed and the table definition is changed. 

Answer:

Reference: http://docs.oracle.com/cd/F49540_01/DOC/server.815/a67772/partiti.htm 


Q8. 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”; 

Answer:


Q9. A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. 

Which two will optimize the security of this setup? 

A. Disabling connections from named pipes or socket files (depending on the operating system of the server) 

B. Running the server with – skip-networking specified 

C. Limiting logins to originate from the application server or the server’s subnet 

D. Starting the server with – bind- address=0.0.0.0 specified 

E. Installing Mysql on the application server, and running the database and application on the same server 

F. Enabling and using SSL for connections to the Mysql database 

Answer: E,F 


Q10. You are attempting to secure a MySQL server by using SSL encryption. 

On starting MySQL, you get this error: 

130123 10:38:02 [ERROR] mysqld: unknown option ‘—ssl’ 

What is the cause of the error? 

A. The --- ssl level was not specified. 

B. The server was not started with the – enable--ssl-plugin option. 

C. -- ssl is not a valid server option. 

D. The mysqld binary was not compiled with SSL support. 

E. The server’s SSL certificate was invalid. 

Answer: