Exam 8: Using SQL

When simple criteria are connected by the word OR, all the simple criteria must be true in order for the compound criterion to be true.

The accompanying figure shows a query result that is sorted by amount paid within business analyst. Business Analyst Number is the ____________________ sort key.

To restrict groups that appear in a SQL query, use the _____ clause.

If a criterion in a SQL query uses a date, enclose the value between _____ signs.

To use or interface with SQL Server requires knowledge of SQL.

You can change the font size for queries but not for datasheets.

SQL has built-in functions, also called aggregate functions, to calculate the number of entries, the sum or average of all entries in a given column, and the largest or smallest of the entries in a given column.

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

Modified Multiple Choice Computations in SQL can involve _____.

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.

Critical Thinking Questions Case 7-1 An employee at Camashaly Design has created the SQL query shown in the accompanying figure but she would like to modify it. She does not like the Expr1000 that appears as a column heading and she would like to find the client with the largest current due. What function should the employee use to determine the largest current due?

To use grouping in a SQL query, include a(n) ____________________ clause in the SQL command.

When you create a basic SELECT-FROM-WHERE expression in SQL, a list of ____________________(s) follows the word SELECT.

When simple criteria are connected by the word AND, all the simple criteria must be true in order for the compound criterion to be true.

Oracle and SQL Server use the percent sign (%) as a wildcard to represent any collection of characters.

Microsoft Access does not allow spaces within table names and field names.

Critical Thinking Questions Case 7-2 An employee at Camashaly Design needs to create an additional SQL query. She needs to sort records by current due within business analyst number. How can she ensure that no duplicate records appear in the query result?

The question mark (?) wildcard represents any collections of characters.