21
SQL Server Interview
Data Types, Keys & Constraints
SQL Server interview questions covering data types, keys & constraints.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
22
What is the difference between CHAR and VARCHAR?
23
What is the difference between VARCHAR and NVARCHAR?
24
What is the difference between INT and BIGINT?
25
What is the difference between DECIMAL and FLOAT?
26
What do precision and scale mean in DECIMAL?
27
Which date and time data types are commonly used in SQL Server?
28
What is BIT in SQL Server?
29
What is UNIQUEIDENTIFIER in SQL Server?
30
What is the difference between NEWID() and NEWSEQUENTIALID()?
31
What is a UNIQUE constraint?
32
What is the difference between PRIMARY KEY and UNIQUE?
33
What is a composite key?
34
What is a candidate key?
35
What is a surrogate key?
36
What is a natural key?
37
What is a DEFAULT constraint?
38
What is a CHECK constraint?
39
What is referential integrity?
40