How oracle database is different from other databases like SQL Server, MySQL etc?

Asked by Last Modified  

6 Answers

Follow 0
Answer

Please enter your answer

Tutor

1. Oracle and SQL Server are considered tools that favor users with large enterprise systems, while MySQL is considered a tool that appeals most often to individuals interested in managing databases associated with their websites. 2. Another difference of the MySQL platform in comparison to the other...
read more
1. Oracle and SQL Server are considered tools that favor users with large enterprise systems, while MySQL is considered a tool that appeals most often to individuals interested in managing databases associated with their websites. 2. Another difference of the MySQL platform in comparison to the other two is that it is open source. 3. Sql server introduces of OLTP an embedded feature that allows sophisticated database managemnet to enhance performance and also provide the SQl server data tools for business intelligence. 4. Oracle support for a client-server model was added a anticipation of a growing acceptance of network communication. 5. Oracle also includes Java Vertual Machine (JVM) architecture read less
Comments

Maths & Computer Tutor

Oracle database can run on all operating system like Windows, Linix,Solaris, HP-UX, OSX, z/OS, AIX . MySQL database can run on Windows, Linux,OS X,FreeBSD,Solaris. And SQL server can run only Windows
Comments

MySQL is a open source database in comparison to Oracle but also has much lesser features as compared to Oracle. In case someone wants to learn database without investment then he can choose MySQL which has no specific restrictions for Developers. In terms of Security also Oracle is much better. SQL...
read more
MySQL is a open source database in comparison to Oracle but also has much lesser features as compared to Oracle. In case someone wants to learn database without investment then he can choose MySQL which has no specific restrictions for Developers. In terms of Security also Oracle is much better. SQL Server and Oracle are very close to each other main difference being that Oracle is more preferred by Java whereas SQL Server is a more preferred option in .Net. read less
Comments

Oracle Database Trainer

Since their introduction in the 1980s, relational database management systems (RDBMS) have become the standard database type for a variety of industries. As their name implies, these systems are based on the relational model that organizes data into groups of tables referred to as relations. This post...
read more
Since their introduction in the 1980s, relational database management systems (RDBMS) have become the standard database type for a variety of industries. As their name implies, these systems are based on the relational model that organizes data into groups of tables referred to as relations. This post explores the history and features of three popular RDBMS: Oracle, MySQL, and SQL Server. The first “real” release of the Oracle RDBMS was Oracle 2. This system supported only basic SQL features, and it was written in an assembly language. The following year, and for the next 10 years or so, Oracle Corporation released updates to its flagship database. Probably one of the reasons the Oracle RDBMS has managed to remain at the top of mighty RDBMS is linked to its product updates that are closely tied to changes in the market. Database buzzwords such as “scalable”, “programmable”, “distributed”, and “portable” are also tied to Oracle release. read less
Comments

Freelance Trainer

Every Database has its own architecture and different syntax to retrieve and process data. However from development point of view or learning point of view if you can learn any one Database, one can easily switch on other databases without any much difficulty and efforts.
Comments

Computer

More secure than the MySQL, SQL Server
Comments

View 4 more Answers

Related Questions

Hello, I have completed my Oracle DBA certification on 9I 5 years back but somehow I stuck working with support industry with ITIL related stuff. Now I want to switch my profile. Is it possible if I brush up my skills and try for a technical profile? I want to get into Oracle related profile.
Yeah you can. But Oracle DBA certification 5 years back will not help you. DBA is completely dependent on hand on exercise. You can try Oracle plsql or Oracle Business Intelligence(OBIEE) or you can try...
Abhishek
How to enhance the performance of the oracle database?
Oracle database performance tunning is very complex task, you should know in depth knowledge of Oracle database architecture like internal structure of shared pool, Database buffer cache, redo log buffer...
Nirod
1 0
7

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Interview questions on Packages in Oracle
Let me list few standard questions asked in the interviews on plsql package. 1. Why packages are used? What are it's advantages? 2. Name few bulin-in Oracle packages. 3. Can we have a function or procedure...

Exception Handling topics
Here, I am only going to list the topics which one should consider to master Exception Handling. 1. Types of errors in Pl/sql- Compile time and Run time 2. How to read and understand the Compile time...

SQL Subqueries - Used in various ways
If you master the concepts of subqueries, you would gain a lot of flexibility in writing complex SQL queries. Let's not get into Correlated subqueries, let us see the different versions of nested subquery...

Try too choose suitable industry which will give more happyness
In any industry, if its suitable and if its more interest then every body can create wonders. So let choose which is best suitable to you mean while dont think u want to become no 1. As per your capabilities,...
K

K C Reddy

0 0
0

Starter on exception handling
Just run these two blocks individually, observe the output and comment on what do you understand from it. SET SERVEROUTPUT ONDeclareCursor C is select * from emp;i c%rowtype;BeginFetch C into i;End; SET...

Looking for Oracle Database ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you