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

Where is microsoft access located?

569


How do I get microsoft access on my computer?

596


Can you purchase just microsoft access?

582


How do access relationships work?

607


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

605






At what levels can data validation be done in microsoft access database?

758


What can I use microsoft access for?

590


How many columns are in access?

559


You are required to create a macro that can run action query. What steps will you take?

621


What is the difference between microsoft access and excel?

529


Explain about the various features present in MS Access?

622


Difference between superior keys and candidate keys?

616


How do I open microsoft access?

608


What is access on a computer?

542


What is design view in ms access?

578