sql Interview Questions

“Gobal Temporary Tables”

“How to select all records from one tables that don't exist in another?”

“Are you familiar with SQL Windowing?”

“Student, course and registration. You want to join but keep at least one line for each student and course”

“Don't let the interviewer answer the question for you. He will keep talking and will try to put words in your mouth / help you, or at least give you the feeling. You have to ensure that you are…”

“I won't put anything too specific but the expectations are high...you must know C# and SQL in and out”

“A bunch of sql questions.”

“how would you select common rows between two tables, what is a left outer join? What is the structure of a pl sql block?”

“Asked some basic SQL Statement questions where you had to explain what you would write to obtain certain business information.”