Cursors, types of cursors, and cursors l attributes
Sql Programmer Interview Questions
2,216 sql programmer interview questions shared by candidates
Difference between Function and Procedure
what is materialized view and why it is required?what is pivot? when to use the non-clustered index and when to use clustered one.what will you do if your database is growing out of size?how to optimize the query or stored proc? how to read execution plan and what steps to take on it? write query which can add row number column for a table? what is partition? diff between temp table and temp table variable? scope of global variable? there are two tables both have only one column which accepts null, both table have 5 rows as 1,1,1,1,null. how many rows will come for inner join, left, right, union and union all on these two tables.(try this on SSMS)? High level design for employee, tasks and timesheet scenario etc
Tell me something about yourself?
Conceptos básicos de sql y unix/linux.
What is scope_identity? What are analytical functions?
2 rounds of interview with one is tech and other is manager round. Both of them almost Easy to Mid level and manageable. 2 rounds of interview with one is tech and other is manager round. Both of them almost Easy to Mid level and manageable.
Questions on procedures, cursur , triggers, debugging
3.Write sql query for given statement.
questions about triggers and types of functions
Viewing 1541 - 1550 interview questions