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 Examcollection 1Z0-883 exam study guides now. We will not let you down with our money-back guarantee.

Q1. 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. 

Answer:


Q2. What are four capabilities of the mysql client program? 

A. Creating and dropping databases 

B. Creating, dropping, and modifying tables and indexes 

C. Shutting down the server by using the SHUTDOWN command 

D. Creating and administering users 

E. Displaying replication status information 

F. Initiating a binary backup of the database by using the START BACKUP command 

Answer: B,D,E,F 


Q3. 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. 

Answer:


Q4. A Mysql Server has been running an existing application successfully for six months. 

The my.cnf is adjusted to contain the following additional configuration: 

[mysqld] 

Default-authentication-plugin=sha256_password 

The Mysql Server is restarted without error. 

What effect will the new configuration have in existing accounts? 

A. They will have their passwords updated on start-up to sha256_password format. 

B. They will have to change their password the next time they login to the server. 

C. They are not affected by this configuration change. 

D. They all connect via the secure sha256_password algorithm without any configuration change. 

Answer:

Reference: http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html 


Q5. Which two events will cause a slave server to create a new relay log file? 

A. Starting of the I/O thread 

B. Execution of the FLUSH LOGS statement 

C. Starting of the SQL thread 

D. Reaching the slave_pendign _jobs_size_max limit 

E. Execution of FULSH TABLES WITH READ LOCK 

Answer: A,B 

Reference: http://dev.mysql.com/doc/refman/5.1/en/slave-logs-relaylog.html 


Q6. Which three tasks can be performed by using the performance Schema? 

A. Finding queries that are not using indexes 

B. Finding rows that are locked by InnoDB 

C. Finding client connection attributes 

D. Finding the part of a code in which a single query is spending time 

E. Finding the size of each table 

Answer: A,B,C 


Q7. What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine? 

A. Mysql Enterprise Backup 

B. Mysqldump with – binary-data option 

C. Mysqlhotcopy 

D. File system snapshots 

E. Mysqldumpslow 

Answer: A,B 

Reference: http://dev.mysql.com/doc/refman/5.5/en/innodb-backup.html 


Q8. Consider the MySQL Enterprise Audit plugin, 

You add the following lines to the my.cnf configuration tile: 

[mysqld] 

Plugin-load=audit_log.so 

Audit-log=FORCE_PLUS_PERMANENT 

You attempt to start up the MySQL service and notice that it fails to start. 

Which two statements would explain why the service did not start? 

A. FORCE_PLUS_PERMANENT is not valid for the audit-log option. 

B. The audit_log.so library does not exist. 

C. The audit_log.so library is in a location that is different from that defined by the plugin_dir option. 

D. The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command. 

E. The audit log file does not exist in which to write audit events. 

F. The audit_log.so library is not an executable file. 

Answer:

Reference: http://dev.mysql.com/doc/refman/5.6/en/audit-log-plugin-installation.html 


Q9. Which two requirements would lead towards a high availability solution? 

A. When uptime is critical 

B. When data must be refactored 

C. When application concurrency is static 

D. When data loss is unacceptable 

E. When application is a single point of failure 

Answer: A,D 


Q10. Consider the events_% tables in performance Schema. 

Which two methods will clear or reset the collected events in the tables? 

A. Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current; 

B. Using the statement RESET PERFORMANCE CACHE; 

C. Using the statement FLUSH PERFORMANCE CACHE; 

D. Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current; 

E. Disabling and re-enabling all instruments 

F. Restarting Mysql 

Answer: D,E 

Reference: http://dev.mysql.com/doc/refman/5.5/en/performance-schema-timing.html