Oracle Oracle Certifications 1Z0-908 Questions & Answers

• Question 11:

  Which two are true about binary logs used in asynchronous replication? (Choose two.)

  A. They are pushed from the master to the slave.

  B. They contain events that describe database changes on the master.

  C. They contain events that describe all queries run on the master.

  D. They contain events that describe only administrative commands run on the master.

  E. They are pulled from the master to the slave.

  Correct Answer: AB

  Reference: https://www.oracle.com/technetwork/community/developer-day/mysql- replication-presentation- 485890.pdf (14)

• Question 12:

  Which three requirements must be enabled for group replication? (Choose three.)

  A. slave updates logging

  B. semi-sync replication plugin

  C. primary key or primary key equivalent on every table

  D. binary log checksum

  E. binary log ROW format

  F. binary log MIXED format

  G. replication filters

  Correct Answer: BCF

• Question 13:

  Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

  A. recording the order in which queries are issued

  B. audit of all queries

  C. point-in-time recovery

  D. replication

  E. logging the duration and locks for all queries

  Correct Answer: AC

• Question 14:

  User account baduser@hostname on your MySQL instance has been compromised.

  Which two commands stop any new connections using the compromised account? (Choose two.)

  A. ALTER USER baduser@hostname PASSWORD DISABLED;

  B. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

  C. ALTER USER baduser@hostname ACCOUNT LOCK;

  D. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

  E. ALTER USER baduser@hostname DEFAULT ROLE NONE;

  Correct Answer: CD

• Question 15:

  Which two are features of MySQL Enterprise Firewall? (Choose two.)

  A. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

  B. blocking of potential threats by configuring pre-approved whitelists

  C. modifying SQL statement dynamically with substitutions

  D. automatic locking of user accounts who break your firewall

  E. provides stateless firewall access to TCP/3306

  Correct Answer: AB

• Question 16:

  Which two are use cases of MySQL asynchronous replication? (Choose two.)

  A. You can scale writes by creating a replicated mesh.

  B. It guarantees near real-time replication between a master and a slave.

  C. You can scale reads by adding multiple slaves.

  D. MySQL Enterprise Backup will automatically back up from an available slave.

  E. It allows backup to be done on the slave without impacting the master.

  Correct Answer: CE

• Question 17:

  Examine this parameter setting:

  audit_log=FORCE_LOG_PERMANENT

  What effect does this have on auditing?

  A. It will force the load of the audit plugin even in case of errors at server start.

  B. It causes the audit log to be created if it does not exist.

  C. It prevents the audit plugin from being removed from the running server.

  D. It prevents the audit log from being removed or rotated.

  Correct Answer: C

• Question 18:

  MySQL is installed on a Linux server with this configuration: Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

  

  A. Set validate-user-plugins=caching_sha2_password in the configuration file.

  B. Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.

  C. Add default_authentication_plugin=mysql_native_password in the configuration file.

  D. Add default_authentication_plugin=sha256_password in the configuration file.

  Correct Answer: D

• Question 19:

  You are backing up raw InnoDB files by using mysqlbackup.

  Which two groups of files will be backed up during a full backup? (Choose two.)

  A. ibbackup files

  B. *.CSM files

  C. *.sdi files

  D. *.ibd files

  E. ib_logfile* files

  Correct Answer: DE

  Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/innodb-backup.html

• Question 20:

  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.

  Correct Answer: C