Monday, 22 January 2024 13:24

What are the advantages of MySQL as compared with Oracle DB?

Written by
Rate this item
(0 votes)

https://www.youtube.com/watch?v=JKsjiaoPlJY&t=1s

 

Q. What are the advantages of MySQL as compared with Oracle DB? Some of the main advantages of MySQL over Oracle DB are as follows:

I. Cost: MySQL is an Open Source and free RDBMS software. Oracle is usually a paid option for RDBMS.

II. Space: MySQL uses around 1 MB to run whereas Oracle may need as high as 128 MB to run the database server.

III. Flexibility: MySQL can be used to run a small website as well as very large scale systems. Oracle is generally used in medium to large scale systems.

IV. Management: In MySQL, database administration is much easier due to self-management features like- automatic space expansion, auto-restart and dynamic configuration changes. In Oracle dedicated DBA has to work on managing the Database.

V. Portable: MySQL is easily portable to different hardware and operating system. Migrating Oracle from one platform to another is a tougher task. Learn more MySQL interview questions,

join our popular MySQL Interview Questions Preparation Course with more than 50 questions for $10 only today!! https://www.udemy.com/mysql-interview...

Read 723 times Last modified on Thursday, 11 July 2024 06:57
Super User

      After Greek Army, I started with QBasic in QL, a computer brother of Spectrum, 2 Degrees, almost 2 Certificates, from GWBasic to Oracle Tech & IBM tech & Solaris Clusters, at almost 60s to CMS tech.

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.