ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
   
 
Categories  >>  Software  >>  Databases  >>  MS Access
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Difference between MS Access and Oracle
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Difference between MS Access and Oracle
Answer
# 1
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 ?    12 Yes 1 No
Dessika
 
  Re: Difference between MS Access and Oracle
Answer
# 2
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.
 
Is This Answer Correct ?    7 Yes 0 No
Kani
 
 
 

 
 
 
Other MS Access Interview Questions
 
  Question Asked @ Answers
 
If you know "Access", you can capture data from "Excel" broadsheet, but the limitation is that, a memo data type of "Access" can only hold characters upto- (a)31,000; (b 32,000; (c)33,000; (d)34,000. Wipro1
how to u retrieve all tables along with all the data Satyam1
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
can we create relastionship bet 2 tables in ms-access  2
can ms access be used in a website instead of sql server?  2
I am using ms access and am stumped trying to determine the last three entries ( by date ) for each name in the database. Any help would be appreciated.  1
what do u mean by heptic shedule over india  1
What is a diffrence between SQL, MS access and SAS? Genpact2
What is the main difference between DBMS and RDBMS?  2
Which of the following is used to enter or display data via Internet? Data in it is stored as HTML files, with data read from and written to the database. Macros Queries Forms Pages Wipro1
Can you create a updatecascade, Deletecascade relation in Ms-Access? If yes, give an example?  2
Difference between MS Access and Oracle CMC2
 
For more MS Access Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com