LinkedIn Transact-SQL (T-SQL)

T-SQL linkedin skill assessment

What is the result of this query?

SELECT 'abc\

def' AS Result; 

• abc\def
• abc def
• error
• abcdef

Transact-SQL (T-SQL) assessment linkedin

What result is returned after executing the following commands?

DECLARE @TestValue int;

SET @TestValue = 1;

SELECT @TestValue;

GO 

• 1
• null
• @TestValue
• error

linkedin T-SQL assessment

Which statement creates a new database schema named Sales and establish Sharon as the owner?

• CREATE SCHEMA Sales AUTHORIZATION Sharon;
• ALTER USER Sharon WITH DEFAULT_SCHEMA = Sales;
• ALTER USER Sharon SET SCHEMA Sales;
• CREATE SCHEMA Sales SET OWNER Sharon;

linkedin learning T-SQL

The result of a CROSS JOIN between a table with 4 rows, and one with 5 rows, will give a result with _____ rows.?

• 20
• 9
• 4
• 1024

T-SQL Quiz linkedin

You need to write a query that returns all products that have a SerialNumber ending with "10_3". Which WHERE clause should you use to fill in the blank in this query?

SELECT ProductID, ProductName, SerialNumber  

FROM Products  

_____ ;

• WHERE SerialNumber LIKE '[_]3'
• WHERE SerialNumber LIKE '"_"3'
• WHERE SerialNumber LIKE (''+'_'+'3')
• WHERE SerialNumber LIKE '_3'

   linkedin T-SQL Quiz

   T-SQL linkedin assessment