How oracle database is different from other databases like SQL Server, MySQL etc?
Asked by Nirod Baran Last Modified
Follow 0 
Answer 
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
1
Comments
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
0
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
0
Comments
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
0
Comments
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.
0
Comments
Krishna Mohan Bugata
Computer
More secure than the MySQL, SQL Server
0
Comments
View 4 more Answers
Related Questions
Difference between a cluster and a grid? 
in cluster you will have homogeneous env and in grid you will have non homogeneous env
6 I am looking for Part time Oracle Trainer work. I found few profiles as well near to my location but unable to get the contact details. Please help me out..!!!
hi, please call me for further discussion
If someone is good at oracle sql what should be the next step for him?
If you are at oracle sql it means your fundamental knowledge about DBMS are very much clear. Now you should start learning PL/SQL, as because it will help to code DBMS in great detail and in effective...
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...
Hi, I'm an automation test engineer and a certified s/w test engineer (CSTE - QAI). I work with databases at a beginner level but I'm planning to master working with databases. I'm interested in taking a certification exam as-well. I am not interested in making a career switch but want to add it to my skill set. Considering my background, what training/certification should I go for? Please also suggest some beginner level certifications that would be helpful for me to add to my skill set.
Should be learn Biggener of Database then Advance Courses in DB.
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
Common mistake even experienced programmers make in Plsql.
Hope, you are aware of Procedures in Plsql. Let us discuss one simple thing which we should always remember while writing the datatype of a parameter for a procedure or a function. Eg: Create or replace...
Basic understanding of DBMS and RDBMS and Database and its Architecture
What is Data:- The data is stored representation of objects and events which has the meaning .It can be structured or unstructured. What is Information:-It is the data in the processed form which will...
How To Prepare For OCA Exam?
Oracle Certified Associate certification programs are very costly to take the exam. They really deserve it because you get a high value of this certification in the job market. This Article is meant for...
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
Introduction to Performance tuning
What is Performance in general terms? Throughput per Input. For Eg: we keep saying, this bike has so and so much of mileage and all that. That is one of the parameters in measuring the performance of...
Find Oracle Database near you
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
