Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What are the data types in SQL Server?

1. bigint
2. datatime
3. money
4. smalldatetime
5. tinyint
6. Binary
7. Decimal
8. Nchar
9. Smallint
10. Varbinary
11. bit
12. float
13. ntext
14. smallmoney
15. Varchar
16. char
17. image
18. nvarchar
19. text
20. uniqueidentifier
21. cursor
22. int
23. real
24. timestamp




Next 5 interview question(s)

1
What is fill factor in SQL Server?
2
What is sorting and what is the difference between sorting & clustered Indexes?
3
Difference between Index defrag and Index rebuild in SQL Server?
4
How many clustered indexes can a table have?
5
Disadvantage of Index in SQL Server?