Oracle 1Z0-888 Online Practice Questions and Exam Preparation

Oracle 1Z0-888 Online Questions & Answers

• Question 81:

  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-log-file
  B. master-binlog
  C. include-master-info
  D. master-data
  D. master-data

• Question 82:

  You have installed the validate_password plug-in and set the validate_password_policy variable.

  Which validation is affected by the validate_password_policy setting?

  A. whether a new password is rejected if it contains a word found in a dictionary file.
  B. whether a new password is rejected if it contains the current user's username.
  C. the amount of delay after an incorrect password is entered
  D. the length of time before a newly created password expires
  A. whether a new password is rejected if it contains a word found in a dictionary file.

  ---

  https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html

• Question 83:

  One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.

  The colleague instant messages you this command:

  mysql> SET SESSION max_connections = 200;

  Why does the command fail?

  A. max_connections requires the GLOBAL scope.
  B. Its current user does not have the SUPER privilege.
  C. max_connections is not a dynamic variable. You need to change the config file and restart the database.
  D. Users can control only the max_user_connections variable.
  A. max_connections requires the GLOBAL scope.

  ---

  Explanation Explanation/Reference:

• Question 84:

  You created a backup of the world database with this command: shell> mysqldump --opt world > dump.sql

  Which two will import the data from dump.sql? (Choose two.)

  A. shell> mysqladmin recover test dump.sql
  B. shell> mysql test < dump.sql
  C. shell> mysqlimport test dump.sql
  D. mysql> USE test; mysql> LOAD DATA INFILE `dump.sql';
  E. mysql>USE test; mysql>SOURCE dump.sql;
  C. shell> mysqlimport test dump.sql
  D. mysql> USE test; mysql> LOAD DATA INFILE `dump.sql';

• Question 85:

  Which three tasks are handled by the optimizer? (Choose three.)

  A. Decide which indexes to use.
  B. Rewrite the WHERE clause.
  C. Parse the query.
  D. Change the order in which the tables are joined.
  E. Validate the query.
  F. Execute the query.
  G. Verify that the user is allowed to execute the query.
  B. Rewrite the WHERE clause.
  C. Parse the query.
  F. Execute the query.

• Question 86:

  The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.

  Which two are true about the login path feature? (Choose two.)

  A. mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.
  B. A .mylogin.cnf file can store at most one login path.
  C. It provides a FIPS-compliant keyring for storing MySQL login details.
  D. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
  E. It is an alternative to storing the MySQL login details in a my.cnf file.
  F. It provides means to help avoid accidentally exposing the MySQL login details.
  E. It is an alternative to storing the MySQL login details in a my.cnf file.
  F. It provides means to help avoid accidentally exposing the MySQL login details.

  ---

  https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html

• Question 87:

  Which two general properties relate to the mysqlimport client program? (Choose two.)

  A. It bypasses the server and writes directly to the data files.
  B. It can load files both on the client host and the server host.
  C. It can load files only on the server host.
  D. It provides a command-line interface to the LOAD DATA INFILE.
  E. It can be used to easily import full binary backups.
  B. It can load files both on the client host and the server host.
  D. It provides a command-line interface to the LOAD DATA INFILE.

  ---

  Explanation Explanation/Reference:By default, files are read by the server on the server host. With this option, mysqlimport reads input files locally on the client host. Successful use of LOCAL load operations within mysqlimport also requires that the server permits local loading. The mysqlimport client provides a command-line interface to the LOAD DATA INFILE. https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html https://docs.oracle.com/cd/E17952_01/mysql-5.1-en/mysqlimport.html

• Question 88:

  What three are correct statements about MySQL backups? (Choose three.)

  A. They are used to set up the initial binary log files.
  B. They are used to prevent data corruption.
  C. They are used to prevent data theft.
  D. They are used to set up a replication slave.
  E. They are used to recover data.
  F. They are used to set up a test system.
  A. They are used to set up the initial binary log files.
  D. They are used to set up a replication slave.
  E. They are used to recover data.

  ---

  https://dev.mysql.com/doc/mysql-backup-excerpt/5.6/en/point-in-time-recovery.html https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql https://hetmanrecovery.com/recovery_news/restoring-deleted-mysql-database-files.htm

• Question 89:

  You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

  

  What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

  A. to allow the remaining events to be processed on the slave while not receiving new events from the master
  B. to allow a backup to be created under reduced load
  C. to allow for point-in-time recovery on the slave
  D. to prevent schema changes from propagating to the slave before they are validated
  E. to prevent any transaction experiencing a deadlock
  B. to allow a backup to be created under reduced load
  C. to allow for point-in-time recovery on the slave

• Question 90:

  The MySQL instance is a default RPM installation on a Linux server. Where are the errors written?

  A. in the /var/lib/mysql/hostname.log file
  B. no logging enabled by default
  C. in the /var/log/mysqld.err file
  D. in the syslog daemon on the server
  C. in the /var/log/mysqld.err file

  ---

  Explanation Explanation/Reference:are set to the file/var/log/mysql/error.log Reference: https://support.plesk.com/hc/en-us/articles/115004039393-Unable-to-start-mysql-var-log-mysql-error-log-Permission-denied