Interview Sql server interview questions

What do you understand from SQL Server? What is the use of this server in technology?
How do you explain stored procedure? Give an example of stored procedure?
Which TCP/ IP protocol is suitable to run a SQL server?
Is it possible to change the default post? If yes, explain how?
What is normalization and state trigger? How triggers can be used to implement business rules?
Explain view and how would it be used to view a specific column and row in database? How view is helpful for users?
Describe the types of indexes available in SQL server? Explain each with suitable examples?
What is the use of cursor? How cursor helps to make an operation easy?
Explain the use of UPDATE_STATISTICS command? When this command is suitable to use, explain conditions?
Why DBCC commands are used? Give options to use this command?
Can TRUNCATE command be used on a table reference by FORWIGEN KEY?
Which command can you use to rename the db? State the difference between HAVING CLAUSE and WHERE CLAUSE?