Deck 8: Using SQL

Question 1

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

A) Home tab on the Ribbon
B) Create tab on the Ribbon
C) status bar
D) Quick Access Toolbar

Answer 1

D

Question 2

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

A) ORDER BY
B) SORT BY
C) PRIMARY SORT
D) SORT KEY

Answer 2

A

Question 3

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

A) JOIN
B) AND
C) OR
D) NOT

Answer 3

B

Question 4

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

A) System Q
B) System R
C) Command S
D) SEQUEL

Question 5

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

A) BETWEEN
B) AND
C) OR
D) NOT

Question 6

To create a SQL query, click Create on the Ribbon to display the Create tab and then click the ____ button to create a new query.

A) SQL Query
B) Design View
C) Query Design
D) Select Query

Question 7

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.

A) Font
B) Customize
C) Object Designers
D) Popular

Question 8

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

A) NAME
B) AS
C) ASSIGN
D) GIVING

Question 9

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

A) SIMILAR
B) PATTERN
C) AS
D) LIKE

Question 10

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

A) carat (^)
B) percent (%)
C) dollar ($)
D) number (#)

Question 11

The default font size for queries is _____.

A) 6
B) 8
C) 10
D) 12

Question 12

To display a blank window to begin typing SQL commands, click _____ on the View menu.

A) Command View
B) SQL Window
C) Blank Window
D) SQL View

Question 13

If a Security Warning appears when you open a database, click the ____ button.

A) Customize
B) Enable Content
C) Security Warning
D) Options

Question 14

There are two different versions for the "not equal to" comparison operator; and _____.

A) >!
B) @@
C) !=
D) &&

Question 15

To view the results of a SQL query, type the SQL statement and then click the _____ button to view the results.

A) Result
B) View
C) SQL
D) Execute

Question 16

To enter a new SQL query after viewing the results of a query, click the View button arrow and then click _____ on the View button menu.

A) Design View
B) SQL Grid
C) New Query
D) SQL View

Question 17

Less than ( ), and NOT (not equal to) are examples of _____.

A) compound conditions
B) comparison operators
C) conditions
D) compound values

Question 18

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

A) pound (#)
B) ampersand (&)
C) percent (%)
D) asterisk (*)

Question 19

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

A) plain
B) unary
C) simple
D) basic

Question 20

To begin creating a new SQL query, click the _____ button on the Create tab.

A) SQL
B) Query Design
C) Design View
D) More Queries

Question 21

To determine the number of clients assigned to a particular analyst, use the _____ aggregate function.

A) AVG
B) TOTAL
C) NUMBER
D) COUNT

Question 22

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

A) combine
B) concatenate
C) interleave
D) join

Question 23

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

A) UPDATE
B) SET
C) CHANGE
D) MODIFY

Question 24

To run a SQL query that adds records to a table, click the _____ button on the Design tab.

A) Add
B) Execute
C) Run
D) Update

Question 25

The accompanying figure shows a SQL query to join two tables. In the query, it is necessary to _____ the Business Analyst Number because it appears in more than one table.

A) restrict
B) moderate
C) qualify
D) assign

Question 26

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.

A) unique
B) cartesian
C) non-matching
D) outer

Question 27

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

A) WHERE
B) RESTRICT
C) HAVING
D) GROUP BY

Question 28

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

A) ADD INTO
B) APPEND
C) RECORD
D) INSERT INTO

Question 29

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

A) REVERSE
B) DOWN
C) DESC
D) TOP

Question 30

To create a query that groups all clients with the same analyst number, include the _____ clause in the SQL command.

A) GROUP BY
B) HAVING
C) GROUP AND SORT
D) ARRANGE BY

Question 31

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

A) UNIQUE
B) NO DUPLICATE
C) DISTINCT
D) UNIQUE VALUES

Question 32

The accompanying figure shows a SQL query to join 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.

A) matching values
B) inner
C) table-related
D) same

Question 33

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.

A) pseudonym
B) alias
C) variable
D) locus

Question 34

To quit Access, click the ____ button on the right side of the Access title bar.

A) Quit
B) Close
C) Stop
D) Exit

Question 35

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

A) Pass-Through
B) Prototype
C) Data Definition
D) Data Control

Question 36

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

A) Pass-Through
B) Prototype
C) Data Definition
D) Data Control

Question 37

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

A) Pass-Through
B) Join
C) Data Definition
D) Union

Question 38

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

A) ASSIGN
B) APPEND
C) VALUE
D) SET

Question 39

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

A) WITHIN
B) LIST
C) IN
D) BETWEEN

Question 40

To delete records in SQL, use the _____ command.

A) REMOVE FROM
B) DROP
C) DELETE FROM
D) UPDATE

Question 41

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

A)
B) &&
C) !=
D) #

Question 42

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

Question 43

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

Question 44

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 F
5.

Question 45

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

Question 46

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

Question 47

Modified Multiple Choice Computations in SQL can involve _____.

A) addition (+)
B) subtraction (-)
C) multiplication (*)
D) division (/)

Question 48

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

Question 49

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

Question 50

Modified Multiple Choice If data is to be sorted on two fields, the more important key is called the _____.

A) major sort key
B) first sort key
C) left sort key
D) primary sort key

Question 51

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

Question 52

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

Question 53

Modified Multiple Choice The comparison operators for use in SQL are _____.

A) >=
B) <=
C) <
D) >

Question 54

Modified Multiple Choice Compound criteria are formed by connecting two or more simple criteria using _____.

A) BETWEEN
B) AND
C) OR
D) NOT

Question 55

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

Question 56

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.

Question 57

SQL is a non-standardized language.

Question 58

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

Question 59

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.

Question 60

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

Question 61

To change the default font and/or font size for queries, click the Options button in the Backstage view and then click ____________________ in the Access Options dialog box.

Question 62

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

Question 63

SQL is an abbreviation for Standard Query Language.

Question 64

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

Question 65

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.

Question 66

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

Question 67

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.

Question 68

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

Question 69

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

Question 70

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

Question 71

To change the default font and font size for datasheets, use the ____________________ dialog box.

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

The INSIDE operator is an alternative to an OR criterion.

Question 80

To create a SQL query that does not involve an exact match, use the ____________________ operator.