What is difference between Oracle and MS Access? What are disadvantages in Oracle and MS Access? What are features&advantages in Oracle and MS Access?

  • Interview Candidate
  • 20
  • 5899

Showing Answers 1 - 20 of 20 Answers

Just Another

  • Dec 9th, 2005
 

One of the differences is:

Oracle is multi-user where MS-Access is not.

- justAnother

  Was this answer useful?  Yes

samiksc

  • Jan 19th, 2006
 

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.

  Was this answer useful?  Yes

sreyas.m.n

  • Feb 23rd, 2006
 

Oracle is a Multiuser database,it can support a varity of applications.But MS Acces is perform a sigle applications

  Was this answer useful?  Yes

Kajal Pancholi

  • Mar 16th, 2006
 

hi,

One important difference is that

We can't create sequence in Microsoft Access.We craete sequence in Oracle.

  Was this answer useful?  Yes

gomathi.e

  • Mar 18th, 2006
 

oracle provides more security than ms access.

  Was this answer useful?  Yes

Vijay Taneja

  • Dec 21st, 2006
 

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.

  Was this answer useful?  Yes

kiran

  • Apr 15th, 2007
 


oracle is client server technology based while Ms-Access is not.

  Was this answer useful?  Yes

himanshusinha1

  • Jul 7th, 2007
 

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.

  Was this answer useful?  Yes

ywaikar

  • Jul 17th, 2009
 

Both Oracle and MS Access are RDBMS,
Oracle followed Client-Server architecture while MS Access is does not.
We can have Login Security, command level security in Oracle.
Can define relationship at time of table creation.

Jee Va

  • Sep 17th, 2011
 

Hi! everyone, I've to develop a small retail store management application for our Store. I've selected the front end as JAVA and back end is ??? (Still confusing) to use 1.Using File Handling(but i don't have experience int this and Complicated too) 2.Oracle 3.MySql 4.MS Access 5.Ms Excel as database.

Can anyone suggest me which one is light weight and higher performance for small database, with able to work within 1GB of RAM.

Thanks for read it,will you help me..

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions