Oracle Oracle Certifications 1Z0-888 Questions & Answers

• Question 131:

  Which are three facts about backups with mysqldump? (Choose three.)

  A. will lock all storage engines for duration of backup

  B. can back up a remote database server

  C. allow a consistent backup to be taken

  D. are able to back up specific items within a database

  E. create automatically compressed backups

  F. are always faster to restore than binary backups

  Correct Answer: BCD

• Question 132:

  Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

  A. It caches index blocks for MyISAM tables only.

  B. It caches index blocks for all storage engine tables.

  C. It is a global buffer.

  D. It is set on a per-connection basis.

  E. It caches index blocks for InnoDB tables only.

  Correct Answer: AD

  Reference: https://stackoverflow.com/questions/3663515/mysql-what-is-the-key-buffer

• Question 133:

  You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)

  A. log-master-updates

  B. rpl-recovery-rank

  C. server-id

  D. enable-master-start

  E. log_bin

  F. master-logging

  Correct Answer: CE

  Reference: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-inmysql

• Question 134:

  You have a MySQL instance with the following variables in the /etc/my.cnf file: You issue these statements:

  

  USE prices;

  UPDATE sales.january SET amount=amount+1000;

  An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.

  Which statement is true? (Choose two.)

  A. You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.

  B. The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW

  C. The statement would fail because you cannot update more than one row at a time when using --binlogformat = ROW.

  D. Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.

  E. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

  Correct Answer: DE

• Question 135:

  You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

  

  What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

  A. to allow the remaining events to be processed on the slave while not receiving new events from the master

  B. to allow a backup to be created under reduced load

  C. to allow for point-in-time recovery on the slave

  D. to prevent schema changes from propagating to the slave before they are validated

  E. to prevent any transaction experiencing a deadlock

  Correct Answer: BC

• Question 136:

  Which two methods accurately monitor the size of your total database size over time? (Choose two.)

  A. monitoring the Innodb_rows_inserted status variable

  B. monitoring the innodb_redo_log_size variable

  C. monitoring the information_schema.TABLES table

  D. monitoring datadir size in the operating system

  E. monitoring cumulative Innodb_page_size increase

  F. monitoring the performance_schema_hosts_size variable

  Correct Answer: CF

• Question 137:

  Consider the index information for the dept_emp table in the employee's schema:

  

  Which two conclusions can be made based on the output of the query? (Choose two.)

  A. There are three indexes on the table.

  B. There is a redundant index on the dept_no column.

  C. The secondary indexes are optimized for unique key look-ups.

  D. The values on the emp_no column must be unique.

  E. The selectivity of the dept_no column is the best of the indexed columns.

  F. There is a redundant index on the emp_no column.

  Correct Answer: CF

• Question 138:

  Which two statements are true about InnoDB auto-increment locking? (Choose two.)

  A. InnoDB never uses table_level locks.

  B. InnoDB always protects auto-increment updates with a table-level lock

  C. InnoDB does not use locks to enforce auto-increment uniqueness.

  D. The auto-increment lock can be a table-level lock.

  E. Some settings for innodb_autoinc_lock_mode can help reduce locking.

  Correct Answer: DE

• Question 139:

  You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.

  Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)

  A. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.

  B. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.

  C. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

  D. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

  E. Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

  Correct Answer: BE

• Question 140:

  Which three allocate memory per thread in MySQL? (Choose three.)

  A. query cache

  B. thread cache

  C. read buffer

  D. internal temporary table

  E. sort buffer

  F. InnoDB buffer pool instance

  Correct Answer: CEF

  Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html