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
Explain about creating a report tool by using the report tool and report wizard?
Tell some of the most important uses of ms access?
What can I use microsoft access for?
Why is it important to use access?
Explain table queries and select queries.
How many types of relationships are there in ms access?
How do you create a database using microsoft access?
Explain superior keys and candidate keys. How are they different?
Is it possible to use primary key of one table as a primary key in many other tables?if yes, how?
How can you maintain a relationship between different databases in access?
What is dao recordset in access?
Would you like to easily automate your MS Access database through menu driven selections?
How do I set a primary key in access 2007?
What is the importance of primary key in ms access?
What is microsoft access and its uses?
