Ch 10/11 Test Questions

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

False

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

False - Compound

The INSIDE clause is an alternative to an OR criterion. ________________

False - IN, in

SQL is an abbreviation for Standard Query Language. ____________________

False - Structured

To change the font size for SQL queries, click FILE on the ribbon, click Options in the Backstage view, and then click ____ in the Access Options dialog box.

C. Object Designers

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

False

If a criterion involves a text field, the value must be enclosed in curly braces { }.

False

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

False

SQL has special format rules for placement of terms and capitalization.

False

The UNIQUE operator eliminates duplicate values in the results of a query.

False

22. To create a query that groups all accounts with the same account manager number, include the ____ clause in the SQL command.

A. GROUP BY

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

A. ORDER BY

30. The ____ query enables you to send SQL commands directly to ODBC (Open Database Connectivity) databases.

A. Pass-Through

If data is to be sorted on two fields, the more important key is called the ____.

A. major sort key D. primary key sort

In SQL queries, you can enclose text field values in ____.

A. single quotation marks C. double quotation marks

The comparison operators for use in SQL are ____.

ALL OF THE ABOVE

Computations in SQL can involve ____.

All of the above

The default font size for queries is ____.

B. 8

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

B. AND

Compound criteria are formed by connecting two or more simple criteria using ____.

B. AND C. OR D. NOT

17. To name a computed field, follow the computation with the word ____ and then the name you wish to assign to the field.

B. AS

33. The ____ operator allows you to search for a range of values in one field.

B. BETWEEN

13. Less than (<), greater than (>), and NOT (not equal to) are examples of ____.

B. Comparison Operators

To change the default font and font size for datasheets, click ____ in the Access Options dialog box.

B. Datasheet

5. To begin creating a new SQL query, click the ____ button on the CREATE tab.

B. Query Design

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

B. SET

7. To view the results of a SQL query, type the SQL statement and then click the ____ button on QUERY TOOLS DESIGN tab to view the results.

B. View

27. A SQL query to joins 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.

B. alias

26. A SQL query to joins two tables. A join that compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause is called a(n) ____ join.

B. inner

20. The ____ operator eliminates duplicate values in the results of a query.

C. DISTINCT

31. The ____ query allows you to create or alter database tables or create indexes in Access directly.

C. Data Definition

To delete records in SQL, use the ____ command.

C. DELETE FROM

19. To sort data in descending order, follow a sort key with the word ____.

C. DESC

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

C. HAVING

32. You can use a(n) ____ clause with a list as an alternative to an OR criterion when the OR criterion involves a single field.

C. IN

What function should the employee use to determine the largest current due amount?

C. MAX

15. When simple criteria are connected by the word ____, the compound criterion will be true whenever any of the simple criteria are true.

C. OR

12. A ____ criterion has the form: field name, comparison operator, then either another field name or a value.

C. Simple

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

C. VALUED

25. A SQL query to joins two tables. In the query, it is necessary to ____ the Account Manager Number because it appears in more than one table.

C. qualify

21. To determine the number of customers assigned to a particular account manager, use the ____ aggregate function.

D. COUNT

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

D. LIKE

To add records to a table, use the SQL ____ command.

D. INSERT INTO

Which clause should the employee use to sort the query output?

D. Order by

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

D. Quick Access Toolbar

SQL was developed under the name ____ at the IBM San Jose research facilities.

D. SEQUEL

6. To display a blank window to begin typing SQL commands, click ____ on the View menu in the Query Design window.

D. SQL View

9. To enter a new SQL query after viewing the results of a query, click the View arrow on the HOME tab and then click ____ on the View menu.

D. SQL view

11. To save a query with a new name, display the Save As tab in Backstage view, and click ____ in the File Types area of the Save As gallery.

D. Save Object As

29. The ____ query combines fields from more than one table into one query set.

D. UNION

10. To include all fields in a SQL query, use the ____ symbol after the word SELECT.

D. asterisk (*)

24. Use a query to ____ tables; that is, to find records in two tables that have identical values in matching fields.

D. join

28. A SQL query to joins 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.

D. outer

Queries that you construct in both Design view and SQL view require that the major sort key is to the left of the minor sort key in the list of fields to be included.

FALSE

SQL is a non-standardized language.

FALSE

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

FALSE

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

FALSE

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.

FALSE

You cannot use copy and paste commands when you enter SQL commands.

FALSE

If a criterion involves a text field, the value must be enclosed in quotation marks.

TRUE

The question mark (?) wildcard represents any individual character.

TRUE

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.

TRUE

When simple criteria involve a numeric field, you type only the number, not commas or dollar signs

TRUE

Because it is a common convention, and necessary in some version of SQL, place a semicolon (;) at the end of each SQL command.

True

If you want to list all the rows in the tables, you do not need to include the word WHERE in a SQL statement.

True

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

True

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. ____________________

True

To assign a name to a calculation, follow the calculation with the word AS and then the name to be assigned to the result.

True

To save a query, click the Save button on the Quick Access Toolbar.

True

To sort in descending order, follow the name of the sort key with the DESC operator.

True

To sort output in a SQL statement, use the ORDER BY clause.

True

Using or interfacing with SQL Server requires knowledge of SQL.

True

When a name containing a space appears in SQL, it must be enclosed in square brackets. ____________________

True

How can she ensure that no duplicate records appear in the query result?

a. Include the DISTINCT operator in the SQL command operator in the SQL command.

What clause does the employee need to use to cause a name, such as AccountCount to appear as a column heading?

b. AS