Interview Question

What is SQL Injection?
What is DBCC? Give few examples.
What is difference between View and Materialized view?
What is CTE (Common Table Expression)?
What is difference between clustered and non clustered index?
What is use of EXCEPT clause? How it differs from NOT IN clause.
What is difference between Index Seek vs. Index Scan?
What is ROW_NUMBER function?
What is Trigger?
What is Scheduled job and how to create it?
What is OPENXML in SQL Server?
What are Sparse columns?
What is RANK function?
What are cursors and when they are useful?
What is log shipping?
What is SQL Profiler?
What is Similarity and Difference between Truncate and Delete in SQL?
What is Normalization of database? What are its benefits?
What is Fill factor?
What are different types of replication in SQL Server?
What is REPLACE and STUFF function in SQL Server?
Give a example to search for a string in all stored procedure in SQL Server.
What are Magic tables in SQL Server?
What is difference between stored procedure and user defined function?
What are ACID properties of Transaction?
What are COMMIT and ROLLBACK in SQL?
What is a Linked Server?
What is a WITH(NOLOCK)?