Oracle Oracle Certifications 1Z0-888 Questions & Answers

• Question 61:

  You are investigating the performance of the server and see this information:

  events_waits_summary_global_by_event_name in the Performance Schema shows that the wait/synch/

  mutex/sql/LOCK_table_cache event is dominating other wait events.

  The Table_open_cache_overflows status variable is 0.

  Which action should be taken to remove the performance bottleneck described here?

  A. Increase the value of table_open_cache_instances.

  B. Decrease the value of table_definition_cache.

  C. Decrease the value of table_open_cache.

  D. Increase the value of table_definition_cache.

  E. Increase the value of table_open_cache.

  F. Decrease the value of table_open_cache instances.

  Correct Answer: A

• Question 62:

  Where does MySQL Linux RPM install the mysqld binary?

  A. /usr/libexec/

  B. /usr/local/mysql/bin/

  C. /usr/sbin/

  D. /usr/bin/

  E. /opt/mysql/server/bin/

  Correct Answer: C

  Reference: https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html

• Question 63:

  Which two methods will provide the total number of partitions on a table? (Choose two.)

  A. Query the INFORMATION_SCHEMA.PARTITIONS table

  B. Use the command: SHOW TABLE STATUS

  C. Query the performance_schema.objects_summary_global_by_type table

  D. Query the INFORMATION_SCHEMA.TABLES table for the partition_count

  E. Use the command: SHOW CREATE TABLE

  Correct Answer: AB

  Reference: https://dev.mysql.com/doc/refman/5.7/en/partitions-table.html https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html

• Question 64:

  SQL injection is a common security threat.

  Which two methods would help protect against this risk?

  A. using stored procedures to validate values that are input

  B. using SQL variables to secure input values

  C. using prepared statements to handle unsecured values

  D. installing the SQL Protection plugin to catch such attempts

  E. starting the server with the ?injection-protection command-line option.

  Correct Answer: AB

  Reference: https://security.berkeley.edu/education-awareness/best-practices-how-tos/system-applicationsecurity/how-protect-against-sql

• Question 65:

  A MySQL instance has this configuration values set:

  

  A transaction involving a single InnoDB INSERT statement commits. Which list of locations is in the sequence of disk writes for this transaction?

  A. binary log, redo log, doublewrite buffer, and tablespace

  B. redo log, binary log, doublewrite buffer, and tablespace

  C. doublewrite buffer, redo log, tablespace, and binary log

  D. redo log, doublewrite buffer, tablespace, and binary log

  Correct Answer: A

• Question 66:

  You want to immediately stop access to a database server for remote user `mike'@'client.example.com'. This user is currently not connected to the server.

  Which two actions can you take to stop any access from the user?

  A. Use ALTER USER `mike'@'client.example.com' PASSWORD EXPIRE;

  B. Use REVOKE ALL PRIVILEGES FROM `mike'@'client.example.com';

  C. Execute the mysql_secure_installation command.

  D. Use DROP USER `mike'@'client.example.com';

  E. Use GRANT USAGE ON *.* TO `mike'@'client.example.com' MAX_USER_CONNECTIONS=0;

  F. Use ALTER USER `mike'@'client.example.com' ACCOUNT LOCK;

  Correct Answer: DE

• Question 67:

  Which two are considered good security practices when using passwords? (Choose two.)

  A. Use one-way encryption for storage of passwords.

  B. Store passwords external to the database.

  C. Choose short passwords to save on storage space.

  D. Use simple keyboard actions that give mixed letters.

  E. Do not use dictionary-based words.

  Correct Answer: AE

  Reference: https://stackoverflow.com/questions/14798275/best-way-to-store-passwords-in-mysqldatabase

• Question 68:

  You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

  

  What would you run to fix the issue?

  A. the mysql_upgrade script

  B. the mysql client with the --ignore-password-hashing option

  C. the mysql_secure_installation script to update server security settings

  D. the mysql client with the --enable-cleartext-plugin option

  E. the install plugin command for the mysql_cleartext_password plugin

  Correct Answer: C

  Reference: http://planet.mysql.com/entry/?id=34077

• Question 69:

  What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

  A. using SSL when transporting data over remote networks

  B. using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

  C. setting --skip-networking when remote connections are not required

  D. setting specific GRANT privileges to limit remote authentication

  E. setting --mysql_secure_configuration to enable paranoid mode

  Correct Answer: ACD

• Question 70:

  Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

  A. It relies on the shared disk architecture being visible to both servers.

  B. It is provided by means of IP-level disk replication.

  C. It implements High Availability by using the .NET Connector's load balancing capabilities.

  D. It is a shared-nothing architecture.

  Correct Answer: A