difference between procedure and function?
Sql Support Interview Questions
2,214 sql support interview questions shared by candidates
he has asked about performance tuning
SQL: Triggers Function syntax Procedure execution Joins how do you optimize slow running query delete and drop Common Table expressions Normalization They will give scenarios and ask you to write the queries. Power Bi: difference of Filter/ slicer page level filters Import mode and direct query Relationships some example scenerio questions: if i take the live data can we refresh the report everyday? if i have 5 lakhs record and 10k records which one you will use import mode or direct mode? Time intelligence functions
3 rd round where logic is tested by giving them puzzle type questions
self join, cursors and its types, functions, procedures, can we have commit in functions, framing query for business logic
ArrayList, LinkedList, HashMap, HashTable, int,Integer
Technical questions relevant to the job and your previous experience/skill set.
He asked me about certificates and I shocked even he do not know that few certificates are valid through life and enter into legacy
They asked me basic SQL server related questions. Scenario based and theory based questions.
Write a stored procedure that accepts a date range to return data from a set of tables
Viewing 1861 - 1870 interview questions