Name: 
 

A114/I111 Midterm Study Guide (Fall 2003, Part Three)



Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.
 

1. 

A relation is a(n)
a.
attribute.
c.
field.
b.
column.
d.
table.
 

2. 

If two tables have the same column name, the best approach is to
a.
not use these two tables together.
b.
not use the column names in the same statement.
c.
use the table name and the column name, separated by a period.
d.
use the table name only.
 

3. 

Each relation is a ____ dimensional table.
a.
one
c.
three
b.
two
d.
four
 

4. 

The attributes of an entity become the ____ in a table.
a.
rows
c.
headers
b.
data
d.
columns
 

5. 

Each location in the table must be ____-valued.
a.
double
c.
distinctly
b.
single
d.
uniquely
 

6. 

Rows are also called
a.
fields.
c.
tuples.
b.
columns.
d.
attributes.
 

7. 

The ____ key of a table is the column that uniquely identifies a row in a table.
a.
primary
c.
foreign
b.
secondary
d.
minor
 

8. 

An approach to writing queries in a visual method is called
a.
SQL.
c.
QBE.
b.
QAC.
d.
ACCESS.
 

9. 

In order to display all fields, we can use the ____ symbol in our queries.
a.
&
c.
#
b.
@
d.
*
 

10. 

Using the * means that we will see all ____ in the query.
a.
rows
c.
tables
b.
columns
d.
databases
 

11. 

The relational operator to test for inequality is
a.
>.
c.
=.
b.
<=.
d.
NOT.
 

12. 

The compound criteria (conditions) are created by using
a.
AND, OR.
c.
OR, NOT.
b.
AND, NOR.
d.
NOT, ONLY.
 

13. 

To use the AND criterion, place the criteria on the ____ criteria row in the design grid.
a.
same
c.
row above the
b.
row below the
d.
rows above and below the
 

14. 

To use the OR criterion, place the criteria on ____ criteria row(s) in the design grid.
a.
the same
c.
a different
b.
all the
d.
none of the
 

15. 

In order to write a query to determine the customers whose balance is between $1000 and $5000, you would use the ____ criterion.
a.
AND
c.
NOR
b.
OR
d.
NOT
 

16. 

Any field names to be calculated are placed between ____ when the query is written.
a.
{}
c.
**
b.
%%
d.
[]
 

17. 

Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be used in a query.
a.
accumulated
c.
afterstatistic
b.
allowed
d.
aggregate
 

18. 

To calculate the lowest balance for all customers, which aggregate function should be used?
a.
Min
c.
Avg
b.
Max
d.
Count
 

19. 

In order to create a unit out of a number of records that share some common characteristic, select
a.
Order by.
c.
Collect by.
b.
Organize by.
d.
Group by.
 

20. 

If you are sorting by more than one column, the more important field/column is called the
a.
primary sort key.
c.
maximum sort key.
b.
secondary sort key.
d.
minor sort key.
 

21. 

In order to select data from more than one table, it will be necessary to ____ the tables.
a.
merge
c.
join
b.
combine
d.
break apart
 

22. 

A query that changes data is a(n) ____ query.
a.
addition
c.
update
b.
modification
d.
select
 

23. 

A(n) ____ query deletes all the records satisfying the criteria entered in the query.
a.
update
c.
select
b.
modify
d.
delete
 
 
three_files/i0250000.jpg
 

24. 

Refer to figure 2.1 on pages 30-31. How many records would be deleted for the following query? Delete all order lines in which the order number is 21610.
a.
one
c.
three
b.
two
d.
none
 
 
three_files/i0270000.jpg
 

25. 

Refer to figure 2.1 on pages 30-31. How many records would be affected for the following conditions?
Change the zip code for the customers in the city of Fillmore to 33363.
a.
one
c.
three
b.
two
d.
none
 

26. 

A ____ query creates a new table using the query results.
a.
new-table
c.
create-table
b.
make-table
d.
merge-table
 

27. 

The type of algebra that manipulates a database is called ____ algebra.
a.
boolean
c.
relational
b.
Cartesian
d.
basic
 

28. 

Which command takes a vertical subset of a table?
a.
SELECT
c.
PROGRAM
b.
DELETE
d.
PROJECT
 

29. 

Which operation will allow you to extract data from more than one table?
a.
select
c.
project
b.
merge
d.
join
 

30. 

Two tables are considered to be ____ compatible if they have the same number of columns and their corresponding columns represent the same type of data.
a.
union
c.
difference
b.
intersection
d.
product
 

31. 

Two tables ____ have the same structure to be union-compatible.
a.
need not
c.
should
b.
must
d.
can
 

32. 

The ____ operator is for all the rows in a table that were contained in table A or table B or in both.
a.
union
c.
product
b.
difference
d.
intersection
 

33. 

The ____ set operator will show all rows common to both tables A and B.
a.
union
c.
product
b.
difference
d.
intersection
 

34. 

The ____ set operator shows all the rows from table A that are not in table B.
a.
union
c.
product
b.
difference
d.
intersection
 

35. 

The ____ set operator is performed by the SUBTRACT command in relational algebra.
a.
union
c.
product
b.
difference
d.
intersection
 

36. 

The ____ set operator is used to concatenate every row in the first table with every row in the second table.
a.
union
c.
product
b.
difference
d.
intersection
 

37. 

The product of two tables is also called the ____ product.
a.
Cartesian
c.
Cathode
b.
Cartigan
d.
Cartilage
 

38. 

Using the product operator, if table A has 4 rows and table B has 4 rows, the number of rows in the product of these two tables is
a.
4.
c.
16.
b.
8.
d.
20.
 
 
three_files/i0420000.jpg
 

39. 

Refer to figure 2.44 on page 60. What is the result of dividing the OrderLine table (use the whole table - columns OrderNum and PartNum) with the Part table (use the PartNum columns containing data DR93 and DW11)?
a.
21608
c.
21613
b.
21610
d.
21614
 

40. 

The difference operation is performed by the ____ command.
a.
subtract
c.
product
b.
intersection
d.
union
 

41. 

The operation where every row in table A is combined with every row in table B is the
a.
intersection.
c.
product.
b.
union.
d.
difference.
 

42. 

If you want only those combinations that satisfy certain restrictions, you should use the ____ operation instead of the product operation.
a.
union
c.
difference
b.
join
d.
subtract
 



 
Check Your Work     Reset Help