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

Accepted Answer

The Save button is typically found on the Quick Access Toolbar in many software applications, including database management systems.

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

Accepted Answer

The correct clause to sort the output of a SQL query is "ORDER BY". This clause can be used to specify one or more columns on which the output should be sorted, as well as the order (ascending or descending) in which the sort should be done. The other options (B, C, and D) are not valid clauses for sorting output in SQL.

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

Accepted Answer

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

Accepted Answer

SQL was originally developed under the name SEQUEL (Structured English Query Language) at the IBM San Jose research facilities.

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

Accepted Answer

The word "OR" is used to connect simple criteria in such a way that the compound criterion is true if any of the individual criteria are true.

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

Accepted Answer

The "Query Design" button is used to create a new query in SQL by opening the query design view.

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

Accepted Answer

In the Access Options dialog box, the "Object Designers" section allows you to change settings related to the design of database objects, including font size for SQL queries.

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

Accepted Answer

The correct answer is B: AS. In SQL, the AS keyword is used to assign a name to a computed field.

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

Accepted Answer

The LIKE operator is used in SQL to search for a specified pattern in a column, often using wildcard symbols like '%' or '_'.

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 (#)

Accepted Answer

In SQL, when using a date in a criterion, the date value is typically enclosed between number signs (#) to indicate it is a date literal.

Question 11

The default font size for queries is _____.
A) 6
B) 8
C) 10
D) 12

Accepted Answer

The answer of The default font size for queries is...

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

Accepted Answer

The answer of To display a blank window to begin...

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

Accepted Answer

When a Security Warning appears when you open a database, you should click the "Enable Content" button to allow the database to run.

Question 14

There are two different versions for the "not equal to" comparison operator; and _____.
A) >!
B) @@
C) !=
D) &&

Accepted Answer

!= is the "not equal to" comparison operator.

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

Accepted Answer

The answer of To view the results of a SQL...

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

Accepted Answer

SQL View is the option that allows you to enter a new SQL query after viewing the results of a previous query.

Question 17

Less than ( ), and NOT (not equal to) are examples of _____.
A) compound conditions
B) comparison operators
C) conditions
D) compound values

Accepted Answer

Less than (<) and NOT (not equal to) are examples of comparison operators used to compare values in programming and mathematics.

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 (*)

Accepted Answer

The asterisk symbol (*) is used to select all fields in a SQL query.

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

Accepted Answer

A simple criterion involves a field name, a comparison operator, and a value or another field name, making it straightforward and uncomplicated.

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

Accepted Answer

The "Query Design" button on the Create tab is used to start creating a new SQL query in many database management systems.

Quiz 8: Using SQL

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

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

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

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

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

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.

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.

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

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

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

The default font size for queries is _____.

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

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

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

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

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.

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

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

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

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