NOV Applications Developer II interview questions

I had to write a code that has as inputs a list of numbers and outputs the missing numbers. Such as Input(1,2,5,7,9...m) and the output should be Output(3,4,6,8....m) I had to analyze a piece of code and figure the value of a variable. I had to write a Union Query for three tables with same ID's Be ready to discuss lots of technical issues. Dont bother much with behavioral question. lots of technical. Know: .SDLC and steps, SQL queries, procedures, drop, delete, truncate tables, diff between Web Service and WCF, Windows Security (that literally killed me)