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

Pamella

1 months ago

Logical upgrades are so fast, they make your head spin. Physical upgrades are like watching paint dry, but with more error messages.

upvoted 0 times

...

Lavonda

2 months ago

I heard the MySQL devs are going to release a 'Logical Upgrade Lite' version - it's just a mysqldump and a sed script. Way more efficient!

upvoted 0 times

Avery

5 days ago

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

upvoted 0 times

...

Dean

6 days ago

C) Logical upgrades are much faster because they do not require restarting the mysqld process.

upvoted 0 times

...

Ernestine

27 days ago

A) Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

upvoted 0 times

...

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

Johnson

15 days ago

User 3: I think you're right. Logical upgrades are faster and don't need a server restart. Let's stick with B and C.

upvoted 0 times

...

Loreta

20 days ago

User 2: Yeah, physical upgrades are for bare metal deployments. Logical upgrades don't require restarting the server.

upvoted 0 times

...

Jose

26 days ago

User 1: I agree, B and C seem like the right choices. Logical upgrades are definitely faster.

upvoted 0 times

...

Berry

2 months 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

2 months 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

Serina

15 days ago

I agree, it is tricky. I need to review the differences between logical and physical upgrades of MySQL databases.

upvoted 0 times

...

Nadine

21 days ago

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

upvoted 0 times

...

Karina

28 days ago

C) Logical upgrades are much faster because they do not require restarting the mysqld process.

upvoted 0 times

...

Gail

1 months ago

A) Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

upvoted 0 times

...

Aleta

2 months 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

...

Melodie

2 months ago

Hmm, interesting. Can you explain why you think that?

upvoted 0 times

...

Cheryl

3 months ago

I disagree, I believe B and F are the correct options.

upvoted 0 times

...

Melodie

3 months ago

I think A and C are true about the differences between logical and physical upgrades.

upvoted 0 times

...

Oracle Exam 1Z0-908 Topic 10 Question 79 Discussion

Contribute your Thoughts:

Pamella

Lavonda

Avery

Dean

Ernestine

Tyisha

Johnson

Loreta

Jose

Berry

Bettina

Serina

Nadine

Karina

Gail

Aleta

Melodie

Cheryl

Melodie