- What is the difference between a Primary Key and a Foreign Key?
- How would you retrieve the first five records from a table?
- What is the syntax for adding a new column to an existing table?
- How would you delete a row from a table?
- What is a join in SQL?
- What are the different types of joins in SQL?
- How would you retrieve data from two or more tables using a join?
- What is a database in SQL?
- What is a table in SQL?
- What is a column in SQL?
- What is a row in SQL?
- How would you select specific columns from a table?
- What is a WHERE clause in SQL?
- What is a GROUP BY clause in SQL?
- What is an ORDER BY clause in SQL?
- What is a LIMIT clause in SQL?
- What is a UNION in SQL?
- What is a unique key in SQL?
- How would you create a unique key in SQL?
- What is a constraint in SQL?
- How would you add a NOT NULL constraint to a column in an existing table?
- What is a LIKE operator in SQL?
- How would you use a LIKE operator in SQL?
- How would you use a BETWEEN operator in SQL?
- How would you use an INNER JOIN in SQL?
- How would you use an OUTER JOIN in SQL?
- What is a CASE statement in SQL?
- How would you execute a stored procedure in SQL?
- What is a temporary table in SQL?
- How would you create a temporary table in SQL?
- What is a view in SQL?
- How would you use a view in SQL?
- What is a subquery in SQL?
- How would you use a subquery in SQL?
- What is a correlated subquery in SQL?
- How would you use a correlated subquery in SQL?
- What is normalization in SQL?
- What are the different forms of normalization?
- How would you add a constraint to a table?
- What is an Index in SQL?
- What are the different types of Indexes in SQL?
- What is a subquery in SQL?
- What is the difference between a subquery and a join?
- What is a view in SQL?
- How would you create a view in SQL?
- How would you modify a view in SQL?
- What is the difference between UNION and UNION ALL in SQL?
- How would you modify a trigger in SQL?
- What is a stored procedure in SQL?
- What is the difference between a stored procedure and a view in SQL?
- How would you create a scalar function in SQL?
- How would you create a table-valued function in SQL?
- What is the difference between a subquery and a correlated subquery in SQL?
- How would you write a correlated subquery in SQL?
- What is a full outer join in SQL?
- What is a left outer join in SQL?
- What is a clustered index in SQL?
- How is a clustered index different from a non-clustered index in SQL?
- What is a non-clustered index in SQL?
- How would you create a non-clustered index in SQL?
- What is a composite index in SQL?
- How would you create a composite index in SQL?
- What is a full-text search in SQL?
- How would you perform a full-text search in SQL?
- What is a trigger in SQL?
- How would you create a user-defined function in SQL?
- How is a scalar function different from a table-valued function in SQL?
- How would you use a table-valued function in SQL?
- How would you use a common table expression in SQL?
- How would you use a correlated subquery in SQL?
- How would you use a self-join in SQL?
- What is a recursive CTE in SQL?
- How would you use a recursive CTE in SQL?
- What is a materialized view in SQL?
- How would you create a stored procedure in SQL?
- How would you create a trigger in SQL?
- How would you implement a transaction in SQL?
- What is the difference between a clustered and a non-clustered index?
- What is a cursor in SQL?
- How would you use a cursor in SQL?
- What is a Common Table Expression (CTE) in SQL?
- How would you create a CTE in SQL?
- How would you use a recursive CTE in SQL?
- What is a window function in SQL?
- How would you use a window function in SQL?
- How would you create a materialized view in SQL?
- What is a pivot table in SQL?
- How would you create a pivot table in SQL?
- What is a common table expression in SQL?
- What is the difference between a stored procedure and a function in SQL?
- How would you create a function in SQL?
- What is a temp table in SQL?
- How would you create a temp table in SQL?
- How would you refresh a materialized view in SQL?
- What is a clustered index in SQL?
- How would you create a clustered index in SQL?
- What is a non-clustered index in SQL?
- How would you create a non-clustered index in SQL?
- What is the difference between a cursor and a temporary table in SQL?
- How would you use a cursor in SQL to update data?
- How would you create a partitioned table in SQL?
- How would you create a partition function in SQL?
- How would you create a partition scheme in SQL?
- How would you change the collation of a database in SQL?
- How would you write a correlated subquery in SQL?
- How would you create a pivot table in SQL?
- What is a self join in SQL?
- What is a composite key in SQL?
- What is a database schema in SQL?
- How would you create a database schema in SQL?