Collection of Interview Questions on  Sql Servers

1. What is Database Normalization?

In relational database theory, normalization is the process of restructuring the logical data model of a database to eliminate redundancy, organize data efficiently, and reduce repeating data and to reduce the potential for anomalies during data operations. Data normalization also may improve data consistency and simplify future extension of the log

By: Pankaj Kumar Gupta   |    On:  24 Mar 2011 08:43:06

1. True

2. False
By: RRaveen   |    On:  25 Dec 2010 11:04:13

Answer:

  1. INNER JOIN
  2. OUTER JOIN(LEFT,RIGHT,CROSS,FULL)

 

By: RRaveen   |    On:  22 Dec 2010 10:18:52
^ Scroll to Top