Interview Questions -- SQL Server -- Part-3

                                   Following are the SQL Server basic interview questions.

Questions:-

• What is BIT Data Type and what’s the information that can be stored inside a BIT Column.
• What is CANDIDATE KEY, ALTERNATE KEY and COMPOSITE KEY
• What is Locking.
• What is Normalization and explain different forms of normalization.
• How to change Database Name.
• How to Rename Database Columns.
• What are the System databases available and explain.
• How do you change the character length of the VARCHAR Column from 100 to 200.
• Is it possible to delete records from Foreign Key Column in a table.
• What is SQL Server Agent.
• What is the difference between ISNULL() AND COALESCE() Functions.
• Difference between REPLACE() and STUFF()
• What is the difference between UNION and UNION ALL.

Please share your answer through comments.