Oracle 1Z0-883 Online Practice Questions and Exam Preparation

Oracle 1Z0-883 Online Questions & Answers

• Question 11:

  Consider the Mysql Enterprise Audit plugin.

  The following event detail is found in the audit log:

  TIMESTAMP="2013-04-09t01:54:17"

  NAME="Connect"

  CONNECTION_ID="3"

  STATUS="1045"

  USER="kate"

  PROXY_USER=""

  HOST="localhost"

  IP=""

  DB=""/>

  Which two points can be concluded from the given event?

  A. A connection was blocked by a firewall or a similar security mechanism.
  B. A connection was attempted via socket rather than TCP.
  C. A connection failed because the proxy user privileges did not match the login user.
  D. A connection as the user kate was successful.
  E. A connection failed due to authentication being unsuccessful.
  D. A connection as the user kate was successful.

• Question 12:

  You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-running queries.

  Which statement will accomplish this?

  A. SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE HOST='192.168.1.15';
  B. SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE HOST=' 192.168.1.15';
  C. SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=' 192.168.1.15';
  D. SELECT * FROM INFORMATION_SCHEMA.INNODB_METEICS WHERE HOST=' 192.168.1.15';
  C. SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=' 192.168.1.15';

• Question 13:

  Which three are properties of the MyISAM storage engine?

  A. Transaction support
  B. FULLTEXT indexing for text matching
  C. Table and page level locking support
  D. Foreign key support
  E. Geospatial indexing
  F. HASH index support
  G. Table level locking only
  B. FULLTEXT indexing for text matching
  E. Geospatial indexing
  G. Table level locking only

• Question 14:

  You adjust a default configuration to the following /etc/my.cnf on a Linux installation:

  [mysqld]

  Loq-bin

  Binrylog_format=ROW

  You do not notice the spelling error in binrylog_format and restart your production server.

  How does the MySQL server behave with incorrectly spelled options?

  A. Mysqld uses internal configuration versioning and reverts to the previous configuration.
  B. When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.
  C. The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.
  D. Mysqld prints to the error log about an unknown variable, and then exits.
  D. Mysqld prints to the error log about an unknown variable, and then exits.

• Question 15:

  Assume that you want to know which Mysql Server options were set to custom values. Which two methods would you use to find out?

  A. Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.
  B. Check the command-line options provided for the Mysql Server and compare them with default values.
  C. Check the output of SHOW GLOBAL VARIABLES and compare it with default values.
  D. Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.
  C. Check the output of SHOW GLOBAL VARIABLES and compare it with default values.

• Question 16:

  Which two statements are true regarding partitioning in Mysql?

  A. Tables with BLOB and TEXT columns cannot be partitioned.
  B. Partitioning allows easier management of smaller data sets for certain queries.
  C. Partitioning allows different columns to be stored in separate files.
  D. The partitioning expression is an integer or function that returns an integer value or NULL value.
  E. Partitioning is only available for those storage engines that implements it natively.
  C. Partitioning allows different columns to be stored in separate files.
  D. The partitioning expression is an integer or function that returns an integer value or NULL value.

• Question 17:

  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.
  A. The General Query Log records more data than the Binary 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.

• Question 18:

  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.
  A. The slave was created with mysqldump u root p skip-lock-table--all-databases > /data/data.sql
  E. The applications have the SUPER privilege, which allows them to update rows.

• Question 19:

  Which hardware storage option, when set up with redundant disks, offers the least stability, availability, and reliability for Mysql data?

  A. RAID 5
  B. iSCSI
  C. SAN (Storage Area Network)
  D. NFS (Networked File System)
  C. SAN (Storage Area Network)

• Question 20:

  Mysqldump was used to create a single schema backup; Shell> mysqldump u root p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?

  A. Mysql> USE sakila; LOAD DATA INFILE `sakila2013.sql';
  B. Shell> mysql u root p sakila sakila2013.sql
  C. Shell> mysql import u root p sakila sakila2013.sql
  D. Shell> mysql u root -p e `use sakila; source sakila2013.sql'
  E. Shell> mysql u root p silent < sakila2013.sql
  B. Shell> mysql u root p sakila sakila2013.sql