Oracle Exam 1Z0-908 Topic 5 Question 69 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 69
Topic #: 5

[All 1Z0-908 Questions]

Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema()

Which two statements are true? (Choose two.)

AGroup Replication will be dissolved and all metadata purged.

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

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

DThe command drops the mysql_innodb_cluster_metadata schema and re-creates it.

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

FConnections driven by MySQL Router are not affected by the command.

Show Suggested Answer

Suggested Answer: A

by Eun at Dec 10, 2023, 05:50 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

3 days ago

Hmm, this seems tricky. I'll have to think carefully about the consequences of dropping the metadata schema.

upvoted 0 times

...

15 days ago

But if the metadata schema is dropped from all reachable members, wouldn't that mean Group Replication will be dissolved?

upvoted 0 times

...

17 days ago

I disagree, I believe it's A and D.

upvoted 0 times

...

21 days ago

I think the correct answers are C and E.

upvoted 0 times

...