Sql server TATA technology Questions

1. EXPLAIN CONSTRAINTS?

2.WHAT IS CHECK CONSTRAINT? WHEN YOU USE THAT?

3.DEFINE VIEW?

DIFFERENCE BETWEEN WHERE CLAUSE AND HAVING CLAUSE?

5.WHAT IS INDEX USE OF INDEXES?

6.WHAT IS TOP CLAUSE?

5.WHAT IS WILD CARD EXPLAIN?

7.GOALS OF NORMALIZATION?

DIFFERENCE BETWEEN UNION AND JOIN?

9.WHEN YOU USE JOIN AND SUB QUERY?

10.WHAT IS CURSOR?

11.WHEN YOU USE SELF-JOINS?

12.WHAT IS USE OF SQL JOBS?

13.HOW MANY OPERATING SYSTEMS SUPPORT THE SQL SERVER?

14.TRUNCATE COMMAND EXPLAIN?