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
How do I apply a custom Ribbon after a user logs into the database? I want to use a different ribbon based upon the users level of security. I have 3 levels.
Is it possible to retrieve all tables along with all the data?how?
What is maximum size for an access database?
What would happen if the both source and destination have the same name?
What is the difference between ms access and mysql?
What are the main differences between the two?
What is microsoft access database?
What is the importance of primary key in ms access?
Between different data’s, what are the types of relationship can be formed?
How do I use microsoft access with excel?
What are the benefits of ms access?
What is the purpose of ms access?
how to toggle ms word to ms excel or ms excel to ms word
What is a query in access?
What is primary key in ms access?