Oracle 1Z0-888 Online Practice Questions and Exam Preparation

Oracle 1Z0-888 Online Questions & Answers

• Question 121:

  A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

  A. Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.
  B. Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.
  C. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.
  D. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.
  C. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

• Question 122:

  Consider the ANALYZE TABLE command.

  In which two situations should this command be used?

  A. when you want to check a tables structure to see if it may have been damaged and needs repair
  B. when you need to find out why a query is taking a long time to execute
  C. when you want to update index distribution statistics
  D. after large amounts of table data have changed
  C. when you want to update index distribution statistics
  D. after large amounts of table data have changed

• Question 123:

  Is it true that binary backups always take less space than text backups?

  A. Yes, because binary backups only contain data, and not statements required to insert data into the tables.
  B. No, because text backups can have optimizations, which make them smaller, such as updating many rows at once.
  C. No, because if InnoDB tables contain many empty pages, they could take more space than the INSERT statements.
  D. Yes, because even if InnoDB tables contain many empty pages, text backups have empty INSERT statements for them.
  C. No, because if InnoDB tables contain many empty pages, they could take more space than the INSERT statements.

• Question 124:

  Consider these global status variables: Which two conclusions can be made from the output? (Choose two.)

  

  A. There are 140 Performance Schema threads at the time of the output.
  B. There are 510 connections to MySQL at the time of the output.
  C. The thread cache has been configured with thread_cache_size set to at least 6.
  D. There are more connections being idle than executing queries.
  E. All max_connections were in use at 2018-03-22 14:54:06
  B. There are 510 connections to MySQL at the time of the output.
  D. There are more connections being idle than executing queries.

• Question 125:

  Which command-line utility creates encrypted files that can be used by client programs and contain obfuscated usernames and passwords?

  A. mysqld_safe
  B. mysql_config_editor
  C. mysqladmin
  D. mysqlpasswd
  B. mysql_config_editor

  ---

  Explanation Explanation/Reference:The obfuscation used by mysql_config_editor prevents passwords. Reference: https://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html

• Question 126:

  A general purpose MySQL instance is configured with the following options:

  --slow-query-log --long-query-time=.0001 --log-queries-not-using-indexes --log-slow-admin-queries --general-log --log-bin --binlog-format=STATEMENT --innodb-flush-log-at-trx-commit=1

  Which three statements are true for most workloads? (Choose three.)

  A. The Slow Query Log records more data than the General Query Log.
  B. The General Query Log records more data than the Slow Query Log.
  C. The Slow Query Log records more data than the Binary Log.
  D. The Binary Log records more data than the General Query Log.
  E. The Binary Log records more data than the Slow Query Log.
  F. The General Query Log records more data than the Binary Log.
  B. The General Query Log records more data than the Slow Query Log.
  C. The Slow Query Log records more data than the Binary Log.
  F. The General Query Log records more data than the Binary Log.

• Question 127:

  Consider: What does the range value in the type column mean?

  

  A. You can use an index and return rows that fall within a range of values.
  B. The table will be scanned over a certain range of values.
  C. This type of index uses the range hash.
  D. There is a range of indexes that can be used.
  C. This type of index uses the range hash.

• Question 128:

  The account [email protected] has been created with privileges, as shown in the output:

  

  The account [email protected] exists.

  The account [email protected] does not exist.

  Which three statements will succeed when executed by [email protected]? (Choose three.)

  A. GRANT SELECT ON audit.* TO [email protected];
  B. CREATE USER [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';
  C. GRANT SELECT ON world.* TO [email protected];
  D. GRANT INSERT ON audit.* TO [email protected];
  E. GRANT DELETE ON world.* TO [email protected];
  F. GRANT SELECT ON world.* TO [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';
  G. GRANT SELECT ON world.* TO [email protected];
  B. CREATE USER [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';
  D. GRANT INSERT ON audit.* TO [email protected];
  E. GRANT DELETE ON world.* TO [email protected];

• Question 129:

  A master-slave replication setup has the slave showing this error:

  

  On the master server, the binary logs show:

  

  What could explain this error? (Choose two.)

  A. binlog_cache_size=1024 is too small and transactions are lost.
  B. binlog_format=STATEMENT and a non-deterministic query was executed.
  C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
  D. The sync_relay_log=1000 setting on the slave is too small.
  E. sync_binlog=0 and the master server crashed.
  A. binlog_cache_size=1024 is too small and transactions are lost.
  C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

• Question 130:

  Which statement best describes the purpose of the InnoDB buffer pool?

  A. It is amount of buffers available during a transaction.
  B. It caches only the indexes for InnoDB tables.
  C. It caches data and indexes for InnoDB tables.
  D. It holds changes made during a transaction before they are written to the log.
  E. It is a pool of memory for SQL query sort operations from within the InnoDB engine.
  C. It caches data and indexes for InnoDB tables.

  ---

  Explanation Explanation/Reference:https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html