Exam 8: Using SQL

The accompanying figure shows a SQL query to join two tables. When tables appear in the FROM clause, you can give each table a(n) _____, or an alternative name, that you can use in the rest of the statement.

When a query does not involve an exact match, use the PATTERN operator with a wildcard symbol.

The accompanying figure shows a query result that is sorted by amount paid within business analyst. To eliminate duplicate values in the results of a query, use the ____________________ operator.

To add records to a table, you use the INSERT INTO command with a(n) _____ clause.

The accompanying figure shows a SQL query to join two tables. A join that would list all the rows from one of the tables in a join, regardless of whether they match any rows in the other table, is called a(n) _____ join.

The default font size for queries is _____.

The accompanying figure shows a query result that is sorted by amount paid within business analyst. To sort the records by business analyst and then descending amount paid, follow the amount paid sort key with ____________________ operator.

Modified Multiple Choice The possible versions of the "not equal to" operator are _____.

What three SQL commands are available for updating databases?