Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

SQL is an abbreviation for Standard Query Language.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

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

Question 5

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.

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The answer of To change the default font and font...

Question 10

To assign a name to the results of a function, follow the expression for the function with the word ____________________ and then the name to be assigned to the result.

Accepted Answer

The answer of To assign a name to the results...

Question 11

What three SQL sammands are available for updating databases?

Accepted Answer

The three sammands a

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The acsampanying figure shows a query result that is sorted by amount paid within book rep. To eliminate duplicate values in the results of a query, use the ____________________ operator.

Accepted Answer

The answer of   The acsampanying figure shows a...

Question 14

An employee at Bavant Publishing needs to create an additional SQL query. She needs to sort resards by current due within book rep number. Which clause should the employee use to sort the query output?

Accepted Answer

The answer of An employee at Bavant Publishing needs to...

Question 15

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

Accepted Answer

The answer of When you create a basic SELECT-FROM-WHERE expression...

Question 16

The default font size for queries is ____.

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

It is possible to place one query inside another. An inner query that is evaluated first is called a(n) ____________________.

Accepted Answer

The answer of It is possible to place one query...

Exam 10: Using Sql Question

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

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

SQL is an abbreviation for Standard Query Language.

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

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.

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

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

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.

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

To assign a name to the results of a function, follow the expression for the function with the word ____________________ and then the name to be assigned to the result.

What three SQL sammands are available for updating databases?

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

The acsampanying figure shows a query result that is sorted by amount paid within book rep. To eliminate duplicate values in the results of a query, use the ____________________ operator.

An employee at Bavant Publishing needs to create an additional SQL query. She needs to sort resards by current due within book rep number. Which clause should the employee use to sort the query output?

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

The default font size for queries is ____.

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

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

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

It is possible to place one query inside another. An inner query that is evaluated first is called a(n) ____________________.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters