How would you design a rest service
Server Engineer Interview Questions
389 server engineer interview questions shared by candidates
http, tcp, database, binary search, stacks and heaps.
raid, hot swap, server, work station
Technical questions to judge your skills and knowledge about the domain.
Temporal Tables, CDC, CTE & Recursive CTE, Rank vs Dense_rank, Lead & Lag, INDEXSCAN vs INDEXSEEK, Nested Hash vs Merge Joins, Merge statement and few basic SQL Query questions.
1. Self introduction 2. Elaborate on previous working experience 3. Test strategies under different kind of scenarios
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
Java application and move it the rest services
Some SQL Performance bottleneck questions
Write a web API
Viewing 281 - 290 interview questions