Oracle 1Z0-888 Online Practice Questions and Exam Preparation

Oracle 1Z0-888 Online Questions & Answers

• Question 71:

  An admin attempts to enforce stronger security by using these commands:

  

  The admin then leaves the system running with the specified changes. What are two remaining security concerns? (Choose two.)

  A. validate_password_policy cannot be set without restarting the MySQL instance.
  B. The name of the dictionary file is too obvious.
  C. The dictionary file word list is too short.
  D. validate_password_dictionary_file cannot be set without restarting the MySQL instance.
  E. The validate_password plug-in has not been loaded.
  F. The dictionary file is an insecure location.
  B. The name of the dictionary file is too obvious.
  F. The dictionary file is an insecure location.

• Question 72:

  You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.

  Which 2 things should you investigate?

  A. Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.
  B. Check the difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.
  C. Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.
  D. Check the difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"
  E. Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.
  B. Check the difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.
  E. Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

• Question 73:

  Recently, users on mostly-write MySQL database have been complaining of slowdowns or stalls in their applications. Which option is most likely to have a positive effect on the server's health and performance?

  A. Reduce the size of redo logs to improve storage efficiency.
  B. Increase the size of redo logs.
  C. Lower innodb_max_dirty_pages_pct to flush more often.
  D. Move redo logs to /dev/shm to improve their speed.
  C. Lower innodb_max_dirty_pages_pct to flush more often.

  ---

  Explanation Explanation/Reference:https://books.google.com.pk/books?id=QWOZBAAAQBAJandpg=PT179andlpg=PT179anddq=Lower+innodb_max_dirty_pages_pct+to+flush+more+often.andsource=blandots=FwmB-8zI9Mandsig=ACfU3U0zLNCENrOcvMfEALc4pPxiOj81Qandhl=enandsa=Xandved=2ahUKEwiGk4iv0KnpAhWjzYUKHS54CK0Q6AEwAHoECAoQAQ#v=onepageandq=mysqlandf=false

• Question 74:

  What two statements are true regarding FLUSH TABLES FOR EXPORT? (Choose two.)

  A. It can be used to export TEMPORARY tables.
  B. Table only exports when the table has its own tablespace.
  C. The InnoDB Storage engine must be used for the table being exported.
  D. It is the safest way to extract tables from the shared tablespace.
  E. Partitioned tables are not supported.
  A. It can be used to export TEMPORARY tables.
  B. Table only exports when the table has its own tablespace.

• Question 75:

  Consider the index information for the dept_emp table in the employee's schema:

  

  Which two conclusions can be made based on the output of the query? (Choose two.)

  A. There are three indexes on the table.
  B. There is a redundant index on the dept_no column.
  C. The secondary indexes are optimized for unique key look-ups.
  D. The values on the emp_no column must be unique.
  E. The selectivity of the dept_no column is the best of the indexed columns.
  F. There is a redundant index on the emp_no column.
  C. The secondary indexes are optimized for unique key look-ups.
  F. There is a redundant index on the emp_no column.

• Question 76:

  Which two statements can be used to adjust the sort_buffer_size variable on a running MySQL server? (Choose two.)

  A. mysql> SET GLOBAL sort_buffer_size=256000;
  B. mysql> SET SESSION sort_buffer_size=256000;
  C. mysql> CONF T; do global sort_buffer_size=256000;
  D. mysql> system sort_buffer_size=256000;
  E. mysql> SET VARIABLE sort_buffer_size=256000;
  A. mysql> SET GLOBAL sort_buffer_size=256000;
  B. mysql> SET SESSION sort_buffer_size=256000;

  ---

  Explanation Explanation/Reference:SET GLOBAL sort_buffer_size = 1000000, SESSION sort_buffer_size = 1000000; Reference:https://dev.mysql.com/doc/refman/5.7/en/set-variable.html

• Question 77:

  You have issued this statement:

  GRANT PROXY ON 'a' FOR 'b';

  When user account 'b' issues a query, the query returns an access denied error.

  What could have caused that error?

  A. When connecting, user account 'b' is not entering the correct password for user account 'a'.
  B. You have not set the proxy_user variable in the configuration file.
  C. User account 'b' has not been granted permission to access the data being queried.
  D. User account 'a' has not been granted permission to access the data being queried.
  A. When connecting, user account 'b' is not entering the correct password for user account 'a'.

  ---

  When a client connects to the server, the server determines the proper account based on the user name passed by the client program and the host from which the client connects. https://dev.mysql.com/doc/refman/8.0/en/proxy-users.html

• Question 78:

  To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.

  Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

  A. Install the X509 plug-in on the server.
  B. Set the X509 option in the [client] section of the MySQL server's configuration file.
  C. Restart the server with the --require-x509 option.
  D. Distribute client digital certificates to the client computers being used to log in by the user accounts.
  E. Provide users access to the server's private key.
  B. Set the X509 option in the [client] section of the MySQL server's configuration file.

• Question 79:

  A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

  

  The MySQL Server is restarted without error.

  What effect will the new configuration have on existing account?

  A. They are not affected by this configuration change.
  B. They all connect via the secure sha256_password algorithm without any configuration change.
  C. They will have their passwords updated on start-up to sha256_password format.
  D. They will have to change their password the next time they login to the server.
  A. They are not affected by this configuration change.

• Question 80:

  Why should you be selective when granting the PROCESS privilege to an account?

  A. It allows a client to process scripts.
  B. It allows the use of stored routines.
  C. It allows a client to see another user's queries with the SHOW PROCESSLIST command.
  D. It allows a client to control running processes on a server.
  D. It allows a client to control running processes on a server.

  ---

  https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html