LinkedIn Transact-SQL (T-SQL)

   Transact-SQL (T-SQL) assessment linkedin

Which answer is NOT a type of table index?

• heap
• unique
• nonclustered
• hash

T-SQL Quiz linkedin

The keywords AND, IN, LIKE, and BETWEEN all belong to a category called what?

• linking operations
• joining operations
• criteria operators
• logical operators

T-SQL linkedin assessment

What is the result of this series of statements?

BEGIN TRY

   SELECT 'Foo' AS Result;

END TRY

BEGIN CATCH

   SELECT 'Bar' AS Result; 

END CATCH;

• FooBar
• Foo
• Bar
• Foo Bar

T-SQL linkedin skill assessment

What is an example of a DDL command in SQL?

• DROP
• MERGE
• TRUNCATE TABLE
• DELETE

linkedin T-SQL Quiz

Which answer is a possible result of the sequence of commands below?

DECLARE @UniqueID uniqueidentifier = NEWID();  

SELECT @UniqueID AS Result;

• bb261196-66a5-43af-815d-123fc593cf3a
• 0x24000001155F04846674AD4590F832C0
• 1
• z350mpj1-62lx-40ww-9ho0-4u1875rt2mx4

   linkedin T-SQL assessment

   linkedin learning T-SQL