Oracle 1Z0-888 Online Practice Questions and Exam Preparation

Oracle 1Z0-888 Online Questions & Answers

• Question 1:

  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
  C. the mysql_secure_installation script to update server security settings

  ---

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

• Question 2:

  Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

  A. It caches index blocks for MyISAM tables only.
  B. It caches index blocks for all storage engine tables.
  C. It is a global buffer.
  D. It is set on a per-connection basis.
  E. It caches index blocks for InnoDB tables only.
  A. It caches index blocks for MyISAM tables only.
  D. It is set on a per-connection basis.

  ---

  https://stackoverflow.com/questions/3663515/mysql-what-is-the-key-buffer

• Question 3:

  You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the

  configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.

  The requirements for the backup are:

  It must be possible to rebuild the instance using the backup.

  It must be verified.

  It must allow for a catastrophic hardware failure.

  Which four steps must be included in the backup strategy? (Choose four.)

  A. Include the keyring data and/or configuration in the backup.
  B. Restore the backup to a clean MySQL instance.
  C. Copy the backup to a remote host.
  D. Include the MySQL socket file in the backup.
  E. Include the ibtmp1 file in the backup.
  F. Include the relay logs in the backup.
  G. Include the operating system disk encryption key in the backup.
  H. Include the MySQL PID file in the backup.
  I. Include the binary logs in the backup.
  C. Copy the backup to a remote host.
  F. Include the relay logs in the backup.
  G. Include the operating system disk encryption key in the backup.
  H. Include the MySQL PID file in the backup.

• Question 4:

  You are installing MySQL Server 5.7 from a tarball package. You have already set up the correct PATH environment variable and configured your /etc/my.cnf file. Which command will correctly prepare a data directory?

  A. service mysqld prepare-init
  B. mysqld_safe --initialize ...
  C. mysql -u root -p < support-files/mysqldb.sql
  D. mysqld_safe --user=mysql
  E. mysqld --initialize ...
  E. mysqld --initialize ...

  ---

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

• Question 5:

  Which two options describe how MySQL Server allocates memory? (Choose two.)

  A. Each connection may have its own per-thread memory allocations.
  B. Thread memory is pre-allocated up to thread_cache_size for performance.
  C. Each thread allocates memory from a global pool.
  D. Global memory resources are allocated at server startup.
  A. Each connection may have its own per-thread memory allocations.
  D. Global memory resources are allocated at server startup.

• Question 6:

  What are three typical causes of MySQL becoming suddenly slow and unavailable? (Choose three.)

  A. A configuration change was made.
  B. The hardware includes a single point of failure.
  C. Monitoring has not enabled all Performance Schema instruments.
  D. The MySQL Query Cache is disabled.
  E. OPTIMIZE TABLE is not executed for the InnoDB tables.
  F. The application executes a new untested query.
  C. Monitoring has not enabled all Performance Schema instruments.
  D. The MySQL Query Cache is disabled.
  E. OPTIMIZE TABLE is not executed for the InnoDB tables.

• Question 7:

  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
  A. table_open_cache = 64
  B. innodb_buffer_pool_instances=64 innodb_buffer_pool_size=200G
  E. innodb_flush_method=O_DIRECT
  G. query_cache_size = 2G query_cache_enabled=1

• Question 8:

  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.
  A. using stored procedures to validate values that are input
  B. using SQL variables to secure input values

  ---

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

• Question 9:

  These details are shown when logged in to an account:

  

  Which set of statements would match the accounts shown?

  A. mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY `valid_password' WITH PROXY `employee'@'localhost';
  B. mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON `employee'@'localhost' TO `robert'@'localhost';
  C. mysql> CREATE USER `robert'@'localhost' IDENTIFIED BY `secret_password'; mysql>CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets';
  D. mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON `employee'@'localhost' TO ''@'';
  D. mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON `employee'@'localhost' TO ''@'';

• Question 10:

  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
  D. five