Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 0d 14h 35m 32s Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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.)

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

Benedict
2 months ago
Maybe I should just choose the most dramatic-sounding options to be on the safe side. That'll show them I'm a real InnoDB Cluster expert!
upvoted 0 times
...
Tequila
2 months ago
I'm pretty sure the metadata schema is important for the cluster. Dropping it could be disastrous!
upvoted 0 times
Jani
1 days ago
User3: I think we should be careful before dropping the metadata schema, it could have serious consequences.
upvoted 0 times
...
Giuseppe
6 days ago
User2: C) The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
upvoted 0 times
...
Curtis
21 days ago
User1: A) Group Replication will be dissolved and all metadata purged.
upvoted 0 times
...
...
Bernardo
2 months ago
I bet this is a trick question. The command must have some hidden side effects.
upvoted 0 times
Lemuel
13 days ago
I) The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.
upvoted 0 times
...
Lemuel
1 months ago
C) The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
upvoted 0 times
...
Lemuel
1 months ago
B) Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
upvoted 0 times
...
...
Charlena
2 months ago
Wait, didn't we just create that metadata schema? Why would we want to drop it already?
upvoted 0 times
Leila
1 months ago
User3: The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
upvoted 0 times
...
Lashanda
2 months ago
User2: Group Replication will be dissolved and all metadata purged.
upvoted 0 times
...
Kattie
2 months ago
User1: Maybe we made a mistake and need to start over.
upvoted 0 times
...
...
Aileen
2 months ago
Hmm, this seems tricky. I'll have to think carefully about the consequences of dropping the metadata schema.
upvoted 0 times
...
Socorro
2 months ago
But if the metadata schema is dropped from all reachable members, wouldn't that mean Group Replication will be dissolved?
upvoted 0 times
...
Stephane
2 months ago
I disagree, I believe it's A and D.
upvoted 0 times
...
Socorro
3 months ago
I think the correct answers are C and E.
upvoted 0 times
...

Save Cancel
a