answersLogoWhite

0


Best Answer

The difference between Access and Oracle is Access has minimum security features and you can create a small to medium sized database. Oracle has NY security, which allows you to determine who can or can not get access to your data. Access you can't add too many users without it getting slow, and Oracle allows you to add thousands if you want to.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are the differences between Access and Oracle?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are the differences between Oracle and SQL?

Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.


What are the differences between Microsoft Excel and Oracle Database?

Excel is a spreadsheet program. Oracle is for databases. Excel has some databasing capabilities, but it is not its main purpose.


What are the differences between Oracle 10g and ms sql database?

Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.


What are the differences between Microsoft Access and database?

None. Microsoft Access is a database application.


What are the differences between SQL statement to iSQL plus statement?

Structured Query Lanaguage(SQL) is a command language to communicate with oracle server.whereas SQL*PLUS is an oracle tool that recognises and submits sql statements to the oracle server for execution.


What are examples of database packages?

oracle, access,


What is the difference between oracle and foxpro?

difference between oracle and foxpro


What are the differences between blob clob and memo in Oracle?

BLOB is for large Binary based object Clob is for large Character based object


List out the dbms softwares?

*Altibase *Oracle * SQL server * Fox Pro * MS-Access * Sequel-Pro(mac)


What is the difference between oracle exadata and oracle database?

Differences: Oracle Database Appliance is not Exadata. Exadata is a pre-configured combination of hardware and software that provides an infrastructure solely for running Oracle Database. Oracle Database Appliance (ODA) is an integrated highly available (HA) database and applications system in a single box. To learn more about data science please visit- Learnbay.co


What is the most commonly used database application?

Oracle, MS SQL Server, Informix, Sybase, DB2, MySQL And for "toy" applications, MS Access.


What are the similarities between oracle dbms and access dbms?

Oracle and Access are both RDBMS's (Relational Database Management Systems). Consequently they both use tables which have 'keys' to retrieve rows, and use 'foreign keys' to other tables to 'relate' those rows together. Oracle and Access also both use SQL (Structured Query Language) to allow you to use the database (for example: "select * from customer_table where customer_number = '12345'"), although you can use tools which provide a more graphical environment to produce the underlying SQL. The real difference between the two is that Oracle is an industrial strength RDBMS.