Oracle Oracle Database 1Z0-888 Questions & Answers

• Question 41:

  Consider the ANALYZE TABLE command.

  In which two situations should this command be used?

  A. when you want to check a tables structure to see if it may have been damaged and needs repair

  B. when you need to find out why a query is taking a long time to execute

  C. when you want to update index distribution statistics

  D. after large amounts of table data have changed

  Correct Answer: CD

• Question 42:

  You have forgotten the root user account password. You decide to reset the password and execute:

  

  Which additional argument makes this operation safer?

  A. ?old-passwords, to start MySQL to use the old password format while running without the grant tables.

  B. ?reset-grant-tables, to start the server with only the mysql database accessible.

  C. ?read-only, to set all data to read-only except for super users

  D. ?skip-networking, to prohibit access from remote locations

  Correct Answer: D

• Question 43:

  While attempting to set up a new replication slave on host `192.168.0.25' with the user `replication', you encounter this error:

  

  What should you do to resolve this error?

  A. Add the user [email protected] with the correct password to the master.

  B. Edit the DNS table on the master to include the domain name for the IP address of 192.168.0.25.

  C. Edit the my.ini file on the slave so that the master-host variable is equal to the IP address of the master, and restart the slave.

  D. Add the user [email protected] with the correct password to the slave.

  Correct Answer: A

• Question 44:

  You need to dump the data from the master server and import it into a new slave server.

  Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?

  A. include-log-file

  B. master-binlog

  C. include-master-info

  D. master-data

  Correct Answer: D

• Question 45:

  A MySQL instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.

  Which two will optimize the security of this setup? (Choose two.)

  A. enabling and using SSL for connections to the MySQL database

  B. running the server with –-skip-networking specified

  C. disabling connections from named pipes or socket files (depending on the operating system of the server)

  D. starting the server with –-bind-address=0.0.0.0 specified

  E. limiting logins to originate from the application server or the server's subnet

  F. installing MySQL on the application server, and running the database and application on the same server

  Correct Answer: AF

• Question 46:

  Which two capabilities are granted with the SUPER privilege?

  A. allowing change of the server runtime configuration

  B. allowing a client to shut down the server

  C. allowing client accounts to take over the account of another user

  D. allowing a client to kill other client connections

  Correct Answer: BD

• Question 47:

  The Performance Schema includes these tables related to status variables: Which two facts are true about these tables? (Choose two.)

  

  A. The variable values in global_status are the sum of those in status_by_thread grouped by the variable name.

  B. All these tables have the same number of rows.

  C. The global_status table is equivalent to the SHOW GLOBAL STATUS statement.

  D. The variable values in status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.

  E. The session_status table is equivalent to status_by_thread for the current thread.

  Correct Answer: DE

• Question 48:

  Consider:

  

  Which statement best describes the meaning of the values in the ref columns?

  A. world.City.CountryCode is used as the primary key for the Country table.

  B. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

  C. world.City.CountryCode is used to sort the rows in the City table.

  D. No indexed columns are used to select rows from the Country table. The world.City.CountryCode column is used to select rows in the City table.

  Correct Answer: B

• Question 49:

  Consider:

  

  What does the range value in the type column mean?

  A. You can use an index and return rows that fall within a range of values.

  B. The table will be scanned over a certain range of values.

  C. This type of index uses the range hash.

  D. There is a range of indexes that can be used.

  Correct Answer: C

• Question 50:

  Multiversion Concurrency Control (MVCC) enables what type of backup?

  A. Hot

  B. Binary

  C. Logical

  D. Incremental

  Correct Answer: A

  Reference: https://dev.mysql.com/doc/refman/5.7/en/glossary.html