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

Define truncate and delete commands?

0 Answers  


What is an advantage of a database?

0 Answers  


What is dbms pdf?

0 Answers  


What is 1nf 2nf 3nf in dbms?

0 Answers  


What is end users in dbms?

0 Answers  






Explain snapshot replication.

0 Answers  


What is inner join in database?

0 Answers  


What is primary key in database?

0 Answers  


How to extract metadata for the entire database?

0 Answers  


What is sql in database management system?

0 Answers  


What are different type of normalization?

0 Answers  


What is database write application of database?

0 Answers  


Categories