|
By Nishant Kumar
Define Normalization and De- Normalization.
Normalization
-
It is the process of organizing data into related table.
-
To normalize database, we divide database into tables and establish
relationships between the tables.
-
It reduces redundancy. It is done to improve performance of query.
|
Steps of normalization:
First Normal form
Entities of the table must have unique identifier or entity key.
Second Normal Form
All the attributes of the table must depend on the entity key for that entity.
Third Normal Form
All attributes that are not part of the key must not depend on any other
non-key attributes.
De-normalization
The process of adding redundant data to get rid of complex join, in order to
optimize database performance. This is done to speed up database access by
moving from higher to lower form of normalization.
Interview
Questions on SQL Server Replication includes following questions with answers
What is Replication? | What are the types of Replication?
| Define the terms used in Replication. | Describe the replication agents that
SQL Server supports. | Describe in brief working of Replication.
SQL Server database stores information in a two dimensional objects of rows and
columns called table......
The column or columns of the table whose value uniquely identifies each row in
the table is called primary key. You can define column as primary key using
primary key constraint while you create table.....
SQL Profiler is a tool that stores events from the server. SQL Profiler saves
the events in the trace file......
It is
system variable that returns error code of the SQL
statement.....
|