GeekInterview.com
Series: Subject: Topic:
Question: 7 of 60

Data Redundancy and Data Consistency

How will you check data redundancy and data consistency using SQL queries?
Asked by: parth1516 | Member Since Mar-2010 | Asked on: Mar 25th, 2010

View all questions by parth1516

Showing Answers 1 - 1 of 1 Answers
sandesh mastake

Answered On : Apr 23rd, 2013

Data redundancy means youre checking for duplication. In order to make that check, you need to determine what signifies a duplicate within the table to which you are referring. There is not a single query that will satisfy until you can define what makes a duplicate record.

Data consistency is completely a business model. There is no way from a pure programming stand point to know that, for example, NY and New York are either incorrect or correct values for a given field unless someone has defined that the data must look a certain way.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

.Net Testing

Bug Tracking

Common

DataBase Testing

Discussion

Functional Testing

Load Testing

Network Testing

Product Testing

QA Testing

Quality Control

Quality Management

Security Testing

Software Testing

Test Automation

Test Cases

Testing Basics

Testing General

Testing Scenarios

Web Testing

Whitebox Testing

Wireless Testing

Interview Coaching

What will you do when you are not able to get your message across to your audience?

Aptitude Test Preparation Tips

Do you seek advice from others when you have a question?

Describe a time when you had to convince a friend ?

What are my options when I do not get a job after graduation?

What are the career opportunities available for MCA Graduates?

Tell me three things about you, which are not found in your resume

What is the role of a mechanical engineer in the Software Industry?

How to Overcome Employment Gap during interview.

Describe a time when you had to work under pressure.

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe