What is the definition of normalized and denorma

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the definition of normalized and denormalized view and what are the differences between them?

Normalization is the process of removing redundancies.

Denormalization is the process of allowing redundancies.

(Continued on next question...)

Other Job Interview Questions

• What is Fact table?
• What is degenerate dimension table?
• Is OLAP databases are called decision support system ??? true/false?
• What is a lookup table?
• Which columns go to the fact table and which columns go the dimension table?
• What are Data Marts ?
• What is conformed fact?
• explain in detail about type 1, type 2(SCD), type 3 ?
• Why fact table is in normal form?
• What is the difference between datawarehouse and BI?
• More...