FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Using SQL

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

The ____________________ wildcard represents any individual character.

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

The INSIDE operator is an alternative to an OR criterion.

Identify the letter of the choice that best matches the phrase or definition.

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

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?

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

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

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

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 _____ criterion has the form: field name, comparison operator, then either another field name or a value.

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

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

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 sort the output of a SQL query, include the _____ clause in the SQL query statement.

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?

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

Identify the letter of the choice that best matches the phrase or definition.