Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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.

Accepted Answer

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

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

The samparison operators for use in SQL are ____.

Accepted Answer

A)  >= 
B)   
A)  >= 
B)

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

To restrict the groups that appear in a query result use the ____________________ clause followed by a criterion.

Accepted Answer

The answer of To restrict the groups that appear in...

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

The ____________________ wildcard represents any individual character.

Accepted Answer

The answer of The ____________________ wildcard represents any individual character....

Exam 10: Using Sql Question

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

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

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

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

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.

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.

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

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

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

The samparison operators for use in SQL are ____.

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

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

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

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

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

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

To restrict the groups that appear in a query result use the ____________________ clause followed by a criterion.

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

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

The ____________________ wildcard represents any individual character.

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