T-SQL quiz medium level

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

1

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?

Non-clustered indexes are not possible to be created on temporary tables.

Indexes are not possible to be created on temporary tables.

Use this command:

CREATE NONCLUSTERED INDEX index_name ON #temp (UserId,CompanyID);

Use this command:

CREATE PRIMARY INDEX ix_tempIndexUsrPrg ON #temp AS (UserId,CompanyID);