NEW
Font size
WorksheetsCS10337 - Lecture #4
Total questions: 10
Worksheet time: 2mins
Which clause removes duplicate rows from a result set?
WHERE
UNIQUE
DISTINCT
. GROUP BY
Which operator is used to search for a pattern in text columns?
IN
LIKE
BETWEEN
MATCH
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
Which character returns all the data found in a table?
%
#
*
/
If you were wanting to filter data, which clause would you use?
Where
Order by
From
Select
Which join returns only rows with matching values in both tables?
LEFT JOIN
RIGHT JOIN
INNER JOIN
CROSS JOIN
A LEFT JOIN returns:
All rows from the right table only
nly rows with matches in both tables
All rows from the left table and matches from the right
A Cartesian product of both tables
Which keyword can be used instead of ON when both tables share the same column name?
USING
NATURAL
WHERE
MATCHING
Which type of join returns every possible combination of rows from two tables?
FULL OUTER JOIN
CROSS JOIN
NATURAL JOIN
RIGHT JOIN
A NATURAL JOIN automatically:
Uses all columns with the same name in both tables
Requires you to specify join columns explicitly
Returns unmatched rows as NULLs
Performs a union instead of a join
