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
What are the features of ms access?
List some of the uses of ms access.
How do I create a small business database in access?
Is microsoft access in the cloud?
What is the function of access?
What is the role of where clause in ms access?
How we can do multi-join query in ms access?
What is the importance of primary key in ms access?
Is microsoft access still available?
Can multiple users access the same access database?
How do you check if ms access is installed?
When to use ms access vs excel?
What is the best alternative to microsoft access?
What is a null value in access?
I am designing an Access database form. how can I get my next control in the form to be automatically selected?