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
can we call primary key a 'address'????
At what levels can data validation be done in microsoft access database?
Is sql similar to access?
Is access database still used?
Would you easily automate your ms access database through menu driven selections?
Suppose you are designing an access database form. How will you get your next control in the form to be automatically selected?
How many types of table create in ms access?
Is it possible to automate the ms access database through menu driven selections? If yes, how?
How do I install microsoft access 2013?
Does office pro plus include access?
When to use ms access vs excel?
Is ms access hard to learn?
What is a null value in access?
What is microsoft access and its uses?
How would you manager data tasks?
