Oracle 1Z0-883 Online Practice Questions and Exam Preparation

Oracle 1Z0-883 Online Questions & Answers

• Question 1:

  MySQL is installed on a Linux server and has the following configuration:

  [mysqld]

  User=mysql

  Datadir=/data/mysql

  As the `root' user, change the datadir location by executing:

  Shell> cp R /var/lib/mysql/data/mysql/

  Shell> chown R mysql /data/mysql/

  What is the purpose of changing ownership of datadir to the `mysql' user?

  A. MySQL cannot be run as the root user.
  B. MySQL requires correct file ownership while remaining secure.
  C. MySQL needs to be run as the root user, but file cannot be owned by it.
  D. The mysqld process requires all permissions within datadir to be the same.
  B. MySQL requires correct file ownership while remaining secure.

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

  You have been notified that the `apps' . `reports' table has been accidentally truncated.

  You have single file mysqldump backup available taken prior to the truncate. The backup contains all the tables from the instance, and the `apps' . `reports' table must be restored without affecting the other remaining databases and tables.

  Which restore option is suitable in this scenario?

  A. Restore the backup to another databases instance and obtain a copy of the reports table individually.
  B. Extract the `apps' . `reports' table from the backup using the SOURCE command.
  C. Execute LOAD DATA INFILE `backup.sql' SCHEMA='apps' TABLE= `reports'
  D. Execute mysqldump on the backup,sql file and apply filter arguments to obtain only the `apps' . `reportys' table.
  B. Extract the `apps' . `reports' table from the backup using the SOURCE command.

• Question 4:

  Which two statements are true about setting the per-thread buffers higher than required?

  A. More memory per thread is beneficial in all scenarios.
  B. It causes increased overhead due to initial memory allocation.
  C. It can affect system stability during peak load times, due to swapping.
  D. It requires increasing the thread_cache_size variable.
  C. It can affect system stability during peak load times, due to swapping.
  D. It requires increasing the thread_cache_size variable.

• Question 5:

  Which two are correct steps in taking a binary backup of MyISAM tables?

  A. Always stop the server prior to the backup.
  B. Stop the server or lock the tables prior to the backup.
  C. Stop the server or lock the databases prior to the backup.
  D. Make a copy of the .frm, .myd, and the .myi files.
  E. Make a copy of the binary log and tablespace files.
  B. Stop the server or lock the tables prior to the backup.
  D. Make a copy of the .frm, .myd, and the .myi files.

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

  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.

• Question 8:

  Which statement is true about the log-output variable?

  A. It is a static variable and can be set only at MySQL server startup.
  B. It enables and starts the General Query Log.
  C. It sets the target location for the binary logs generated by the MySQL sever.
  D. It specifies output destinations for the slow and General Query logs.
  D. It specifies output destinations for the slow and General Query logs.

• Question 9:

  Which statement is true about FLUSH LOGS command?

  A. It requires the RELOAD, FILE, and DROP privileges.
  B. It closes and reopens all log files.
  C. It closes and sends binary log files to slave servers.
  D. It flushes dirty pages in the buffer pool to the REDO logs.
  B. It closes and reopens all log files.

• Question 10:

  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