ISPFL6 - Quiz 2

What is the purpose of SQL Aliases?

• To combine two tables.

• To rename a table or a column temporarily.

• To delete a table.

• To create a new database.

Which SQL keyword is used to combine rows from two or more tables?

• SELECT

• JOIN

• DELETE

• UPDATE

What does the SQL INNER JOIN clause do?

• Combines rows from two or more tables and returns only matching rows.

• Combines all rows from two tables.

• Deletes rows from two or more tables.

• Updates rows from two or more tables.

Which JOIN returns all rows from the left table and matched rows from the right table?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL OUTER JOIN

What does the RIGHT JOIN keyword do?

• Returns all rows from the left table and matched rows from the right table.

• Returns only matching rows from both tables.

• Returns all rows from the right table and matched rows from the left table.

• Returns all rows from both tables.

Which keyword returns all rows when there is a match in one of the tables?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL OUTER JOIN

What is a Self Join in SQL?

• A join of a table with itself.

• A join of a table with another table.

• A join that deletes records.

• A join that updates records.

What is the purpose of the SQL UNION operator?

• To combine the results of two or more SELECT statements.

• To create a new database.

• To delete a table.

• To update records in a table.

Which statement is used to group rows that have the same values in specified columns?

• SELECT

• GROUP BY

• ORDER BY

• JOIN

Which SQL statement is used to create a new database?

• CREATE TABLE

• CREATE DATABASE

• CREATE INDEX

• CREATE VIEW