Oracle Oracle Certifications 1Z0-908 Questions & Answers

• Question 101:

  Your MySQL environment has asynchronous position based-replication with one master and one slave.

  The slave instance had a disk I/O problem, so it was stopped.

  You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.

  You restart MySQL Server.

  How can replication be restored?

  A. The slave relay logs should be deleted; then execute START SLAVE;

  B. The relay logs from the master should be used to replace the corrupted relay logs.

  C. The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

  D. The slave needs to be restored from backup.

  Correct Answer: B

• Question 102:

  Which three statements are true about MySQL replication? (Choose three.)

  A. Replication can use only TCP/IP connections.

  B. Any instance can have multiple slaves, but it can have only one master.

  C. Each instance in a replication topology must have a unique server ID.

  D. Binary logs contain only transactions originating from a single MySQL instance.

  E. Each slave must have its own MySQL user for replication.

  F. Binary logging must be enabled on the master in order to replicate to other instances.

  G. A replication user must have the SELECT privilege for all tables that need to be replicated.

  Correct Answer: CFG

• Question 103:

  A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation. Which three features are available with this installation method? (Choose three.)

  A. MySQL Replication monitoring

  B. network-related information and network characteristics

  C. MySQL Query Analysis data

  D. CPU utilization

  E. security-related advisor warnings

  F. operating system memory utilization

  G. disk usage and disk characteristics including disk advisors warnings

  Correct Answer: CEG

• Question 104:

  Examine this SQL statement:

  mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;

  Which two are true? (Choose two.)

  A. Mark can grant the privileges assigned to the r_read@localhost role to another user.

  B. ADMIN OPTION causes the role to be activated by default.

  C. Mark can grant the r_read@localhost role to another user.

  D. Mark can revoke the r_read@localhost role from another role.

  E. ADMIN OPTION allows Mark to drop the role.

  F. Mark must connect from localhost to activate the r_read@localhost role.

  Correct Answer: CD

  Explanation: https://dev.mysql.com/doc/refman/8.0/en/grant.html

• Question 105:

  On examination, your MySQL installation datadir has become recursively world read/write/executable. What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

  A. Users could overwrite configuration files.

  B. Data files could be deleted.

  C. SQL injections could be used to insert bad data into the database.

  D. MySQL binaries could be damaged, deleted, or altered.

  E. Extra startup time would be required for the MySQL server to reset the privileges.

  Correct Answer: BE

• Question 106:

  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

  Correct Answer: E

• Question 107:

  Examine these statements and output:

  

  Which statement is true?

  A. The user is logged in with --user=accounting as an option.

  B. The user is authenticated as the anonymous proxy user `'@'%'.

  C. The user is authorized as the accounting@localhost user.

  D. The user is authorized as the rsmith@localhost user.

  E. The user failed to define a username and the connecting username defaulted to `'@'%'.

  Correct Answer: D

• Question 108:

  Which two MySQL Server accounts are locked by default? (Choose two.)

  A. any user set as DEFINER for stored programs

  B. any internal system accounts

  C. any new ROLE accounts

  D. any user created without a password

  E. any user created with a username, but missing the host name

  Correct Answer: AB

• Question 109:

  Examine these entries from the general query log:

  

  All UPDATE statements reference existing rows.

  Which describes the outcome of the sequence of statements?

  A. Connection 24 experiences a lock wait timeout.

  B. Connection 25 experiences a lock wait timeout.

  C. A deadlock occurs immediately.

  D. All statements execute without error.

  E. A deadlock occurs after innodb_lock_wait_timeout seconds.

  Correct Answer: E

• Question 110:

  Which two statements are true about raw binary backups? (Choose two.)

  A. They are converted to a highly compressible binary format.

  B. The data format is identical to how MySQL stores the data on disk.

  C. They are required to obtain FIPS security compliance.

  D. The resulting files are easily human readable.

  E. They are faster than logical backups because the process is a simple file or file system copy.

  Correct Answer: BD