- What is the difference between a primary key and a foreign key?
- How do you create a new database in MS SQL?
- What is a query and how do you write one in MS SQL?
- What is normalization and why is it important in database design?
- What is a stored procedure and how do you create one in MS SQL?
- What is an index in MS SQL and how does it improve database performance?
- How do you insert data into a table in MS SQL?
- What is a trigger in MS SQL and how does it work?
- How do you backup and restore a database in MS SQL?
- How does the ACID model ensure data consistency in MS SQL?
- Explain the difference between a char and varchar data type in MS SQL
- What is a transaction in MS SQL and how does it work?
- How do you use the TOP keyword in MS SQL to limit the number of results?
- What is a clustered index and how does it differ from a non-clustered index in MS SQL?
- What is the purpose of the @@IDENTITY system function in MS SQL?
- How do you use the LIKE operator in MS SQL to search for patterns in data?
- What is the difference between a left and right outer join in MS SQL?
- How do you use the DISTINCT keyword in MS SQL to eliminate duplicates from a result set?
- What is the purpose of the SET statement in MS SQL?
- Explain the difference between an inner join and an outer join in MS SQL.
- What is the difference between a clustered and a non-clustered index?
- How do you optimize a query in MS SQL?
- What is a subquery in MS SQL and how is it used?
- How do you use the GROUP BY clause in MS SQL?
- Explain the difference between a view and a table in MS SQL.
- What is the purpose of the WITH clause in MS SQL?
- How do you use the EXISTS operator in MS SQL?
- What is the difference between a function and a stored procedure in MS SQL?
- How do you use the TRY...CATCH statement in MS SQL to handle errors?
- How do you optimize a query in MS SQL using execution plans?
- What is a temporary table in MS SQL and how does it work?
- How do you use the XML data type in MS SQL to store and retrieve data?
- What is a cursor in MS SQL and how is it used to traverse a result set?
- What is the difference between a trigger and a constraint in MS SQL?
- How do you use the ROW_NUMBER() function in MS SQL to generate row numbers for a result set?
- What is the purpose of the CROSS APPLY operator in MS SQL?
- How do you use the COALESCE function in MS SQL to handle null values?
- Explain the difference between a heap and a clustered table in MS SQL.
- How do you use the QUOTENAME function in MS SQL to dynamically generate SQL statements?
- How do you design a database schema for a large-scale application in MS SQL?
- Explain the difference between a OLTP and OLAP database in MS SQL.
- What is a partition in MS SQL and how does it improve database performance?
- How do you use the HAVING clause in MS SQL?
- Explain the difference between a cursor and a temporary table in MS SQL.
- How do you use the APPLY operator in MS SQL?
- What is a Common Table Expression (CTE) in MS SQL and how is it used?
- How do you use the MERGE statement in MS SQL?
- Explain the difference between a scalar and a table-valued function in MS SQL.
- How do you use the PIVOT and UNPIVOT operators in MS SQL?
- How do you use partitioning in MS SQL to manage large amounts of data?
- How do you use the FILESTREAM data type in MS SQL to store and retrieve large objects?
- What is a materialized view in MS SQL and how does it differ from a regular view?
- How do you use the RANK() function in MS SQL to rank rows in a result set?
- What is a recursive CTE in MS SQL and how is it used to generate hierarchical data?
- How do you use the APPLY operator in MS SQL to join a table with a table-valued function?
- What is the purpose of the TABLESAMPLE clause in MS SQL and how is it used?
- How do you use the OFFSET and FETCH clauses in MS SQL to perform pagination?
- What is a filtered index in MS SQL and how does it improve query performance?
- How do you use the STRING_AGG function in MS SQL to concatenate strings from multiple rows into a single result?