Oracle 1Z0-883 Online Practice Questions and Exam Preparation

Oracle 1Z0-883 Online Questions & Answers

• Question 1:

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

  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
  A. Disconnecting idle localhost client sessions

• Question 3:

  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
  D. Binary logs
  E. The data backup
  F. Configuration files

• Question 4:

  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
  D. Master-data

• Question 5:

  You have a server that has very limited memory but has a very large table.

  You will use mysqldump to back up this table.

  Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

  A. -- quick
  B. -- skip-buffer
  C. -- single-transaction
  D. -- tab
  C. -- single-transaction

• Question 6:

  Which three tasks can be performed by using the performance Schema?

  A. Finding queries that are not using indexes
  B. Finding rows that are locked by InnoDB
  C. Finding client connection attributes
  D. Finding the part of a code in which a single query is spending time
  E. Finding the size of each table
  A. Finding queries that are not using indexes
  B. Finding rows that are locked by InnoDB
  C. Finding client connection attributes

• Question 7:

  Which three statements are true about memory buffer allocation by a MySQL Server?

  A. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.
  B. Thread buffers are allocated when a client connects, and are freed when the client disconnects.
  C. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.
  D. User buffers are allocated at server startup and freed when the user is dropped.
  E. All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.
  A. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.
  B. Thread buffers are allocated when a client connects, and are freed when the client disconnects.
  C. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.

• Question 8:

  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.
  C. It shows the number of characters indexed in the key.

• Question 9:

  An employee cannot access the company database. You check the connection variables: Mysql> SHOW GLOBAL VARIABLES LIKE `%connect%';

  

  8 rows in set (0.00 sec)

  A look at the user privileges shows:

  GRANT... TO `bob'@'%, example.com' WITH MAX_USER_CONNECTIONS 0; GRANT... TO `key'@'%, example.com' WITH MAX_USER_CONNECTIONS 1; GRANT... TO `joe'@'%, example.com' WITH MAX_USER_CONNECTIONS 50;

  What is a valid explanation for why one of the users is unable to connect to the database?

  A. Bob has max_user_connections set to zero, which blocks all his connections
  B. Joe has exceeded the max_user_connections global limit.
  C. All users are blocked because max_user_connections is accumulated over the host account information.
  D. Kay is already connected elsewhere and attempting to log in again.
  E. Connect_timeout is too small to allow a connection to occur.
  A. Bob has max_user_connections set to zero, which blocks all his connections

• Question 10:

  Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.

  An example of the start of one row of data:

  `GREEN01020495888331993-12-10/2...'

  What should you do to improve the overall performance?

  A. Convert the column to TEXT and add a fulltext index to the table.
  B. Create multiple prefix indexes of differing lengths.
  C. Convert their column to BINARY.
  D. Redesign the table so that the most commonly searched for string patterns are in their own columns.
  D. Redesign the table so that the most commonly searched for string patterns are in their own columns.