What is normalization and types of normalization?
Answer Posted / danish mahmood
Normalization is a systematic way of ensuring that a
database structure is suitable for general purpose querying
and free of certain undesirable characteristics—insertion,
update, and deletion anomalies that could lead to a loss of
data integrity.
| Is This Answer Correct ? | 41 Yes | 14 No |
Post New Answer View All Answers
What is the most important ddl statements in sql are?
Name the operator which is used in the query for pattern matching?
How do you declare a variable in pl sql?
What is sql profiler in oracle?
Which is faster union or join?
What is scalar function in sql?
What is benefit of creating memory optimized table?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Mention what pl/sql package consists of?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Can instead of triggers be used to fire once for each statement on a view?
What is a full join?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is Histogram?
what are numeric data types? : Sql dba