ITSE 1346 Ch3A

Question 1

What type of JOIN returns only matching records from both tables?

Accepted Answer

NNER JOIN

Question 2

hat keyword is used to retrieve unique values?

Accepted Answer

DISTINCT

Question 3

Which SQL query retrieves employees hired between 2000 and 2020?

Accepted Answer

WHERE HireDate BETWEEN '2000-01-01' AND '2020-01-01'

Question 4

Which SQL statement retrieves all records from two tables even if no matches exist?

Accepted Answer

FULL JOIN

Question 5

What does the IN operator do in SQL?

Accepted Answer

Selects rows that match a specified list of values

Question 6

Which SQL operator allows pattern matching using % and _?

Accepted Answer

LIKE

Question 7

What is the output of SELECT ABS(-5);?

Accepted Answer

5

Question 8

Which function converts a string to lowercase?

Accepted Answer

LOWER()

Question 9

Which function calculates the total of a numeric column?

Accepted Answer

SUM()

Question 10

What does SELECT CONCAT('SQL', ' Query'); return?

Accepted Answer

SQL Query

Question 11

Which SQL clause filters records based on a specified range of values?

Accepted Answer

BETWEEN

Question 12

Which function rounds a number to a specified number of decimal places?

Accepted Answer

ROUND()

Questions 12