Search questions and share your knowledge with the world here on Questionpoint.
Home > Database Design Interview Questions > Hi whats the differences and similarities between ...

:: Categories ::

Interview Question in Database Design


 

Interview Question :: Hi whats the differences and similarities between Microsoft Access, Oracle and SQL to be used for a database


I heard that microsoft access isnt good for big databases is this true and whys tbhis the case ? As we have a group and we're designing a database we need to keep 1000 records and what would the the best software be? for this becuase we know how to use access we know the basics of how to use oracle is it worth learning about these programs what can u do in the various prograMS that u cna't do in the other any help would be so much appreciated!
thanks for you time
Answers to "Hi whats the differences and similarities between Microsoft Access, Oracle and SQL to be used for a database"
RE: Hi whats the differences and similarities between Microsoft Access, Oracle and SQL to be used for a database?

Both SQL Server and Oracle are Relational Database Management Systems. Microsoft Access is not; it is run by a jet engine instead.



Microsoft created Access in an attempt to compete with FoxPro (a product similar to Access). When Access failed to do compete with FoxPro, Microsoft bought the FoxPro company.



Now for the Oracle and SQL Server, both are Relational Database Management Systems. A Relational Database Management System is capable of supporting concurrency (concurrent access to data), transactions (ablity to excute queries as an atomic block with rollback capability) so it can handle more concurrent users and it is for sure more reliable in a multiuser environment.



It is very hard to say which (Oracle or SQL Server) is better because there are so many factors that have to be taken into consideration, however SQL Server enjoyes a remarkable growth rate because it is easier to use and more cost-effective than the competing enterprise Database systems like Oracle and IBM DB2. Of course oracle and IBM DB2 have been entrenched in the enterprise for some time now , unlike SQL Server.



One last point. You can use any of the above products to handle 1000 records, However since you are still learning about Database programming, I suggest you learn either SQL Server or Oracle so that you learn some Database programming concepts like the use of Database objects such as stored procedures, triggers, transactions and so on.
 
Vote for this answer ::  
RE: Hi whats the differences and similarities between Microsoft Access, Oracle and SQL to be used for a database?

Basically MS-Access is for small scale industries/businesses - thats what microsoft itself is claiming. MS Access cannot handle records more than say a few thousands. I myself have experienced it - after 80000 records - MS Access really struggles. However MS SQL Server is quite capable of handling large number of records/data - so does ORACLE.



For your requirement, MS Access will be just fine.
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License