MSSQL Coding Test

Topics covered

• Select Queries: iMocha’s MS SQL coding test helps recruiters and hiring managers to evaluate candidate's ability to use select query which returns result set from any table of the database 
• Joins: Our assessment evaluates candidate’s ability to use Join statements which combines data from two or more tables 
• Aggregate Functions: This test checks candidate’s understanding about aggregate function in SQL which performs calculations on multiple values and returns a single value 
• Group By: This test evaluates a candidate’s knowledge about Group By statement which is used to get the summary data based on one or more groups 
• Sub-Queries: Our test assesses applicants' understanding about subqueries used in SQL which can be defined as query under a query  
• Where Condition: Our assessment validates candidate’s knowledge about where clause which is conditional statement used to extract only records that meets a specified condition 
• Replace Function: This test evaluates candidate’s understanding about REPLACE() function which replaces all occurrences of a substring within a string
• with a new substring 
• Cases: Our assessment evaluates candidate’s understanding about Cases statement which returns a value when it goes through a condition 

• Test Duration: 15 minutes
• No. of Questions: 3