SQL SERVER ( VIEWS ) REAL TIME INTERVIEW QUESTIONS AND ANSWERS

1. What is a SQL View?
2. What is View? Use  ? Syntax of View ?
3. Does the View occupy memory space?
4. Can u drop a table if it has a view?
5. Why doesn't SQL Server permit an ORDER BY clause in the definition of a view?
6. How do you create view and limit of columns?
7. What do you understand by a view? What does the WITH CHECK OPTION clause for a view do?
8. What is difference between View and Materialized view?
9. Write a CTE to display department hierarchy?
10. Views accepts encryptions?
11. Can you write the query of view using encryption?
12. Can view create any new table while after creation of view? Or get data from original table?
13. We have 40 tables in a view and used join in query can we update 38 table in view?
14. How do you differentiate Local and Global Temporary table?
15. What is the difference between a local and a global variable?
16. Difference between temp table and table variable?
17. What is the difference between # tables and declare table(temp tables)?
18. What is the difference between # tables and ##tables?
19. How Global temporary tables are representated and its scope?
20. Define some facts about Temporary table and there types?
21. What is CTE?
22. What are the Advantages of using CTE?