What is normalization and what are the advantages of it?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  


what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  


How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  


Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  


I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,






How can we delete Duplicate row in table?

0 Answers   Wipro,


What is temporal table?

0 Answers  


How important do you consider cursors or while loops for a transactional database?

0 Answers  


Tell me what do we need queues in sql service broker?

0 Answers  


In the primary key have a multiple field or not?

8 Answers   TCS,


What is difference between index seek vs. Index scan?

0 Answers  


How do I find the default sql server instance?

0 Answers  


Categories