Which SQL join returns only the matching rows from both tables?

INNER JOIN

Fill in the blank: The SQL command used to delete objects from the database is ______.

DROP

True or False: LEFT JOIN and LEFT OUTER JOIN are different operations in SQL.

False. LEFT JOIN is the same as LEFT OUTER JOIN.

Riddle: I merge data from two tables, showing all rows from one side, with NULLs where I cannot find a match. What am I?

LEFT JOIN

What SQL command is used to group the results based on one or more attributes?

GROUP BY

Fill in the blank: A ______ is a user-created object in a database that generates unique integers.

Sequence

True or False: The HAVING clause can be used with aggregate functions in SQL.

True

Which SQL command is used to retrieve data from a database?

SELECT

Fill in the blank: The SQL command to modify existing data in a table is ______.

UPDATE

Riddle: I allow you to create a virtual table from one or more tables, but hold no data of my own. What am I?

View