Answer Posted / sakthi
Normalization:
Process of decomposing a longer table into
smaller one, by using normalizaton we can fetch the data
faster. there are different types of normalization below
listed are few important one.
1) 1st normal form
2) 2nd normal form
3) 3rd normal form
4) 4th normal form
5) 5th normal form
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain indexed views and partitioned view with their syntax.
What is difference between count (*) and count 1?
How to enter unicode character string literals in ms sql server?
What are transactions in sql?
What is the difference between a function and a stored procedure?
What is identity?
How to attach adventureworkslt physical files to the server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Do you know what is a with(nolock)?
Explain iaas, paas and saas?
what is a mixed extent? : Sql server administration
What is collation?
What do you mean by an execution plan? Why is it used? How would you view it?
How are the unique and primary key constraints different?
Comment,Datatypes are unlimited