Database design - What is denormalization and wh

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

(Continued from previous question...)

Database design - What is denormalization and when would you go for it?

As the name indicates, denormalization is the reverse process of normalization. It’s the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced.

(Continued on next question...)

Other Job Interview Questions

• Do you know how to configure DB2 side of the application?
• What are constraints? Explain different types of constraints.
• When you create a database how is it stored?
• How do you test proper TCP/IP configuration Windows machine?
• What are the different ways of moving data/databases between servers and databases in SQL Server?
• What is a traditional Network Library for SQL Servers?
• How many bits IP Address consist of?
• Explain the storage models of OLAP
• What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
• What is lock escalation?
• More...