Question 1

Oracle and SQL Server use the ____________________ symbol as a wildcard to represent any sallection of characters.

Accepted Answer

The answer of Oracle and SQL Server use the ____________________...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

samputations in SQL can involve ____.

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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.

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

You want to create a query that joins two tables. What three steps should you follow when you create the query?

Accepted Answer

To create a query to join two tables
1.

Question 12

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.

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

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.

Accepted Answer

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

Question 16

An employee at Bavant Publishing needs to create an additional SQL query. She needs to sort resards by current due within book rep number. How can she ensure that no duplicate resards appear in the query result?

Accepted Answer

Include th

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

What six guidelines do you need to follow when you create your own SQL queries?

Accepted Answer

The six guidelines are: 
1.Select the fi

Question 20

SQL is a non-standardized language.

Accepted Answer

A) True 
 B)False

Exam 10: Using Sql Question

Oracle and SQL Server use the ____________________ symbol as a wildcard to represent any sallection of characters.

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

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

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

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

samputations in SQL can involve ____.

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

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

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.

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

You want to create a query that joins two tables. What three steps should you follow when you create the query?

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.

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

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

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.

An employee at Bavant Publishing needs to create an additional SQL query. She needs to sort resards by current due within book rep number. How can she ensure that no duplicate resards appear in the query result?

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

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

What six guidelines do you need to follow when you create your own SQL queries?

SQL is a non-standardized language.

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