Difference between MS Access and Oracle

Answer Posted / dessika

There are many differences between Oracle and Access. First,
you need to know that Oracle and Access are both relational
database engines. Oracle is sold by Oracle Corporation and
Access is sold by Microsoft. The biggest differences between
the two are the size and number of users each supports.
Oracle is a scalable enterprise database engine that
supports from one to many (tens to hundreds of thousands) of
simultaneous users. Access on the other hand is most
commonly used as a single-user database but since the
release of Access 97, can be augmented with Visual Basic
code and can easily support 100+ simultaneous users (Top
limit of 200 users). Oracle can support very large databases
(Tens of Terabytes in size or larger), while Access is
designed for much smaller databases in the 1 to 2 gigabyte
size range.

Is This Answer Correct ?    18 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is microsoft access database engine?

607


Would you easily automate your ms access database through menu driven selections?

651


List the advantages of access database ovr oracle database.

609


How you can create a table using maol (microsoft access object library)?

903


What are the uses of append query?

614


What is the difference between a form and a report in access?

669


What are the limitations of microsoft access?

637


How do I start microsoft access on my computer?

669


What is a query in access?

586


Suppose you are designing an access database form. How will you get your next control in the form to be automatically selected?

655


How do you create access?

696


What is msaccess exe?

617


How do I publish an access database to the web?

615


Who uses access database?

628


What is query in ms access?

571