SQL Server Devloper Interview Questions + Altech Sysytems

1. what is normalization? Explain different forms of normal forms? BCNF ?

2.CODD Rules? De-normalization? where we use de-normalizaion?

3.what is E-R Diagrams and DFDs?explain exapmle for each one.

4.What is the select statement order in the DB?

The below is the (general) order of evaluation. Column Aliases are only available from step 5 onwards so are usable in ORDER BY but not WHERE

(5) SELECT (6) DISTINCT
(1) FROM
(2) WHERE
(3) GROUP BY
(4) HAVING
(7) ORDER BY

5.What is the difference between stored function and stored procedure?syntax for each of them .what is the advantage of 
  stored procedure?

6.What is the primary key,unique & foregin key?

7.Different types of joins?exlain example for each one.

8.What is subquery?explain the concept of subquery.

9.What is the difference between clustered index and non-clustered index?

10.What is the local and global temporary tables .example for each?

11.How to rename of a DB,rename of a table & rename of a column? 

12.How to use 1-1,1-M,M-M in the design of tables?

13.Cursor?syntax of a cursor?what is the alternative way of cursor in the business world? .

14.what is the ROWGUIDCOL?

15.what is the prevention of Referential integrity?

16.what is the exporting & importing in DB?syntax.

17.what is the trigger?Nested Trigger.

18.what is the user defined datatype,in which situation UDT used?.

19.what is the transaction?ACID properties.

20.what is the DB backup & restore ,shrink DB?

21.How to handle errors in sql serevr 2008? What is RAISEERROR.