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
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
12 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...
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.
Any Idea on how do I start giving Oracle trainings (SQL, PLSQL) and if any institute has any requirements for Oracle trainer in Bangalore?
you personally contact to training institutes and let them know ..
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated 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
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...
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
