What is difference between Access(DBMS) and RDBMS like SQL
Server or Oracle?. Why Access is not used in web based
application?
Answers were Sorted based on User's Feedback
Answer / suneel reddy
difference is nothing but in access we dont have relations
to carry database we dont have normalization,joins
but in oracle we have normalized data or relations
| Is This Answer Correct ? | 27 Yes | 10 No |
Answer / sujatha
Hai,
MS ACCESS is comes under to DBMS.It's not having any
relations,joins,normalizations.It's used to store the data
and retrive the data.
Orcle and SQL server comes under to RDBMS(relational
database management system).It's having relations to
connect the another tables and having joins,normalizations.
| Is This Answer Correct ? | 28 Yes | 11 No |
Answer / madhu
ms access is dbms because in this we can only store the data and retrieve the data.oracle and sql are rdbms ,in this we can
store the data and retrieve the data and also able to spread his way to organise database as relationaljoins,normalizations.
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / murthy
Also, we can not write stored procedures and functions and
triggers,packages etc...
| Is This Answer Correct ? | 8 Yes | 7 No |
Answer / mahdi
in access you don't have transactions.
it's really important to exactly do or do not something in
your database.
whitout transactions , there is't any warranty for that!!
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / amit garg
Ya, Its true that In Ms Access we can create Foreign Key and which is a relation ship. On the behalf of this nature we can calculate that after containing only one feature of relationship it can be a RDBMS because RDBMS is collection of so many feature e.g. function, trigger, procedure, indexes etc after that we say that this is RDBMS (e.g. MS SQL SERVER 2000,05,08 and oracle).
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ajit
actually it's a blunder that we don't think that MS-ACCESS
is a rdbms package.It follows codd-commandment rule and
able to spread his way to organise database as relational,
so it's true that it's a rdbms package..
| Is This Answer Correct ? | 5 Yes | 5 No |
Hello, I would like to know which all versions of Testing tools (load runner, winrunner, qtp, test director) are no longer used and which versions of these which are being used?
What is version description document (vdd)?
What is RC update and BRIO?
what is meant by Test suite
Hello Frds, Iam Going to attend Face to face interview on coming Monday in Wipro. Iam going with 3+ years of experience.I'm requesting u all of Frds who attended wipro recently pls post your interview experience, the questions they asked so that it will be help ful to me and other frds who are going to attend wipro.. thanks in advance
When should 'regression testing' be performed?
hello everybody, I have started learning testing tools and have familiarity with winrunner and general testing knowledge.Pl let me know what other stuff should i learn. I had 6 yrs of exp in GIS field and now i want to shift to testing tools. I left my job in 2001 now i want to enter into the market again. Could any of u help me how to approach the market. Any suggetions are very helpful to me. I am in US though. Thanks in advance
What is Gap Analysis
What are the main key components in Web applications and client and Server applications? (differences)
4 Answers Accenture, Disha Tech, Verisoft,
Explain smoke testing?
Please some one answer these Q's 1.Modules in Pension Domains ? 2.What Should we Test on Pension Domain.? Thanks in Advance Stewie
What is open box testing?