Exam Code: 1Z0-883 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: MySQL 5.6 Database Administrator
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-883 Exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-883 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-883 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-883-exam-dumps.html
Q11. 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: B
Q12. Which two options describe how MySQL Server allocates memory?
A. Each thread allocates memory from a global pool.
B. Global memory resources are allocated at server startup.
C. Thread memory is pre-allocated up to thread_cache_size for performance.
D. Each connection may have its own per-thread memory allocations.
Answer: B,D
Q13. A general purpose MySQL instance is configured with the following options:
-- log-slow-queries -- long-query-time=,0001 -- log-slow-admin-queries -- general-log -- log-bin -- binlog-format=STATEMENT -- innodb-flush-log-at-trx-commit=1
Which three statements are true?
A. The General Query Log records more data than the Binary Log.
B. The binary Log records more data than the General Query Log.
C. The Slow Query Log records more data than the General Query Log.
D. The General Query Log records more data than the Slow Query Log.
E. The Slow Query Log records more data than the Binary Log.
F. The Binary Log records more data than the Slow Query Log.
Answer: A,D,E
Q14. You have been notified that the ‘apps’ . ‘reports’ table has been accidentally truncated.
You have single file mysqldump backup available taken prior to the truncate. The backup contains all the tables from the instance, and the ‘apps’ . ‘reports’ table must be restored without affecting the other remaining databases and tables.
Which restore option is suitable in this scenario?
A. Restore the backup to another databases instance and obtain a copy of the reports table individually.
B. Extract the ‘apps’ . ‘reports’ table from the backup using the SOURCE command.
C. Execute LOAD DATA INFILE ‘backup.sql’ SCHEMA=’apps’ TABLE= ‘reports’
D. Execute mysqldump on the backup,sql file and apply – filter arguments to obtain only the ‘apps’ . ‘reportys’ table.
Answer: B
Q15. 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: D
Reference: http://dev.mysql.com/doc/refman/5.6/en/audit-log-plugin-installation.html
Q16. Which two statements are true about InnoDB auto-increment locking?
A. The auto-increment lock can be a table-level lock.
B. InnoDB never uses table-level locks.
C. Some settings for innodb_autoinc_lock_mode can help reduce locking.
D. InnoDB always protects auto-increment updates with a table-level lock.
E. InnoDB does not use locks to enforce auto-increment uniqueness.
Answer: A
Reference: http://dev.mysql.com/doc/refman/5.6/en/innodb-auto-increment-
configurable.html
Q17. In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?
A. Disk usage when storing data
B. Syntax when writing queries involving JOINS
C. Comparing the encoded data with similar columns on other tables
D. Memory usage when working with the data
E. Character set mapping index hash size
Answer: C,D,E
Q18. Which query would you use to find connections that are in the same state for longer than 180 seconds?
A. SHOW FULL PROCESSLIST WHEER Time > 180; B. SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 180 SECOND) );
C. SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE < (DATE_SUB (NOW ( ), INTERVAL 180 SECOND) );
D. SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;
Answer: A
Q19. You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server’s binary log information?
A. Include-master-info
B. Master-binlog
C. Include-log-file
D. Master-data
Answer: D
Q20. Consider the following:
Mysql> EXPLAIN SELECT * FROM City WHERE Name = ‘Jacksonville’ AND CountryCode = ‘USA’ \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where
Which statement best describes the meaning of the value for the key_len column?
A. It shows the total size of the index row.
B. It shows how many columns in the index are examined.
C. It shows the number of characters indexed in the key.
D. It shows how many bytes will be used from each index row.
Answer: C