Oracle 1Z0-888 Online Practice Questions and Exam Preparation

Oracle 1Z0-888 Online Questions & Answers

• Question 131:

  You have been tasked with creating a QA MySQL instance on a DB host, which already has one large instance in /var/lib/mysql/ running as the mysql user. The MySQL configuration file for the existing instance includes:

  

  The default instance was installed using the OS package manager. The latest binaries for both client and server are already in ENV PATH.

  The new instance will run as a different user from the existing instance for security purposes.

  You create the new data directory successfully and move on to initialize the new DATADIR.

  You verify the output to confirm the operation's success:

  [mysqlQA@linux /var/lib/]$ mysqld --initialize --datadir=/var/lib/mysql_QA 2>and1 | tail -n3

  2018-05-03T12:16:10.928809Z 0 [ERROR] Could not open file '/var/log/mysqld.log' for error logging: Permission denied

  2018-05-03T12:16:10.928841Z 0 [ERROR] Aborting

  [mysqlQA@linux /var/lib/]$

  The initialization of the instance has failed.

  What would you do to enable the initialization to succeed?

  A. Pass --log-error=/var/lib/mysql_QA/mysqld.log.
  B. Use mysql_install_db.
  C. Use --no-defaults to ignore the existing config file in the default PATH.
  D. Change permissions on /var/log/mysqld.log to allow writes.
  B. Use mysql_install_db.

  ---

  Explanation Explanation/Reference:mysql_install_db handles initialization tasks that must be performed before the MySQL server, mysqld, is ready to use. Reference: https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html

• Question 132:

  The following grants were executed:

  GRANT CREATE ROUTING ON sales.* TO `webadmin'@'%';

  GRANT ALTER ON PROCEDURE sales.myproc TO `webadmin'@'%';

  A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore,

  issues the following statement:

  USE sales;

  DROP PROCEDURE IF EXISTS get_reports;

  What is the result of executing the statement?

  A. The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.
  B. The user will get an error because he or she did not put the database name in front of the stored procedure name.
  C. The stored procedure named get_reports will be dropped.
  D. The user will get an error because he or she does not have the permission to drop stored procedures.
  C. The stored procedure named get_reports will be dropped.

• Question 133:

  Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?

  A. mysqld -e 'shutdown'
  B. service mysqld stop
  C. mysqladmin shutdown
  D. mysql -e 'shutdown'
  A. mysqld -e 'shutdown'

• Question 134:

  An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.

  The SHOW SLAVE STATUS indicates these values: RELAY_LOG_FILE=hostname-relay-bin.00004 RELAY_LOG_POS=1383

  Which command set would make the slave current?

  A. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
  B. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = `hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
  C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
  D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = `hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
  C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

  ---

  Explanation Explanation/Reference:

• Question 135:

  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
  A. Query the INFORMATION_SCHEMA.PARTITIONS table
  B. Use the command: SHOW TABLE STATUS

  ---

  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 136:

  When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file? (Choose two.)

  A. it contains the binary log.
  B. it contains a general tablespace.
  C. it is the default location for all new tables that you create.
  D. it contains the system tablespace.
  E. it contains the redo log.
  F. it contains the undo log.
  C. it is the default location for all new tables that you create.
  D. it contains the system tablespace.

  ---

  https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html

• Question 137:

  You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.

  The default values of which two key variables do you change to ensure seamless operation of the database? (Choose two.)

  A. Key Buffer Size
  B. InnoDB Redo Log Size
  C. Binary Log Size
  D. Buffer Pool Size
  E. Sort Buffer size
  F. Query Cache Size
  A. Key Buffer Size
  E. Sort Buffer size

• Question 138:

  

  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
  A. if it is possible for you to include any indexes in your query

• Question 139:

  How does the InnoDB storage engine handle deadlocks when they are detected?

  A. Both the affected transactions will be rolled back.
  B. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
  C. One of the affected transactions will be rolled back, the other is allowed to proceed.
  D. The transaction isolation level determines which transaction is rolled back.
  E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
  C. One of the affected transactions will be rolled back, the other is allowed to proceed.

  ---

  https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html

• Question 140:

  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
  A. using SSL when transporting data over remote networks
  C. setting --skip-networking when remote connections are not required
  D. setting specific GRANT privileges to limit remote authentication