161
SQL Server Interview
Database Design, Normalization & Advanced SQL
SQL Server interview questions covering database design, normalization & advanced sql.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
162
What is First Normal Form (1NF)?
163
What is Second Normal Form (2NF)?
164
What is Third Normal Form (3NF)?
165
What is BCNF?
166
What is denormalization?
167
What are insertion, update, and deletion anomalies?
168
What is a one-to-one relationship?
169
What is a one-to-many relationship?
170
What is a many-to-many relationship?
171
What is a temporary table?
172
What is a table variable?
173
What is the difference between a temporary table and a table variable?
174
What is the PIVOT operator?
175
What is UNPIVOT?
176
What is CROSS APPLY?
177
What is OUTER APPLY?
178
What is the MERGE statement?
179
What are sequences in SQL Server?
180