Oracle Oracle Certifications 1Z0-908 Questions & Answers

• Question 81:

  Examine this SQL statement:

  

  Which set of privileges will allow Tom to execute this SQL statement?

  A. GRANT ALL PRIVILEGES ON `world'.`city' TO `tom'@'%'; GRANT SELECT (`code') ON `world'.`country' TO `tom'@'%';

  B. GRANT UPDATE ON `world'.* TO `tom'@'%'; GRANT ALL PRIVILEGES ON `world'.`country' TO `tom'@'%';

  C. GRANT UPDATE ON `world'.`city' TO `tom'@'%'; GRANT SELECT ON `world'.* TO `tom'@'%';

  D. GRANT UPDATE ON `world'.`city' TO `tom'@'%'; GRANT SELECT ON `world'.`country' TO `tom'@'%';

  Correct Answer: D

• Question 82:

  Which two statements are true about MySQL Enterprise Backup? (Choose two.)

  A. It supports backing up only table structures.

  B. It can perform hot or warm backups.

  C. It creates logical backups.

  D. It supports the creation of incremental backups.

  E. It supports backup of a remote MySQL system.

  F. It supports restoring to a remote MySQL system.

  Correct Answer: BD

• Question 83:

  Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)

  A. SHOW ENGINE INNODB STATUS;

  B. INFORMATION_SCHEMA.INNODB_METRICS

  C. SHOW TABLE STATUS;

  D. INFORMATION_SCHEMA.STATISTICS

  E. INFORMATION_SCHEMA.INNODB_TABLESTATS

  F. SHOW STATUS;

  Correct Answer: DE

• Question 84:

  Examine the modified output:

  

  Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)

  A. The master is most probably too busy to transmit data and the slave needs to wait for more data.

  B. One or more large tables do not have primary keys.

  C. This value shows only I/O latency and is not indicative of the size of the transaction queue.

  D. The master is producing a large volume of events in parallel but the slave is processing them serially.

  E. The parallel slave threads are experiencing lock contention.

  Correct Answer: CD

• Question 85:

  You want to check the values of the sort_buffer_size session variables of all existing connections. Which performance_schema table can you query?

  A. user_variables_by_thread

  B. global_variables

  C. variables_by_thread

  D. session_variables

  Correct Answer: D

  Reference: https://dev.mysql.com/worklog/task/?id=6629

• Question 86:

  Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?

  A. The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.

  B. It is possible to filter a Query Analyzer view graph by database and by table.

  C. The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager's built-in Agent installation.

  D. It is possible to export statements included in a graph selection in CSV format.

  Correct Answer: D

• Question 87:

  Examine this command, which executes successfully:

  $ mysqlrouter --bootstrap user@hostname:port --directory=directory_path

  Which activity is performed?

  A. MySQL Router is configured based on the information in files in directory_path.

  B. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.

  C. MySQL Router is restarted.

  D. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

  Correct Answer: B

  Reference: https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html

• Question 88:

  Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.

  Company policy is to create a backup every day.

  The main tables being updated are prefixed with transactions-.

  These tables are archived into tables that are prefixed with archives- each month. mysqlbackup --optimistic-busy-tables="^finance\.transactions-.*" backup

  Which optimization process best describes what happens with the redo logs?

  A. The redo logs are backed up first, then the transaction and archive tables.

  B. The redo logs are backed up only if there are changes showing for the transactions tables.

  C. The redo logs are not backed up at all.

  D. The archive tables are backed up first, then the transaction tables and redo logs.

  E. The transaction tables are backed up first, then the archive tables and redo logs.

  Correct Answer: B

• Question 89:

  You have a MySQL system with 500 GB of data that needs frequent backups.

  You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirement:

  The MySQL system being backed up can never be unavailable or locked to the client applications.

  The recovery from the backup must work on any system. Only 1 hour of data can be lost on recovery of the backup.

  Which option fulfills all backup requirements?

  A. Take a physical backup of the MySQL system.

  B. Use the Clone Plugin to copy the data to another MySQL system.

  C. Take a logical backup of the MySQL system.

  D. Take your backup from a slave of the MySQL system.

  Correct Answer: C

• Question 90:

  Four nodes are configured to use circular replication. Examine these configuration parameters for each node:

  

  Which statement is true?

  A. Each slave thread is responsible for updating a specific database.

  B. Cross-database constraints can cause database inconsistency.

  C. Increasing slave_parallel_workers will improve high availability.

  D. Setting slave_preserve_commit_order to on will improve data consistency.

  E. Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.

  F. Setting transaction_allow_batching to on will improve data consistency.

  Correct Answer: D