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