SQL Server Interview Questions

Can you answer these SQL Server Interview Questions?

What is normalization
What is the fastest way to empty a table
what is a deadlock
Can you give an example of creating a deadlock
How do you detect deadlocks
What is an audit trail
what is an identity column
How do you return an identity value from a table
How do you return an identity value from a table with a trigger
How many bytes can you fit in a row, do you know why
What is a clustered index
How many clustered indexes per table
How many nonclustered indexes per table
what is an execution plan
What does trace flag 1204 do

That is just a partial list, you can find the rest here here: How Well Do You Interview And Do You Use Wizard Driven Programming?