Monday, 22 January 2024 15:24

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

Written by
Rate this item
(0 votes)

 

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 664 times Last modified onThursday, 11 July 2024 08:57
Elias Katsaniotis

      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.