Oracle Oracle Database 1Z0-888 Questions & Answers

• Question 141:

  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.

  Correct Answer: B

• Question 142:

  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.

  Correct Answer: EF

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

• Question 143:

  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.

  Correct Answer: C

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

• Question 144:

  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

  Correct Answer: DE

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

• Question 145:

  You have just executed a manual backup by using this command:

  mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backup

  The operation completed without error.

  What is the state of this backup and operation required before it is ready to be restored?

  A. Backup State = Compressed Backup Operation = copy-back

  B. Backup State = Raw Backup Operation = apply-log

  C. Backup State = Prepared Backup Operation = validate

  D. Backup State = Prepared Backup Operation = apply-log

  E. Backup State = Raw Backup Operation = backupdir-to-image

  Correct Answer: E

• Question 146:

  Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

  A. mysqldumpslow

  B. mysqldump

  C. mysqlaccess

  D. mysqlshow

  E. mysqlslow

  Correct Answer: A

• Question 147:

  Consider: Which statement best describes the meaning of the value for the key_len column?

  

  A. It shows how many bytes will be used from each index row.

  B. It shows the number of characters indexed in the key.

  C. It shows the total size of the index row.

  D. It shows how many columns in the index are examined.

  Correct Answer: A

• Question 148:

  Examine the mydata table and SELECT statements:

  

  You issue:

  mysql> begin;

  mysql> update mydata set a=0 where b=3;

  How many rows are now protected by locks with the default InnoDB configuration?

  A. one

  B. one row and a next-key lock for supremum

  C. one row and a gap-lock

  D. five

  Correct Answer: D

• Question 149:

  A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

  A. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER `/C=.....' AND REQUIRE SUBJECT `/C=.....'

  B. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

  C. using GRANT ... REQUIRE SSL for a secure connection

  D. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

  Correct Answer: A

• Question 150:

  

  What does the possible_keys column in this output denote?

  A. if it is possible for you to include any indexes in your query

  B. whether there are any indexes on the tables that you are querying

  C. if there are any indexes that may be used to solve this query

  D. whether you are using any indexes in your query

  Correct Answer: A