Name: 
 

A114/I111 Fall 2003 Midterm Study Guide (Part Six)



True/False
Indicate whether the sentence or statement is true or false.
 

1. 

Use CREATE TABLE to insert rows into a table.
 

2. 

A valid name might be tblEmp&Manage.
 

3. 

A valid name for a table might be tblEmployee.
 

4. 

In the SELECT clause, you list the fields that you want to display; the order of the list is the order of display.
 

5. 

Tables from which you are retrieving data should be in the WHERE clause.
 

6. 

There are two versions of the not equal operator - <> and !=.
 

7. 

There are two compound conditions - AND, OR
 

8. 

When using the AND condition, only one simple condition must be true for the compound condition to be true.
 

9. 

Using the NOT operator with a compound conditional operator (AND, OR) will negate the condition.
 

10. 

The BETWEEN operator is an alternative to using some of the relational operators.
 

11. 

All fields that will display due to a SELECT statement must be present in the database.
 

12. 

Using the LIKE operator with the wildcard symbol will allow you to display those rows whose fields match a certain collection of characters.
 

13. 

The IN operator will allow you to choose from a given set of choices.
 

14. 

The ORDER BY clause will permanently sort the original table.
 

15. 

The ORDER BY clause will sort the results of the SELECT statement by a specified sort key.
 

16. 

The output from a SELECT can only be ordered (sorted) by one key.
 

17. 

The COUNT function will return the number of rows affected in your SELECT query.
 

18. 

There is no difference between the COUNT function and the SUM function.
 

19. 

A subquery is a nested query.
 

20. 

In order to calculate sales for each sales rep, you need to group the customers together for each sales rep.
 

21. 

The clause used to group customers together is the ORDER BY clause.
 

22. 

You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.
 

23. 

Use the WHERE clause to restrict output from the SELECT using a GROUP BY.
 

24. 

Use the HAVING clause to restrict output from the SELECT using a GROUP BY.
 

25. 

A WHERE and a HAVING clause can be included in the same query.
 

26. 

Use the WHERE clause to join tables.
 

27. 

For each pair of tables to be joined, a condition must be included indicating how the tables are related.
 

Modified True/False
Indicate whether the sentence or statement is true or false.  If false, change the identified word or phrase to make the sentence or statement true.
 

28. 

The CREATE TABLE command will describe the layout of a table.

 

29. 

A(n) decimal data type is used to store numbers without a decimal part.

 

30. 

Many versions of SQL require that commands end with a(n) colon.

 

31. 

An SQL query can use the & symbol to shortcut the SELECT query; all fields will be selected when this symbol is used.

 

32. 

The WHERE clause is used to restrict the query results of a SELECT statement.

 

33. 

A(n) simple condition consists of the field name, comparison operator, and either another field name or a value.

 

34. 

Complex conditions are formed by connecting two or more simple conditions.

 

35. 

In order to negate a condition, use the NOR operator.

 

36. 

In order to list data for which both conditions in your query are true, use the OR operator.

 

37. 

In order to list data for which only one condition in your query is true, use the OR operator.

 

38. 

Use the IN operator with a wildcard symbol to match a certain collection of characters.

 

39. 

The two wildcard symbols are * and ! .

 

40. 

Using the ORDER BY clause will sort the query results.

 

41. 

Use DESC for a descending sort.

 

42. 

Use SUM to get the number of rows affected by the query.

 

43. 

Use SUM to get the total of a particular numeric field in a query.

 



 
Check Your Work     Reset Help