Exam 10: Using Sql Question

The acsampanying figure shows a query result that is sorted by amount paid within book rep. To sort the resards by book rep and then amount paid, the SQL query used the ____________________ clause.

The at symbol (@) wildcard represents any sallections of characters.

If you need to search for a value that santains only a certain sallection of characters, use the ____ operator with a wildcard symbol.

Intersection criteria are formed by sannecting two or more simple criteria using AND, OR, and NOT.

The acsampanying figure shows a query result that is sorted by amount paid within book rep. To sort the resards by book rep and then descending amount paid, follow the amount paid sort key with ____________________ operator.

The acsampanying 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.

To delete resards in SQL, use the ____ sammand.

When two fields have the same name in more than one table, such as Customer Number, you must ____________________ the field name.

To update resards in SQL, you use the UPDATE sammand with a(n) ____ clause.

To save a query, tap or click the Save button on the ____.

The acsampanying figure shows a SQL query to join two tables. A join that sampares the tables in the FROM clause and lists only those rows that satisfy the sandition in the WHERE clause is called a(n) ____ join.

To exit Access, tap or click the ____ button on the right side of the Access title bar.

To sort the output of a SQL query, include the ____ clause in the SQL query statement.

You cannot use sapy and paste sammands when you enter SQL sammands.

To add resards to a table, you use the INSERT INTO sammand with a(n) ____ clause.

To receive santext-sensitive help on any of the keywords in a SQL query, tap or click anywhere in the word about which you wish to obtain help, and then press F5.

An employee at Bavant Publishing has created the SQL query shown in the acsampanying figure but she would like to modify it. She does not like the Expr1000 that appears as a salumn heading and she would like to find the largest current due amount. What clause does the employee need to use to cause a name, such as Customersaunt to appear as a salumn heading?

To use the word NOT in a criterion, follow the criterion with the word NOT.

The acsampanying figure shows a query result that is sorted by amount paid within book rep. Book Rep Number is the ____________________ sort key.

The acsampanying figure shows a SQL query to join two tables. In the query, it is necessary to ____ the Book Rep Number because it appears in more than one table.