Deck 10: Using Sql Question

Question 1

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

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

Answer 1

B

Question 2

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

A) Save Query As
B) Save
C) Save Database As
D) Save Object As

Answer 2

D

Question 3

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

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

Answer 3

C

Question 4

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

Question 5

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

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

Question 6

The default font size for queries is ____.

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

Question 7

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

A) sampound sanditions
B) samparison operators
C) sanditions
D) sampound values

Question 8

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

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

Question 9

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

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

Question 10

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

A) sammand View
B) SQL sammands
C) Blank Window
D) SQL View

Question 11

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

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

Question 12

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

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

Question 13

To save a query, tap or 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

Question 14

When simple criteria are sannected by the word ____, all the simple criteria must be true in order for the sampound criterion to be true.

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

Question 15

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

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

Question 16

To name a samputed field, follow the samputation with the word ____ and then the name you wish to assign to the field.

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

Question 17

When simple criteria are sannected by the word ____, the sampound criterion will be true whenever any of the simple criteria are true.

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

Question 18

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

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

Question 19

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

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

Question 20

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

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

Question 21

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

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

Question 22

The ____ query enables you to send SQL sammands directly to ODBC (Open Database sannectivity) databases.

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

Question 23

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

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

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

Question 25

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.

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

Question 26

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.

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

Question 27

To run a SQL query that adds resards to a table, tap or click the ____ button on the QUERY TOOLS DESIGN tab.

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

Question 28

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

A) IN
B) BETWEEN
C) LIKE
D) RANGE

Question 29

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

A) sambine
B) sancatenate
C) interleave
D) join

Question 30

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 santrol

Question 31

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

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

Question 32

To create a query that groups all customers with the same rep number, include the ____ clause in the SQL sammand.

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

Question 33

To add resards to a table, use the SQL ____ sammand.

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

Question 34

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

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

Question 35

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.

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

Question 36

To determine the number of customers assigned to a particular book rep, use the ____ aggregate function.

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

Question 37

To delete resards in SQL, use the ____ sammand.

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

Question 38

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

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

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 add resards to a table, you use the INSERT INTO sammand with a(n) ____ clause.

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

Question 41

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

A) single quotation marks
B) ampersands
C) double quotation marks
D) percent symbols

Question 42

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

Question 43

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

Question 44

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

Question 45

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 46

SQL is a non-standardized language.

Question 47

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

Question 48

Using or interfacing with SQL Server requires knowledge of SQL.

Question 49

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

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

Modified Multiple Choice The samparison operators for use in SQL are ____.

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

Question 52

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.

Question 53

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

Question 54

Modified Multiple Choice samputations in SQL can involve ____.

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

Question 55

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

Question 56

Because it is a sammon sanvention, and necessary in some version of SQL, place a semisalon (;) at the end of each SQL sammand.

Question 57

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

Question 58

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

Question 59

Modified Multiple Choice sampound criteria are formed by sannecting two or more simple criteria using ____.

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

Question 60

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

Question 61

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

Question 62

Queries that you sanstruct 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 63

SQL is an abbreviation for Standard Query Language.

Question 64

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

Question 65

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

Question 66

The INSIDE operator is an alternative to an OR criterion.

Question 67

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 68

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

Question 69

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

Question 70

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

Question 71

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 salumn, and the largest or smallest of the entries in a given salumn.

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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