WHAT IS VIEW IN SQL SERVER ?HOW MANY TYPES OF VIEW AVAILABLE?

Answer:

VIEW IS AN VIRTUAL TABLE.VIEW IT WONT OCCUPY ANY MEMORY,VIEW IS AN IMAGINARY TABLE.
VIEW CANNOT INSERT,UPDATE ,DELETE STATEMENTS

THERE TWO TYPES OF VIEWS AVAIALBLE

1) SCHAMABINDING
2) ENCRYPTION

REGARDS