Oracle Oracle Database Application Development 1Z0-883 Questions & Answers

• Question 11:

  Which three data components are needed for point-in-time recovery?

  A. The error log

  B. The backup log

  C. The general query log

  D. Binary logs

  E. The data backup

  F. Configuration files

  Correct Answer: DEF

• Question 12:

  While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.

  Which method will reduce the number of file handles in use?

  A. Disconnecting idle localhost client sessions

  B. Implementing storage engine data compression options

  C. Relocating your data and log files to separate storage devices

  D. Activating the MySQL Enterprise thread pool plugin

  Correct Answer: A

• Question 13:

  Which two are true regarding MySQL binary and text backups?

  A. Binary backups are usually faster than text backups.

  B. Binary backups are usually slower than text backups.

  C. Text backups are human-readable while binary backups are not.

  D. Binary backups are not portable across different operating systems.

  Correct Answer: CD

• Question 14:

  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.

  Correct Answer: BC

• Question 15:

  Which three methods will show the storage engine for the Country table?

  A. SHOW CREATE TABLE Country;

  B. SHOW ENGINE Country STATUS;

  C. SHOW TABLE STATUS LIKE `Country';

  D. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= `Country';

  E. SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= `Country';

  Correct Answer: ADE

• Question 16:

  You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.

  Which two variables would likely fix this issue?

  A. Table_open_cache

  B. Table_open_cache_instancs

  C. Table_definition_cache

  D. Tmp_table_size

  E. Max_heap_table_size

  F. Max_tmp_tables

  Correct Answer: DE

• Question 17:

  Consider the MySQL Enterprise Audit plugin.

  On attempting to start the MySQL service after a crash, notice the following error:

  [ERROR] Plugin `audit_log' init function returned error.

  In the audit log file, you notice the final entry:

  ...

  TIMESTAMP="2013-07-09T02:12:35"

  NAME="Connect"

  CONNECTION_ID="98"

  STATUS="0"

  USER="Kate"

  PRIV_USER="kate"

  OS_LOGIN=""

  HOST="localhost"

  DB=""/>

  What action should you take to fix the error and allow the service to start?

  A. Re-install the audit plugin.

  B. Execute the command FLUSH LOGS.

  C. Execute the command SET GLOBAL audit_log_fiush= ON.

  D. Move or rename the existing audit.log file.

  Correct Answer: B

• Question 18:

  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.

  Correct Answer: ADE

• Question 19:

  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.

  Correct Answer: BD

• Question 20:

  A MySQL replication slave is set up as follows: User all InnoDB tables Receives ROW-based binary logs Has the read-only option

  The replication slave has been found in an error state.

  You check the MySQL error log file and find the following entries:

  2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry `3' for key'PRIMARY' , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log 56_master-bin.000003, end_log_pas 653, Error_code: 1062 2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry `3' for key `PRIMARY' Error_code: 1062 2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START", We stopped at log `56_master- bin.000003' position

  What are two possible causes for this error to occur?

  A. The slave was created with mysqldump u root p skip-lock-table--all-databases > /data/data.sql

  B. The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function.

  C. For tables with UNIQUE keys, statement-based replication must be used maintain integrity.

  D. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

  E. The applications have the SUPER privilege, which allows them to update rows.

  Correct Answer: AE