Anomalies in a SQL Table in Hindi l SQL Tutorial l Javatpoint Hindi

Описание

SQL Course: Anomalies in a Table in Hindi #sql #sqlforbeginners

1. Missing values: A missing value is a value in a database that is missing or that is unusable. Examples of missing values include empty fields, NaN values, or even values that are simply not applicable.

2. Outliers: Outliers are data points that are significantly higher or lower than the rest of the data. Outliers can be caused by data entry errors, incorrect measurements, or other problems.

3. Duplicate records: Duplicate records are two or more records in a table that have the same information. Duplicate records can cause problems when retrieving, updating, or deleting data.

4. Inconsistent data types: Data types should be consistent across a table. Inconsistent data types can cause errors when performing calculations or operations on a table.