Tell me the phases a transaction has to undergo?
Tell me what is the stuff and how does it differ from the replace function?
Explain what is sql server english query?
Explain acid?
What is de-normalization and what are some of the examples of it?
Can you explain what are commit and rollback in sql?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Do you know what are pages and extents? : SQL Server Architecture
Explain the truncate command? : SQL Server Architecture
What are page splits? : SQL Server Architecture
What is tempdb database? : SQL Server Architecture
What is database architecture? : SQL Server Architecture
What are different types of raid configurations? : SQL Server Architecture
What do you know about system database? : SQL Server Architecture
What are the database objects? : SQL Server Architecture