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
What is access runtime?
I have a task regarding access database. I and my organization is using access database to maintain my access files in well mannered way. But due to varied reasons access file showing error message Error 3112: Your access database got corrupted will not be able to show the database. Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????
What is the difference between ms access and mysql?
Does office 365 include microsoft access?
What is microsoft access best used for?
Is ms access part of ms office?
List different query types in microsoft access database
State some of the uses append query?
Explain table queries and select queries.
What is the purpose of ms access?
What do you mean by queries?
How do I start microsoft access on my computer?
Is microsoft access going away?
What is microsoft access?
Would you like to easily automate your MS Access database through menu driven selections?
