Difference between Function and Procedure
Sql Data Analyst Interview Questions
2,216 sql data analyst interview questions shared by candidates
Conceptos básicos de sql y unix/linux.
Technical questions test
difference between udf and stored proc
What is scope_identity? What are analytical functions?
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
Explain Normalizations process and types
Just basic theoritical questions powerbi sql
Not any as I answered all technical questions. But experience with HR's was really horrible.
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.
Viewing 1531 - 1540 interview questions