SQL Server interview questions and answers for 2 years experience

SQL Server interview questions and answers for freshers

1. What are "GRANT" and "REVOKE' statements?
2. What is Cascade and Restrict in DROP table SQL?
3. How to import table using "INSERT" statement?
4. What is a DDL, DML and DCL concept in RDBMS world?
5. What are different types of joins in SQL?
6. What is "CROSS JOIN"?
7. You want to select the first record in a given set of rows?
8. How do you sort in SQL?
9. How do you select unique rows using SQL?
10. Can you name some aggregate function is SQL Server?
11. What is the default "SORT" order for a SQL?
12. What is a self-join?
13. What's the difference between DELETE and TRUNCATE ?
14. What are cursors and what are the situations you will use them?
15. What are the steps to create a cursor?
16. What are "Global" and "Local" cursors?
17. What is a Sub-Query?
18. What is SQL injection ?