How will you monitor sql server? Tell me some of the tools
Sql Data Analyst Interview Questions
2,214 sql data analyst interview questions shared by candidates
The ask me information about my experience and expectations.
Sql tuning
Architect a redundant SQL Server environment
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
Difference between where and having Diff b/w group by and windows function Error Handling In SP Trigger Function Diff between SP and Function Windows function Odd rows in 50 empid Inner join two tables with nulls
Asked for basics like backups recovery model and HA DR feature and System DB
What is RDBMS and DBMS?
Preguntas diversas sobre mi experiencia y sobre desarrollo de queries en SQL, además de algunas preguntas de acertijos.
Conceptos básicos de sql y unix/linux.
Viewing 1511 - 1520 interview questions