Oracle 1Z0-888 Online Practice Questions and Exam Preparation

Oracle 1Z0-888 Online Questions & Answers

• Question 101:

  This output is from a SHOW SLAVE STATUS:

  

  What would cause the SQL_Delay variable to have a value of 360?

  A. The master has performed a large transaction, which will take 360 seconds to complete on the slave.
  B. The network latency between the master and the slave is 360 milliseconds.
  C. The slave will need an estimated 360 seconds to update the remaining contents from the relay log.
  D. The slave was configured for delayed replication with a delay of six minutes.
  D. The slave was configured for delayed replication with a delay of six minutes.

  ---

  https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/show-slave-status.html

• Question 102:

  You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST. Which three statements are true? (Choose three.)

  A. The performance impact is less than SHOW FULL PROCESSLIST.
  B. The PROCESS privilege is required.
  C. The events_statements_current consumer must be enabled.
  D. A connection must be instrumented to be included in the list of processes.
  E. The sys.session view provides the process list with additional information.
  F. The threads table contains all the required columns.
  B. The PROCESS privilege is required.
  C. The events_statements_current consumer must be enabled.
  F. The threads table contains all the required columns.

  ---

  Explanation Explanation/Reference:The PROCESS privilege also enables use of SHOW ENGINE. The threads table columns with names having a prefix of PROCESSLIST_ provide information similar to that available from the INFORMATION_SCHEMA.PROCESSLIST table or the SHOW PROCESSLIST statement. https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html https://www.percona.com/blog/2015/10/01/capture-database-traffic-using-performance-schema/ https://dev.mysql.com/doc/mysql-perfschema-excerpt/5.7/en/threads-table.html

• Question 103:

  There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.

  The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults.

  A restore of the second instance is attempted from the mysqlbackup archive using this command:

  mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back

  Upon starting the second MySQL instance, you notice that the data does not match the expected backup. Which command-line option is required to successfully update the second instance?

  A. --restore=2
  B. --copy-back-from-log
  C. --backup-instance=/var/lib/mysql/instance2
  D. --instance=/var/lib/mysql/instance2
  E. --defaults-file=/etc/mysql/instance2.cnf
  E. --defaults-file=/etc/mysql/instance2.cnf

• Question 104:

  Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space. What will happen when this occurs?

  A. The server will crash.
  B. The server suspends that INSERT operation until space becomes available.
  C. An error message will be returned to the client .Server Error: ER_IO
  D. The server suspends operations for all storage engines until space becomes available.
  B. The server suspends that INSERT operation until space becomes available.

• Question 105:

  You have the following in your my.cnf configuration file:

  [mysqld] default_authentication_plugin=sha256_password

  You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords. Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)

  A. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password `imbatman';
  B. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY `iambatman';
  C. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY `imbatman';
  D. CREATE USER WITH sha256_password `sha256_user'@'192.0.2.10' IDENTIFIED AS `webdesign' USING `imbatman';
  E. CREATE USER `webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY `imbatman';
  F. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS `imbatman';
  B. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY `iambatman';
  F. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS `imbatman';

  ---

  https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html

• Question 106:

  At which stage during query processing does MySQL create a query's execution plan?

  A. Optimizing
  B. Parsing
  C. Executing
  D. Authorizing
  A. Optimizing

  ---

  Explanation Explanation/Reference:https://dev.mysql.com/doc/refman/8.0/en/execution-plan-information.html

• Question 107:

  You have created a backup of the `sales' database with the command:

  

  Which two procedures can be used to restore the `orders' table from the backup?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  B. Option B
  C. Option C

  ---

  Explanation Explanation/Reference:

• Question 108:

  The Performance Schema includes these tables related to status variables:

  

  Which two facts are true about these tables? (Choose two.)

  A. The variable values in global_status are the sum of those in status_by_thread grouped by the variable name.
  B. All these tables have the same number of rows.
  C. The global_status table is equivalent to the SHOW GLOBAL STATUS statement.
  D. The variable values in status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.
  E. The session_status table is equivalent to status_by_thread for the current thread.
  D. The variable values in status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.
  E. The session_status table is equivalent to status_by_thread for the current thread.

• Question 109:

  Which two methods accurately monitor the size of your total database size over time? (Choose two.)

  A. monitoring the Innodb_rows_inserted status variable
  B. monitoring the innodb_redo_log_size variable
  C. monitoring the information_schema.TABLES table
  D. monitoring datadir size in the operating system
  E. monitoring cumulative Innodb_page_size increase
  F. monitoring the performance_schema_hosts_size variable
  C. monitoring the information_schema.TABLES table
  F. monitoring the performance_schema_hosts_size variable

• Question 110:

  In which order does MySQL process an incoming INSERT statement?

  A. It checks whether the user is authorized to perform the query, writes to the binary log, and then optimizes it.
  B. It checks whether the user is authorized to perform the query, optimizes it, and then writes to the binary log.
  C. It writes the query to the binary log, optimizes it, and then checks whether the user is authorized to perform the query.
  D. It optimizes the query, checks whether the user is authorized to perform it, and then writes to the binary log.
  C. It writes the query to the binary log, optimizes it, and then checks whether the user is authorized to perform the query.