SQL Server 2008 Interview Questions and Answers for freshers

SQL Server Database Concepts

1. What is database or database management systems (DBMS)?
2. What's difference between DBMS and RDBMS ?
3. What are CODD rules?
4. Is access database a RDBMS?
6. What's the difference between MSDE and SQL SERVER 2000?
7. What is SQL SERVER Express 2005 Edition?
8. What is SQL Server 2000 Workload Governor?
9. What's the difference between SQL SERVER 2000 and 2005?
10. What are E-R diagrams?
11. How many types of relationship exist in database designing?
12. What's the difference between Fourth and Fifth normal form?
13. Have you heard about sixth normal form?
14. What is Extent and Page?
15. What are the different sections in Page?
16. What are page splits?