Answer / 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.

Answer / 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.

What do you mean by erd and its main elements? Explain with example.

0 Answers  

---

How would you import data from another ms access database?

0 Answers  

---

What is the purpose of ms access?

0 Answers  

---

How you can import data from other sources into access database?

0 Answers  

---

Name at least six file extensions of Microsoft Access?

0 Answers  

---

Is microsoft access a good database?

0 Answers  

---

Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY will wrote in "thousand" box FIVE will be in "hundred" box and THIREE will be in "ten" box...... so, in sort i need to know that how can i do module for this that it appears automatically in perticular boxs...thanks

2 Answers  

---

What is the role of where clause in ms access?

0 Answers  

---

What are the several methods to enter data in ms access 2013?

0 Answers  

---

What is the purpose of access?

0 Answers  

---

Why is it important to use access?

0 Answers  

---

How do you create a simple access database?

0 Answers  

---