1Z0_908 questions • Exam prepare

Exam contains 143 questions

Page 23 of 24

Question 133 🔥

Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema()Which two statements are true? (Choose two.)

Which database solution meets these requirements?

A. Group Replication will be dissolved and all metadata purged.

B. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.

C. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

D. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.

E. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.

F. Connections driven by MySQL Router are not affected by the command.

Discussion of the question

Question 134 🔥

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

Which database solution meets these requirements?

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.

Discussion of the question

Question 135 🔥

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?

Which database solution meets these requirements?

A. [mysqld]default_authentication_plugin=sha256_password

B. ALTER USER user -IDENTIFIED WITH mysql_native_passwordBY 'password';

C. [mysqld]default_authentication_plugin=caching_sha2_password

D. ALTER USER user -IDENTIFIED WITH caching_sha2_passwordBY 'password';

E. ALTER USER user -IDENTIFIED WITH sha256_password -BY 'password';

F. [mysqld]default_authentication_plugin=mysql_native_password

Discussion of the question

Question 136 🔥

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host 192.0.2.1:3306. You wish to connect directly to the world database.Which four options need to be specified to complete this task with a single command? (Choose four.)

Which database solution meets these requirements?

Discussion of the question

Question 137 🔥

Examine this partial output for InnoDB Cluster status:Which statement explains the state of the instance deployed on host2?

Which database solution meets these requirements?

A. It can be recovered from a donor instance on host3 by cloning using the command cluster.rejoinInstance ('<user>@host3:3377')

B. It can rejoin the cluster by using the command cluster.addInstance('<user>@host3:3377')

C. It has been removed from the cluster by using the command STOP GROUP_REPLICATION;

D. It can rejoin the cluster by using the command dba.rebootClusterFromCompleteOutage()

E. It has been expelled from the cluster because of a transaction error.

Discussion of the question

Question 138 🔥

You are using an existing server with a new configuration. MySQL Server fails to start.Examine this snapshot of the error log:Which action would allow the server to start?

Which database solution meets these requirements?

A. Remove ib_logfile0 and ib_logfile1 files from the file system.

Highly voted

B. Execute mysqladmin flush-logs.

C. First run mysqld --initialize to refresh the Size of ib_logfile.

D. Create a new ib_logfile0 file of size 26214400.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_908

Exam contains 143 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us