Difference between MS Access and Oracle

Answer Posted / kani

1.Oracle is multi-user where MS-Access is not.

2.Oracle's features for distributed transactions,
materialized views and replication are not available with
MS Access. These features enable Oracle to efficiently
store data for multinational companies across the globe.
Also these features increase scalability of applications
based on Oracle.

3.We can't create sequence in Microsoft Access.We create
sequence in Oracle.

4.Oracle database is more secured than MS-Access. Oracle
can handle a database having million records very
efficiently, but MS-Access has no such quality like Oracle.

5.oracle is client server technology based while Ms-Access
is not.

6.Oracle follow 11 rule of E.F CODD and access follow 7
rule, oracle give better query performance in comparison to
access, oracle perform high security feature like system
manager, oracle can store unlimited data in access limit.

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the size limitation of an Access database?

663


Why is it important to use access?

616


By using Macromedia Director How to fetch the data from Microsoft Excel?

2039


What are the components of ms access?

656


can we call primary key a 'address'????

2156


How to create a simple query in ms access 2013?

619


What is the use of access?

638


Difference between superior keys and candidate keys?

670


What is the maximum number of rows in access 2010?

646


What is the best alternative to microsoft access?

622


How are queries run in ms access? List different ways.

581


How to create software using microsoft access?

665


Is sql similar to access?

634


What is a super key? How is it different from a candidate key?

620


Between different data’s, what are the types of relationship can be formed?

817