4. What are the limitations of mysql in Comparison of Oracle? MySQL vs. Oracle.

What are the limitations of mysql in Comparison of Oracle? MySQL vs. Oracle.

Answer

  • Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
  • Large Database size is supported more in Oracle in contrast to MySql.

MySQL vs. Oracle.

  • Unlike oracle, mysql data types can store invalid dates and don’t support time zones.
  • Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
  • Large Database size is supported more in Oracle in contrast to MySql.
  • Replication in oracle is two way while one way in mysql.

All sql dba Questions
Ask your interview questions on sql-dba

Write Your comment or Questions if you want the answers on sql-dba from sql-dba Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---