Test 2 Spring 2001

Test 2

Yellow Form

CS 104

Spring 2001

Multiple Choice: Choose the best answer

1. In Design view, how can you tell that a field is the primary key?

a. The status bar displays text when you have the field selected.

b. There is no way to tell in Design View.

c. The field name is underlined.

d. The key symbol appears on the row selector button.

e. None of the above

2. Which of the following is not a valid data type?

a. Currency d. Text & Numbers

b. Yes/No e. all are valid

c. Text

3. A Wildcard

a. an asterisk that is used to help you fine tune a search in a database

b. the default Web page

c. the default Web server

d. a new search engine

e. none of the above

4. Which of the following is not a valid relationship?

a. one-to-one d. many-to-many

b. one-to-many e. all are valid

c. many-to-one

5. In which view can you modify the structure of a table?

a. Any view d. Query view

b. Datasheet view e. none of the answers

c. Design view

6. "AND", "OR", and "NOT" are examples of _______________.

a. false drops

b. Boolean operators

c. Runs

d. Hits

e. None of the above

7. Flat files are created by __________-programs

a. two-dimensional

b. database management

c. file management

d. SQL

e. None of the above

8. When data is kept in a series of unrelated files, the inevitable result is ____________;

a. data integrity

b. data redundancy

c. integration of data

d. both a and b

e. a, b and c

9. To include all fields in a query, you could:

a. select each field individually

b. select the asterisk (*) in the field list

c. not all fields can be included such as key fields

d. a and b above

e. none of the answers

10.When you sort data in a query

a. the records in the underlying tables are also sorted

b. data can only be sorted by a major sort key

c. if you do not want duplicates to appear, use the Properties command

d. the major sort key must appear to the right of the minor sort key.

e. All of answers are incorrect

Questions: 11 and 12 will use the following Access tables Employee (Figure 1) and Salary (Figure 2):

Figure1: Employee Table

Figure 2: Salary Table

11. Which of the filled in design grid queries will answer the following question:

Display in alphabetical order the last names of employees who live in Indiana who make over $10,000. (IN)

Field:	LastName	StateOrProvince	Salary
Table:	Employee	Employee	Salary
Sort:	Decending
Show:
Criteria:		Like "IN"	>10000
Or:

Field:	LastName	StateOrProvince	Salary
Table:	Employee	Employee	Salary
Sort:	ascending
Show:
Criteria:		Like "IN"
Or:			>10000

Field:	LastName	StateOrProvince	Salary	EmployeeID
Table:	Employee	Employee	Salary	Employee
Sort:	ascending
Show:
Criteria:		Like "IN"		=[EmployeeID]!Salary
Or:			>10000

Field:	LastName	StateOrProvince	Salary
Table:	Employee	Employee	Salary
Sort:	ascending
Show:
Criteria:		Like "IN"	>10000
Or:

e.None of the above

12. Which of the filled in design grid queries will answer the following question:

Display the last names of employees who work in Dept 10 or

Dept 11 and do not have benefits.

Field:	LastName	DepartmentID	benefits
Table:	Employee	Salary	Salary
Sort:
Show:
Criteria:		Like "10"	No
Or:		Like "11"

Field:	LastName	DepartmentID	Benefits
Table:	Employee	Salary	Salary
Sort:
Show:
Criteria:		=10	No
Or:		=11

Field:	LastName	DepartmentID	benefits	EmployeeID
Table:	Employee	Salary	Salary	Employee
Sort:
Show:
Criteria:		=10	No	=[EmployeeID]
Or:		=11

Field:	LastName	DepartmentID	benefits
Table:	Employee	Salary	Salary
Sort:	ascending
Show:
Criteria:		=10	No
Or:		=11	No

e. none of the answers.

13.How should you enter criteria for text fields if the criterion contains punctuation?

a. In all uppercase d. Within quotation marks

b. In all lowercase e. none of the answers

c. In bold

14. In what order are fields included in a query?

a. The order in which you add them. d. Numerical order

b. The order in which they appear in the table. e. None of the answers.

c. Alphabetical order

15. GIF

a. Is a lossless compression d. has no patent protection

b. Is a lossy compression e. None of the answers

c. Is a format used for sound media

16. An anti-virus program ___________________;

a. can be set to run automatically whenever a computer is booted

b. is called a vaccine

c. is available at minimal cost

d. all of above

e. none of the above

17. When using a word processor to create a Web page, you should save the file with a _____extension.

a. DOC d. URL

b. HTML e. none of the answers

c. TXT

18. To add a graphic to a web page, the format must be

a. JPG

b. GIF

c. BMP

d. IMG

e. a and b

19.Subject directories are built by __________; Web databases are built by __________________--.

a. people, software robots

b. software robots, people

c. HTML, HTTP

d. Infoseek, Yahoo!

e. None of the above

20.What invention enabled developers to create microcomputers?

a. integrated circuit

b. transistor

c. vacuum tube

d. magnetic disk

e. all of the above

21. Which of the following is not true of computers as we progress from one generation to the next?

a. Computer size decreased.

b. Computer cost decreased.

c. Speed of processing increased.

d. Memory/storage capacities decreased

e. All are true

22. Which type of chart is best for showing parts of the whole?

a. area

b. column

c. line

d. pie

e. none of the above

23. What type of chart usually helps you spot trends easily?

a. Area d. pie

b. Column e. none of the answers

c. line

24.If the pound signs (#####) fill a cell, it means what?

a. the cell is not active

b. the formula is impossible

c. the column is not wide enough

d. you must recalculate the formula

e. none of the above

25. The contents of the following spreadsheet cells are as follows:

D4 100

A4 99

C4 1

If the formula =IF(D4-A4<=10,-C4*2, 0) is in cell A3, what value is displayed in A3?

a. 0 c 2

b. -2 d. -.02

e. none of the answers

26. When you copy the formula =$C$2 + C3 from cell C4 to D4, what is the resulting formula?

a. =C2+D3

b. =$D$2+D3

c. =$C$2 + C3

d. =$C$2 + D3

e. none of the above

27. An argument in a function can be which of the following?

a. a single cell c any entered value

b. a range of cells d. a, b and c

e. none of the answers

28. If you do not use parenthesis in a formula, which type of calculation takes precedence?

a. exponential calculations

b. multiplication

c. division

d. addition

e. none of the above

29. What appears in the active cell where you enter a formula?

a. the formula

b. the result of the formula

c. the cell address

d. an equal sign

e. none of the above

30. What function is used to add the values in a range of cell?

a. ADD

b. PLUS

c. SUM

d. TOTAL

e. None of the above

31. Which of the following is a valid formula?

a. B3+B4+B5

b. (B3+B4+B5)

c. =B3+B4+B5

d. $b$3+$B$4+$B$5

e. none of the above

32.To identify the range of cells A1 to Z100, type which of the following?

a. A1:z100

b. A1;Z100

c. A1-Z100

d. A1,Z100

e. None of the above

33. K$5 is a

a. relative reference

b. absolute reference

c. mixed reference with row varying

d. mixed reference with the column varying

e. it is not a reference