Oracle 1Z0-883 Online Practice Questions and Exam Preparation

Oracle 1Z0-883 Online Questions & Answers

• Question 41:

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

• Question 42:

  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.
  C. Text backups are human-readable while binary backups are not.
  D. Binary backups are not portable across different operating systems.

• Question 43:

  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;
  A. SHOW FULL PROCESSLIST WHEER Time > 180;

• Question 44:

  Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?

  A. MySQL Replication
  B. Distributed Replication Block Device
  C. Windows Server Failover Clustering
  D. MySQL Cluster
  A. MySQL Replication

• Question 45:

  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.
  D. The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.

• Question 46:

  A simple master-to-slave replication is currently being used. The following information is extracted from the. SHOW SLAVE STATUS output:

  Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database:

  'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') ' Skip_Counter: 0

  Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1

  You execute a "SHOW CREATE TABLE mytable" on the slave:

  CREATE TABLE `mytable' (

  `ID' int(11) NOT NULL DEFAULT `0',

  `name' char(10) DEFAULT NULL,

  PRIMARY KEY (`ID')

  )

  The table mytable on the slave contains the following:

  

  You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

  A. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
  B. SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT=" AUTOMATIC';
  C. SET GLOBAL enforce_gtid_consistency=ON
  D. SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9";
  E. SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";
  A. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

• Question 47:

  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.
  B. Execute the command FLUSH LOGS.

• Question 48:

  When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

  A. BIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved.
  B. Multiple BIT columns pack tightly into a row, using less space.
  C. BIT (8) takes less space than eight TINYINT fields.
  D. The BIT columns can be manipulated with the bitwise operators and, |, ~, ^, . The other integer types cannot.
  B. Multiple BIT columns pack tightly into a row, using less space.

• Question 49:

  You want to shutdown a running Mysql Server cleanly.

  Which three commands that are valid on either Windows or Linux will achieve this?

  A. Shell> pkill u mysql mysqld_safe
  B. Shell> service mysql safe_exit
  C. Shell> /etc/init.d/mysql stop
  D. Shell> mysqladmin u root p shutdown
  E. Mysql> STOP PROCESS mysqld;
  F. Shell> net stop mysql
  G. Shell> nmc mysql shutdown
  C. Shell> /etc/init.d/mysql stop
  D. Shell> mysqladmin u root p shutdown
  E. Mysql> STOP PROCESS mysqld;

• Question 50:

  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
  A. Starting of the I/O thread
  B. Execution of the FLUSH LOGS statement