How to Handle Missing Data in a Database?



How to Handle Missing Data in a Database?..

Answer / hr@tgksolutions.com

One way to deal with missing data in a database is to:

Ignoring: During analysis, ignoring rows with missing values.
Imputing is the process of substituting a default value, mean, median, or value obtained from additional data for missing variables.
Elimination: Taking out rows or columns that contain a significant number of missing values.
Using Placeholders: Using a particular placeholder to indicate missing values

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

What is correlated subquery in dbms?

0 Answers  


What happens when my integer identity runs out of scope?

0 Answers  


what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,

0 Answers  


How do you link a spreadsheet to a website?

0 Answers  


What is an ALERT ?

1 Answers  


what are the different kinds of indexing?

0 Answers  


What is key dbms?

0 Answers  


What is equi-join?

1 Answers  


Can we pass RECORD GROUP between FORMS ?

1 Answers  


Mention the types of join?

0 Answers  


What is cluster table or non_cluster table?

1 Answers  


What database does facebook use?

0 Answers  


Categories