Transact-SQL (T-SQL) MCQs (Chapterwise Multiple Choice Questions)

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

Answer & Explanation

Correct Answer: INNER

Note: This Question is unanswered, help us to find answer for this one

What is the result of this statement?

SELECT FLOOR(-1234.321)

-1234.3

-1234

-1235

1234.321

Answer & Explanation

Correct Answer: -1235

Note: This Question is unanswered, help us to find answer for this one

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

TRUNCATE FROM Products *;

DELETE FROM Products;

DELETE * FROM Products;

TRUNCATE TABLE Products;

Answer & Explanation

Correct Answer: DELETE FROM Products;

Note: This Question is unanswered, help us to find answer for this one

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 SerialNumer LIKE '%10_3'

WHERE SerialNumer LIKE ('%10'+'_'+'3')

WHERE SerialNumer LIKE '%10

WHERE SerialNumer LIKE '%10[_]3'

Answer & Explanation

Correct Answer: WHERE SerialNumer LIKE '%10_3'

Note: This Question is unanswered, help us to find answer for this one

Which is the best approach to update the last name and email address of a student with ID 56295?

UPDATE Students SET last_name='Smith', email = 'dsmith@rouxacademy.com' WHERE id='56295';

UPDATE Students SET last_name='Smith', email = 'dsmith@rouxacademy.com' WHERE id=56295;

UPDATE Students SET last_name='Smith' AND email = 'dsmith@rouxacademy.com' WHERE id=56295;

UPDATE Students SET last_name='Smith' AND email = 'dsmith@rouxacademy.com' WHERE id='56295';

Answer & Explanation

Correct Answer: UPDATE Students SET last_name='Smith', email = 'dsmith@rouxacademy.com' WHERE id=56295;

Note: This Question is unanswered, help us to find answer for this one

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

Joining operations

Linking operations

Criteria operations

Logical operations

Answer & Explanation

Correct Answer: Logical operations

Note: This Question is unanswered, help us to find answer for this one

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

DEDUPE

SELECT

MERGE

UNION

Answer & Explanation

Correct Answer: UNION

Note: This Question is unanswered, help us to find answer for this one

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

Only records that have corresponding entries in table1 and table2 are displayed.

No records from table1 are ever displayed.

All records from table1 are displayed, regardless of whether the records have a corresponding row in table2

Only records that have no corresponding records in table1 or table2 are displayed.

Answer & Explanation

Correct Answer: Only records that have corresponding entries in table1 and table2 are displayed.

Note: This Question is unanswered, help us to find answer for this one

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

TRUNCATE TABLE Students;

TRUNCATE * FROM Students;

DROP TABLE Students;

REMOVE * FROM Students;

Answer & Explanation

Correct Answer: TRUNCATE TABLE Students;

Note: This Question is unanswered, help us to find answer for this one

Which of these data types is an approximate numeric?

Real

Bit

Decimal

Numeric

Answer & Explanation

Correct Answer: Real

Note: This Question is unanswered, help us to find answer for this one

Transact-SQL (T-SQL) Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.