T-SQL Online Test

Topics covered

• Nested Cursors: Our T-SQL online test helps recruiters to assess candidates' knowledge about nested cursors which is a loop in another loop in a SQL server  
• Top Filters: This test assesses candidates' ability of working with TOP filters which is a commonly used construct in SQL  
• JOIN: iMocha’s T-SQL pre-employment test evaluates candidates understanding about JOIN clause which combine and retrieve data from two or more tables  
• MERGE: This test helps recruiters to evaluate candidate’s ability to use MERGE statement to INSERT new record or UPDATE existing records within same statement  
• Pivot Table: Our test evaluates candidates' understanding about using pivot table to summarize data where rows data is converted into column data to get simplified view of table  
• Loops: This test helps recruiters and hiring managers to evaluate candidate’s knowledge about Loops statements in SQL which is a series of statements executed repeatedly 
• Common Table Expressions: Our T-SQL assessment test evaluates candidates' knowledge about common table expressions (CTE) which is a named temporary result set that can referenced within statements such as SELECT
• INSERT
• UPDATE
• or DELETE 

• Test Duration: 20 minutes
• No. of Questions: 10