Test description

This test checks the knowledge of developers who are up-to-date with T-SQL features at a medium level.
Topics: temporary tables, stored procedures, user defined functions, Common Table Expression (CTE), specific T-SQL functions and syntax, table and fields creation, transactions isolation levels.

Sample questions

Having a local temporary table created inside a stored procedure scope with the following content:

What SQL Command should be used to create a non-clustered index based on UserId, CompanyId?