Transact-SQL (T-SQL) Test

Exam Type: MCQ Skill Test
Questions Type: Multiple Choice Questions
Total Questions: 40
Time Limit: 15 Minutes
Last Update April, 2025

Text Detail

   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

 

© 2025 Skill Test Answer. All Rights Reserved