Oracle Exam 1Z0-908 Topic 10 Question 79 Discussion

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

Question #: 79
Topic #: 10

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

APost-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

BPhysical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.

CLogical upgrades are much faster because they do not require restarting the mysqld process.

DPost-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.

EPhysical upgrades are much faster because they do not require restarting the mysqld process.

FPhysical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

Show Suggested Answer

Suggested Answer: A, D, E

by William at May 21, 2024, 07:25 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-908 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tyisha

3 days ago

Hmm, I think B and C are the way to go. Physical upgrades are for bare metal, and logical upgrades are quicker since they don't need to restart the server. Wait, is that a trick question? I'm starting to second-guess myself now...

upvoted 0 times

...

Berry

4 days ago

Wow, this is a tough one. I'm going to guess A and C. Logical upgrades should be faster, and the storage requirements might be smaller. But I'm really not confident about this.

upvoted 0 times

...

Bettina

8 days ago

I'm not sure about D, but F seems correct - physical upgrades leave data in place, while logical upgrades require restoring from backups. This is really tricky, I need to study more!

upvoted 0 times

...

Aleta

11 days ago

I think B and C are the correct answers. Physical upgrades are for bare metal, while logical upgrades are for virtual/containers. And logical upgrades are faster since they don't require restarting the mysqld process.

upvoted 0 times

...