SQL Server - Difference between "ORACLE" and "MICROSOFT ACCESS" databases?

GeekInterview.com > Interview Questions > Database > SQL Server

Go To First | Previous Question | Next Question

SQL Server | Question 24 of 94

Difference between "ORACLE" and "MICROSOFT ACCESS" databases?

Total Answers and Comments: 7

Last Update: May 09, 2006 Asked by: Beena

Sponsored Links

Best Rated Answer

—

Submitted by: Shoby

Oracle is ORDBMS (Object Oriented Relational DataBase) while Access is RDBMS(Relational DataBase) only.

Above answer was rated as good by the following members:
jeangood

October 06, 2005 01:58:53

RE: Difference between "ORACLE" and "MICROSOFT ACCESS"...

Oracle can handle much complicated databases, while Access is just a small database with limited database functionality

Is this answer useful? Yes | No

November 11, 2005 05:10:46

gomathi

RE: Difference between "ORACLE" and "MICROSOFT ACCESS"...

oracle provides more security then access

Is this answer useful? Yes | No

December 15, 2005 09:40:56

RE: Difference between "ORACLE" and "MICROSOFT ACCESS"...

Qracle is a most closest of being a perfect RDBMS (flollowing more then 11 rules of Dr. EF Codd)

Where as Access is just a database following 7-8 CODES rule of perfect database...

Is this answer useful? Yes | No

January 02, 2006 06:00:41

starmile

Member Since: December 2005 Contribution: 4

RE: Difference between "ORACLE" and "MICROSOFT ACCESS"...

Ms-Access is file server . An application can run without installing Ms-Access which using MS-access as backend. And Oracle is based on Client/Server appraoch , must be installed to host application

Is this answer useful? Yes | No

January 06, 2006 16:54:20

manish kumar dixit

RE: Difference between "ORACLE" and "MICROSOFT ACCESS"...

oracle is a server based databae while the ms acces is only for local datbase we can use oracle as a lacal data base.but normly we have used oracle as server based .

Is this answer useful? Yes | No

May 04, 2006 06:00:58

chandu

RE: Difference between "ORACLE" and "MICROSOFT ACCESS"...

Hi,

Here oracle holds Terabytes of Data.But MS-Access we can't holds the Terabytes of Data.

Some features in Oracle like platform independent,Index tunning and Tables spaces.

But Ms-Access not platform independent no indexes..etc..

But Oracle pricing more.comparitivly MS-Access.

Is this answer useful? Yes | No

May 09, 2006 00:03:17

Shoby