Oracle 1Z0-888 Online Practice Questions and Exam Preparation

Oracle 1Z0-888 Online Questions & Answers

• Question 111:

  Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server: Master:

  

  Slave:

  

  There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

  A. The log_bin variable is set to OFF on the slave.
  B. server_id is not unique.
  C. The max_connections variable on the slave needs to be increased.
  D. The shared_memory_base_name variable must match the master.
  E. The version of the slave is newer that the version of the master.
  A. The log_bin variable is set to OFF on the slave.

• Question 112:

  You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

  A. Run the create_system_tables.sql file
  B. Run the mysql_unpack.sql file
  C. Invoke mysqld with the --initialize option.
  D. Invoke mysql with the --initialize option.
  C. Invoke mysqld with the --initialize option.

  ---

  https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html

• Question 113:

  You are using the mysqldumpslow utility to view the contents of the slow query log.

  You notice the letter N and the character string `S' in a number of locations in the output.

  What does the N indicate?

  A. the number of times the statement was executed
  B. an abbreviation for NULL in a statement
  C. the name of the user issuing the statement
  D. an abstracted substitution for numbers indicated in WHERE clauses
  A. the number of times the statement was executed

  ---

  Explanation Explanation/Reference:https://dev.mysql.com/doc/refman/5.7/en/mysqldumpslow.html

• Question 114:

  Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

  A. Physical backups can be used to recover from data corruption.
  B. Logical backups are human-readable whereas physical backups are not.
  C. Logical backups are always larger than physical backups.
  D. Physical backups are usually slower than text backups.
  E. Physical backups are usually faster than text backups.
  A. Physical backups can be used to recover from data corruption.
  E. Physical backups are usually faster than text backups.

• Question 115:

  You are asked to examine user accounts and find:

  

  Which two statements will best secure this environment? (Choose two.)

  A. DROP USER `'@'localhost';
  B. ALTER USER `'@'localhost' PASSWORD = `secret_password';
  C. ALTER USER bob@'%' IDENTIFIED BY `secret_password';
  D. ALTER USER `root'@'localhost' ACCOUNT LOCK;
  E. ALTER USER bob PASSWORD = `secret_password';
  F. REVOKE ALL PRIVILEGES FROM `'@'localhost';
  C. ALTER USER bob@'%' IDENTIFIED BY `secret_password';
  E. ALTER USER bob PASSWORD = `secret_password';

• Question 116:

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

  

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

  

  The table mytable on the slave contains:

  

  You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. 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 GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";
  B. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";
  C. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
  D. SET GLOBAL enforce_gtid_consistency=ON
  E. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
  C. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

  ---

  https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html

• Question 117:

  Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.

  Which two methods would allow the mysql client to connect to the server and send clear text passwords? (Choose two.)

  A. mysql --protocol=PLAIN -uroot -p -h dbhost.example.com
  B. INSTALL PLUGIN mysql_cleartext_password SONAME `mysql_cleartext_password.so';
  C. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
  D. SET GLOBAL mysql_cleartext_passwords=1;
  E. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com
  D. SET GLOBAL mysql_cleartext_passwords=1;
  E. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com

  ---

  https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html

• Question 118:

  Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication? (Choose three.)

  A. Set isolation level to be SERIALIZABLE.
  B. Use the binary log row format.
  C. Set isolation level to be READ COMMITTED.
  D. Configure IPv6 network for hosts.
  E. Guarantee a secondary index on every table.
  F. Guarantee a primary key on every table.
  G. Set multiple slave parallel worker threads.
  A. Set isolation level to be SERIALIZABLE.
  B. Use the binary log row format.
  F. Guarantee a primary key on every table.

• Question 119:

  Consider a replication setup where a snapshot of the replication status shows:

  

  Which statement is true?

  A. The melbourne channel is resolving a GTID conflict.
  B. The sydney channel is keeping up with the received events.
  C. The melbourne channel is keeping up with the received events.
  D. The last event received from the sydney channel was at 2018-05-08 14:55:01.
  E. The replication slave uses multisource replication with eight sources.
  E. The replication slave uses multisource replication with eight sources.

• Question 120:

  Given these table definitions and the explain plan:

  

  Which ALTER TABLE statement will improve the performance of the query?

  A. ALTER TABLE `CountryLanguage` ADD INDEX `idx_Lang` (`Language`);
  B. ALTER TABLE `Country` ADD INDEX `idx_Code` (`Code`);
  C. ALTER TABLE `CountryLanguage` ADD INDEX `idx_OffLang` (`IsOfficial`, `Language`);
  D. ALTER TABLE `Country` ADD INDEX `idx_NameCont` (`Name`, `CountryCode`);
  B. ALTER TABLE `Country` ADD INDEX `idx_Code` (`Code`);