Question 1

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

Accepted Answer

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

Question 2

Critical Thinking Questions Case 7-2 An employee at Camashaly Design needs to create an additional SQL query. She needs to sort records by current due within business analyst number. Which clause should the employee use to sort the query output?

Accepted Answer

The answer of Critical Thinking Questions Case 7-2 An employee...

Question 3

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

Accepted Answer

A)  ORDER BY 
B)  SORT BY 
C)  PRIMARY SORT 
D)  SORT KEY 
A)  ORDER BY 
B)  SORT BY 
C)  PRIMARY SORT 
D)  SORT KEY

Question 4

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.

Accepted Answer

A)  SQL Query 
B)  Design View 
C)  Query Design 
D)  Select Query 
A)  SQL Query 
B)  Design View 
C)  Query Design 
D)  Select Query

Question 5

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

Accepted Answer

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

Question 6

To name a computed field, follow the computation 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 7

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 8

A _____ criterion has the form: field name, comparison 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 9

The INSIDE operator is an alternative to an OR criterion.

Accepted Answer

A) True 
 B)False

Question 10

Critical Thinking Questions Case 7-1 An employee at Camashaly Design has created the SQL query shown in the accompanying figure but she would like to modify it. She does not like the Expr1000 that appears as a column heading and she would like to find the client with the largest current due. 
   
 What clause does the employee need to use to cause a name, such as ClientCount to appear as a column heading?

Accepted Answer

The answer of Critical Thinking Questions Case 7-1 An employee...

Question 11

The accompanying figure shows a query result that is sorted by amount paid within business analyst. To sort the records by business analyst and then amount paid, the SQL query used the ____________________ clause.

Accepted Answer

The answer of   
 The accompanying figure shows...

Question 12

To create a query that groups all clients with the same analyst number, include the _____ clause in the SQL command.

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

Question 13

To determine the number of clients assigned to a particular analyst, use the _____ aggregate function.

Accepted Answer

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

Question 14

To run a SQL query that adds records to a table, click the _____ button on the Design tab.

Accepted Answer

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

Question 15

To update records in SQL, you use the UPDATE command with a(n) _____ clause.

Accepted Answer

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

Question 16

The ____________________ wildcard represents any individual character.

Accepted Answer

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

Question 17

Match between columns
                        Premises: Operator used to eliminate duplicate values.

Accepted Answer

The Answer of HAVING and DESC and != and AS is...

Question 18

Match between columns
                        Premises: Operator used to sort records in descending order.

Accepted Answer

The Answer of DISTINCT and HAVING and != and DESC is...

Question 19

Modified Multiple Choice The comparison operators for use in SQL are _____.

Accepted Answer

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

Question 20

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

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

Critical Thinking Questions Case 7-2 An employee at Camashaly Design needs to create an additional SQL query. She needs to sort records by current due within business analyst number. Which clause should the employee use to sort the query output?

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

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.

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

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

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

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

The INSIDE operator is an alternative to an OR criterion.

The accompanying figure shows a query result that is sorted by amount paid within business analyst. To sort the records by business analyst and then amount paid, the SQL query used the ____________________ clause.

To create a query that groups all clients with the same analyst number, include the _____ clause in the SQL command.

To determine the number of clients assigned to a particular analyst, use the _____ aggregate function.

To run a SQL query that adds records to a table, click the _____ button on the Design tab.

To update records in SQL, you use the UPDATE command with a(n) _____ clause.

The ____________________ wildcard represents any individual character.

Modified Multiple Choice The comparison operators for use in SQL are _____.

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

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Advanced Report Techniques

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Database Design

Filters

Exam 8: Using SQL

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

Critical Thinking Questions Case 7-2 An employee at Camashaly Design needs to create an additional SQL query. She needs to sort records by current due within business analyst number. Which clause should the employee use to sort the query output?

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

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.

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

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

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

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

The INSIDE operator is an alternative to an OR criterion.

The accompanying figure shows a query result that is sorted by amount paid within business analyst. To sort the records by business analyst and then amount paid, the SQL query used the ____________________ clause.

To create a query that groups all clients with the same analyst number, include the _____ clause in the SQL command.

To determine the number of clients assigned to a particular analyst, use the _____ aggregate function.

To run a SQL query that adds records to a table, click the _____ button on the Design tab.

To update records in SQL, you use the UPDATE command with a(n) _____ clause.

The ____________________ wildcard represents any individual character.

Modified Multiple Choice The comparison operators for use in SQL are _____.

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

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Advanced Report Techniques

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Database Design

Filters