T-SQL Test

Which answer is NOT a type of table index?

HEAP

UNIQUE

NONCLUSTERED

HASH

The keywords AND, IN, LIKE, and BETWEEN all belong to a category called _____.

LINKING OPERATIONS

JOINING OPERATIONS

CRITERIA OPERATORS

LOGICAL OPERATORS

What is an example of a DDL command in SQL?

DROP

MERGE

TRUNCATE TABLE

DELETE

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

What is the result of this statement? SELECT FLOOR(-1234.321)

-1234.3

-1234

-1235

1234.321

Which of these data types is an approximate numeric?

DECIMAL

BIT

REAL

NUMERIC

You need to remove all data from a table name Products. Which query fully logs the removal of each record?

TRUNCATE TABLE PRODUCTS;

TRUNCATE FROM PRODUCTS *;

DELETE FROM PRODUCTS;

DELETE * FROM PRODUCTS;

What is the result of the following query? SELECT 1 / 2 AS Result;

2

0

0.5

ERROR

Which data type will most efficiently store a person's age in years?

INT

TINYINT

BIGINT

FLOAT

What is the result of this query? SELECT 'abc\ def' AS Result;

ABC\DEF

ABC DEF

ERROR

ABCDEF

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;

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

When no join type between multiple tables in a query's FROM clause is specified, what type of join is assumed?

INNER

RIGHT

LEFT

FULL

How many bytes of storage does the int data type consume?

1 BYTE

8 BYTES

2 BYTES

4 BYTES

What does a RIGHT JOIN ensure?

THAT RECORDS FROM THE RIGHTMOST TABLE WILL BE DISPLAYED ONLY IF THE RECORDS HAVE A CORRESPONDING VALUE IN THE LEFTMOST TABLE

THAT NO RECORDS FROM THE RIGHTMOST TABLE ARE DISPLAYED IF THE RECORDS DON'T HAVE CORRESPONDING RECORDS IN THE LEFT TABLE

THAT ONLY RECORDS FROM THE RIGHTMOST TABLE WILL BE DISPLAYED

THAT ALL RECORDS FROM THE RIGHTMOST TABLE ARE REPRESENTED IN THE RESULT, EVEN IF THERE ARE NO CORRESPONDING RECORDS IN THE LEFT TABLE

What are the keywords called that are used by the database engine in SQL commands, and should not be used as identifiers and object names in your scripts?

RESTRICTED

EXCLUSIVE

FORBIDDEN

RESERVED

You would like to have a record added to a TableB every time a record is modified in TableA. What technique should you look at implementing?

YOU SHOULD CREATE A DML TRIGGER ON THE SERVER.

YOU SHOULD CREATE A DML TRIGGER ON TABLEB.

YOU SHOULD CREATE A DML TRIGGER ON TABLEA.

YOU SHOULD CREATE A DDL TRIGGER ON THE DATABASE.

Which data type should you choose when you need to store dates and times that include time zone information?

DATETIMEOFFSET

DATETIME2

DATETIME

SMALLDATETIME

What is an example of a DML command in SQL?

CREATE

ALTER

INSERT

DROP

In a SELECT statement, which clause should always be used with the TOP clause in order to predictably indicate which rows are affected by TOP?

HAVING

WHERE

ORDER BY

GROUP BY

What is the result of this query? SELECT '123'+'123' AS Result;

246

123123

'123''123'

ERROR

On Wednesday, April 18, what will this function display? SELECT DAY(GETDATE()-1)

19

17

18

ERROR

To remove all of the content from the Students table but keep the schema, which statement should you use?

REMOVE * FROM STUDENTS;

TRUNCATE * FROM STUDENTS;

TRUNCATE TABLE STUDENTS;

DROP TABLE STUDENTS;

What is the result of an INNER JOIN between table1 and table2?

ALL RECORDS FROM TABLE1 ARE DISPLAYED, REGARDLESS OF WHETHER THE RECORDS HAVE A CORRESPONDING ROW IN TABLE2.

NO RECORDS FROM TABLE1 ARE EVER DISPLAYED.

ONLY RECORDS THAT HAVE NO CORRESPONDING RECORDS IN TABLE1 OR TABLE2 ARE DISPLAYED.

ONLY RECORDS THAT HAVE CORRESPONDING ENTRIES IN TABLE1 AND TABLE2 ARE DISPLAYED.

To combine the results of two or more SELECT statements, removing duplicates, which keyword can you use?

DEDUPE

SELECT

MERGE

UNION

What role does "inventory" play? select bookid, boooktitle, bookauthor,quantityonhand from inventory.books;

YOU ONLY WANT TO SEE RESULTS FROM BOOKS CURRENTLY IN INVENTORY

IT INSTRUCTS THE QUERY ENGINE TO FIND THE BOOKS TABLE IN THE INVENTORY SCHEMA

IT INSTRUCTS THE QUERY ENGINE TO FIND THE BOOKS TABLE IN THE INVENTORY DATABASE

IT INSTRUCTS THE QUERY ENGINE TO JOIN THE BOOKS TABLE TO THE INVENTORY SCHEMA

Your Name: (required)
Your Email: (required)
Skype Username:
Exams you want to pass:

Exam Type:	T-SQL MCQ Skill Test
Questions Type:	Multiple Choice Questions
Total Questions:	26
Time Limit:	30 Minutes
Last Update	June, 2025

Pass T-SQL Exam

T-SQL Quiz

Which answer is NOT a type of table index?

The keywords AND, IN, LIKE, and BETWEEN all belong to a category called _____.

What is an example of a DDL command in SQL?

Which answer is a possible result of the sequence of commands below? DECLARE @UniqueID uniqueidentifier = NEWID(); SELECT @UniqueID AS Result;

What is the result of this statement? SELECT FLOOR(-1234.321)

Which of these data types is an approximate numeric?

You need to remove all data from a table name Products. Which query fully logs the removal of each record?

What is the result of the following query? SELECT 1 / 2 AS Result;

Which data type will most efficiently store a person's age in years?

What is the result of this query? SELECT 'abc\ def' AS Result;

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

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

When no join type between multiple tables in a query's FROM clause is specified, what type of join is assumed?

How many bytes of storage does the int data type consume?

What does a RIGHT JOIN ensure?

What are the keywords called that are used by the database engine in SQL commands, and should not be used as identifiers and object names in your scripts?

You would like to have a record added to a TableB every time a record is modified in TableA. What technique should you look at implementing?

Which data type should you choose when you need to store dates and times that include time zone information?

What is an example of a DML command in SQL?

In a SELECT statement, which clause should always be used with the TOP clause in order to predictably indicate which rows are affected by TOP?

What is the result of this query? SELECT '123'+'123' AS Result;

On Wednesday, April 18, what will this function display? SELECT DAY(GETDATE()-1)

To remove all of the content from the Students table but keep the schema, which statement should you use?

What is the result of an INNER JOIN between table1 and table2?

To combine the results of two or more SELECT statements, removing duplicates, which keyword can you use?

What role does "inventory" play? select bookid, boooktitle, bookauthor,quantityonhand from inventory.books;

T-SQL Test Explained