Oracle 1Z0-908 Online Practice Questions and Exam Preparation

Oracle 1Z0-908 Online Questions & Answers

• Question 71:

  Examine this query and its output: Which two statements are true? (Choose two.)

  

  A. The root user had the largest number of modified rows for a SELECT statement.
  B. User bob had the largest total time waiting for locks.
  C. The root user had the largest single wait time.
  D. The app user had the highest total number of rows read from storage engines.
  E. User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.
  D. The app user had the highest total number of rows read from storage engines.
  E. User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

• Question 72:

  You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.

  Using Query Analyzer, where do you begin to look for problem queries?

  A. Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.
  B. Look for queries with low total latency times in the Latency section in the times series graph.
  C. Look for queries with big prolonged spikes in row activity/access graph in the times series graph.
  D. Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.
  C. Look for queries with big prolonged spikes in row activity/access graph in the times series graph.

• Question 73:

  Examine this query and output: Which two statements are true? (Choose two.)

  

  A. The country table is accessed as the first table, and then joined to the city table.
  B. It takes more than 8 milliseconds to sort the rows.
  C. The optimizer estimates that 51 rows in the country table have Continent = `Asia'.
  D. 35 rows from the city table are included in the result.
  E. The query returns exactly 125 rows.
  C. The optimizer estimates that 51 rows in the country table have Continent = `Asia'.
  D. 35 rows from the city table are included in the result.

• Question 74:

  Which two statements are true about MySQL server multi-source replication? (Choose two.)

  A. It is not compatible with auto-positioning.
  B. It needs to be re-instanced after a crash to maintain consistency.
  C. It uses only time-based replication conflict resolution.
  D. It relies on relay_log_recovery for resilient operations.
  E. It does not attempt to detect or resolve replication conflicts.
  F. It must use GTID replication.
  C. It uses only time-based replication conflict resolution.
  F. It must use GTID replication.

• Question 75:

  You wish to store the username and password for a client connection to MySQL server in a file on a local file system.

  Which is the best way to encrypt the file?

  A. Use the AES_ENCRYPT() MySQL function on the option file.
  B. Use mysql_secure_installation to encrypt stored login credentials.
  C. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
  D. Use mysql_config_editor to create an encrypted file.
  D. Use mysql_config_editor to create an encrypted file.

  ---

  Explanation/Reference:

  Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/password-security- user.html

• Question 76:

  You recently upgraded your MySQL installation to MySQL 8.0.

  Examine this client error:

  

  Which option will allow this client to connect to MySQL Server?

  A. [mysqld] default_authentication_plugin=sha256_password
  B. ALTER USER user IDENTIFIED WITH mysql_native_password BY 'password';
  C. [mysqld] default_authentication_plugin=caching_sha2_password
  D. ALTER USER user IDENTIFIED WITH caching_sha2_password BY 'password';
  E. ALTER USER user IDENTIFIED WITH sha256_password BY 'password';
  F. [mysqld] default_authentication_plugin=mysql_native_password
  E. ALTER USER user IDENTIFIED WITH sha256_password BY 'password';

  ---

  Explanation/Reference:

• Question 77:

  Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

  A. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
  B. It is possible to retrieve a normalized statement, but never the exact statement that was executed.
  C. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
  D. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
  E. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.
  C. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
  D. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

• Question 78:

  Which three are requirements for a secure MySQL Server environment? (Choose three.)

  A. Restrict the number of OS users that have access at the OS level.
  B. Ensure appropriate file system privileges for OS users and groups.
  C. Minimize the number of non-MySQL Server-related processes running on the server host.
  D. Encrypt the file system to avoid needing exact file-system permissions.
  E. Keep the entire software stack on one OS host.
  F. Run MySQL server as the root user to prevent incorrect sudo settings.
  B. Ensure appropriate file system privileges for OS users and groups.
  D. Encrypt the file system to avoid needing exact file-system permissions.
  E. Keep the entire software stack on one OS host.

• Question 79:

  You reconfigure and start a slave that was not replicating for several days.

  The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

  

  Which statement is true?

  A. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa- aaaaaaaaaaaa transactions than the master.
  B. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
  C. Replication will fail because the master has already purged transactions with cccccccc- cccc-cccc- cccc-cccccccccccc GTIDs.
  D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc- cccccccccccc GTIDs.
  E. Replication will work.
  A. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa- aaaaaaaaaaaa transactions than the master.

  ---

  Explanation/Reference:

  Reference: https://bugs.mysql.com/bug.php?id=86643

• Question 80:

  Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

  A. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.
  B. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.
  C. Logical upgrades are much faster because they do not require restarting the mysqld process.
  D. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.
  E. Physical upgrades are much faster because they do not require restarting the mysqld process.
  F. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.
  C. Logical upgrades are much faster because they do not require restarting the mysqld process.
  F. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.