1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

Question Posted / himanshu


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba..

Answer / Brij Bhushan

Compared to Oracle, MySQL has some limitations in terms of scalability, performance for large databases, and features. MySQL doesn't support some advanced SQL features like hierarchical queries (common table expressions, recursive queries), and it has limited support for stored procedures compared to PL/SQL. It also lacks built-in support for replication and high availability solutions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Why do we use joins?

1 Answers  

How to return multiple records from procedure?

2 Answers  

What are different categories of sql commands?

1 Answers  

What is pragma exception and how, when, where us

5 Answers  

what is the difference between delete and truncate statement in sql? : Sql dba

1 Answers  

What is pragma in pl sql?

1 Answers  

What are the different types of sql commands?

1 Answers  

What is raw datatype in sql?

1 Answers  

What are the types of operators available in sql?

1 Answers  

what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,

What are two statement types in sql?

1 Answers  

Which function is used to return remainder in a division operator in sql?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories