Oracle Oracle Certifications 1Z0-888 Questions & Answers

• Question 111:

  The /myfolder/my.cnf file has option set:

  [mysqld]

  skip-log-bin

  /myfolder2/my.cnf has this option set:

  [mysqld]

  log-bin = /valid/path/to/mysqlbinlog

  All mentioned paths are accessible to the account that you are currently using. Assume that any other

  options mentioned in either file are valid and legal option definitions.

  You start an instance by using this command line:

  mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf

  What is the outcome?

  A. MySQL starts and Binary Logging is enabled.

  B. MySQL fails to start due to the conflicting options in the configuration files.

  C. MySQL fails to start due to conflicting options on the command line.

  D. MySQL starts but Binary Logging is disabled.

  Correct Answer: C

• Question 112:

  You back up by using mysqldump.

  Which configuration is required on the MySQL Server to allow point-in-time recovery?

  A. binlog_format=STATEMENT

  B. log-bin

  C. apply-log

  D. bonlog_format=ROW

  E. gtid_enable

  Correct Answer: B

  Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/point-in-time-recovery.html

• Question 113:

  After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is: What are the two most likely reasons for the slowness given this output? (Choose two.)

  

  A. Date should be a TIMESTAMP field for better performance.

  B. The User field is too long for most names.

  C. The engine type is not appropriate to the application use.

  D. Using default values for DATETIME causes table scans.

  E. No indexes are defined.

  Correct Answer: CE

• Question 114:

  A crucial database, `db_prod', just disappeared from your production MySQL instance.

  In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you

  identified this command from a customer facing application:

  SELECT id FROM users WHERE login='payback!';DROP DATABASE db_prod;'

  Which three methods could have been used to prevent this SQL injection attack from happening? (Choose

  three.)

  A. writing your client code to properly escape all user input

  B. giving limited privileges to accounts used by application servers to interact with their backing databases

  C. using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions

  D. using a hashing or encryption method to secure all user passwords in your MySQL tables

  E. removing any remaining anonymous accounts from your MySQL instance

  F. validating all user input before sending it to the database server

  G. changing all passwords for the MySQL account `root'@'%' immediately after losing an employee who knew the current password

  Correct Answer: DEG

• Question 115:

  Which three statements correctly describe MySQL InnoDB Cluster? (Choose three.)

  A. The cluster can be operated in multimaster mode with conflict detection for DML statements.

  B. All MySQL client programs and connectors can be used for executing queries.

  C. It provides fully synchronous replication between the nodes.

  D. There is support for automatic failover when one node fails.

  E. The data is automatically shared between the nodes.

  F. Each query will be executed in parallel across the nodes.

  Correct Answer: BDF

• Question 116:

  Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.

  Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

  A. Implement a failover strategy to another geographic location.

  B. Create a master-master pair for each service.

  C. Have a second data centre in a different region or country.

  D. Keep software updated to the latest version.

  E. Use RAID 10 storage for data.

  F. Use on-site network-attached storage to separate service from data.

  Correct Answer: AC

• Question 117:

  Consider these global status variables: Which two conclusions can be made from the output? (Choose two.)

  

  A. There are 140 Performance Schema threads at the time of the output.

  B. There are 510 connections to MySQL at the time of the output.

  C. The thread cache has been configured with thread_cache_size set to at least 6.

  D. There are more connections being idle than executing queries.

  E. All max_connections were in use at 2018-03-22 14:54:06

  Correct Answer: BD

• Question 118:

  You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.

  Total dataset size is 200G with an average schema size of 2G.

  The data is transient and is not backed up and can be repopulated easily.

  Performance and responsiveness of the DB is paramount.

  The query pattern for the DB instance is split 90/10 read/write.

  DB host is dedicated server with 256G RAM and 64 cores.

  One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.

  Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)

  A. table_open_cache = 64

  B. innodb_buffer_pool_instances=64 innodb_buffer_pool_size=200G

  C. log_bin=mysql –bin Innodb_flush_log_at_trx_commit=1

  D. sync_binlog=10

  E. innodb_flush_method=O_DIRECT

  F. max_heap_table_size = 2G tmp_table_size=2G

  G. query_cache_size = 2G query_cache_enabled=1

  H. innodb_flush_log_at_trx_commit=0

  Correct Answer: ABEG

• Question 119:

  You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedir value) for your operating system.

  Which step should you perform before defining your own databases and database tables?

  A. Execute a command with a minimal form of: mysql --initialize

  B. Register mysqld as a service that will start automatically on this host machine.

  C. Create a configuration file containing default-storage-engine=InnoDB.

  D. Set an exception in the host machine's firewall to allow external users to talk to mysqld.

  E. Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.

  Correct Answer: C

• Question 120:

  Consider that local disk files are accessible via MySQL with commands such as: mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

  A. executing REVOKE LOAD FROM *.*

  B. setting the --local-service=0 option when starting mysqld

  C. executing REVOKE FILE FROM *_*

  D. executing REVOKE FILE ON *_* FROM ` `@'%'

  E. setting the --local-infile=0 option when starting mysqld

  F. setting the --open-files-limit=0 option when starting mysqld

  Correct Answer: F