The interview included one online technical test and an hour long f2f interview. It was tiring and I was asked about everything from A to Z related to SQL server. It included basics as well as Backup, Clustering, Mirroring, Log Shipping, Architecture. Scenario based questions and direct questions as well.