University of Massachusetts Boston
College of ManagementMSIS 110: Introduction to Computers
Summer 2003 - Exam 3Name: ______
Answer all questions. If any cheating is discovered, severe sanctions will result. Indicate your responses in this sheet. No credit if responses are written elsewhere.
PART / # of Ques. / # CORRECTT/F / 23
MCQ / 17
Short Ans. / 05
TOTAL / 45
Score / /100
1. ______16. ______31. ______
2. ______17. ______32. ______
3. ______18. ______33. ______
4. ______19. ______34. ______
5. ______20. ______35. ______
6. ______21. ______36. ______
7. ______22. ______37. ______
8. ______23. ______38. ______
9. ______24. ______39. ______
10. ______25. ______40. ______
11. ______26. ______41. ______
12. ______27. ______42. ______
13. ______28. ______43. ______
14. ______29. ______44. ______
15. ______30. ______45. ______
Good Luck & Happy Holidays
True /False
Indicate whether the sentence or statement is true or false.
____ 1. Arts, com, edu, mil, and rec are examples of top-level domain affiliations on the Internet.
____ 2. Many Web sites rely on advertising revenue as their major source of income.
____ 3. A firewall can be set up to allow access from only specific hosts and networks.
____ 4. Firewalls offer absolute security on the Internet.
____ 5. Increased information about delivery dates and current order status can increase customer loyalty.
____ 6. E-commerce systems require both hardware and software to run.
____ 7. In Access, a database consists of a collection of tables.
____ 8. A field contains information about a given person, product, or event.
____ 9. A record contains a specific piece of information within a field.
____ 10. The rows in a table are called fields, and the columns are called records.
____ 11. In Access, all the tables, report, forms, and queries are stored in separate files. Collectively, these files are called a database.
____ 12. Every record in a table must have a primary key.
____ 13. Reports can incorporate data from multiple tables.
____ 14. Redundancy makes updating the database more difficult.
____ 15. Microsoft Access does not allow you to save queries.
____ 16. To find all customers whose amount paid amount is less than $10,000.00, enter <$10000 as the criterion for the Amount Paid field.
____ 17. Access only supports the built-in statistics: COUNT, SUM, AVG, MAX, and MIN.
____ 18. Either Datasheet view or Form view can be used to add new records, change existing records, and delete records.
____ 19. Validation text is the message that will display if a user violates the validation rule.
____ 20. When a default value is specified for a field, it means that Access automatically will enter the value as soon as a new record is added.
____ 21. To specify that AZ, NM, and TX are the only legal values for the State field, type =AZ or =NM or =TX in the Validation Rule property box in the Table window.
____ 22. If a user violates a validation rule when entering data into a table, the database will not be updated until the error is corrected.
____ 23. The property that the value in a foreign key must match another table’s primary key is called entity integrity.
Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.
____ 24. ____ is the nation with the largest number of Internet users.
a. / Franceb. / Japan
c. / Brazil
d. / United States
____ 25. A(n) ____ is an assigned address on the Internet for each computer.
a. / URLb. / HTTP
c. / HTML
d. / Codec
____ 26. An individual can log on to another computer and access its files with:
a. / Telnet.b. / URLs.
c. / e-mail.
d. / FTP.
____ 27. ____ is a collection of independently-owned computers that work together in a single Internet service and provide data files accessible to browsers.
a. / Usenetb. / FTP
c. / The World Wide Web
d. / Newsgroups
____ 28. A Web site's cover page is known as a:
a. / FTP site.b. / Prime Web page.
c. / search engine.
d. / home page.
____ 29. ____ involves conducting business activities using electronic data transmission involving computers, telecommunications networks, and streamlined work processes.
a. / Transaction processingb. / Decision support
c. / E-commerce
d. / B2B e-commerce
____ 30. The ____ e-commerce market is larger than the ____ one.
a. / B2C, B2Bb. / B2B, B2C
c. / e-tailing, B2B
d. / EDI-based, B2B
____ 31. Kerry was able to buy shoes, books, toothpaste, pet supplies, and a case of cabbage from a single Web site. She probably visited a(n):
a. / cybermall.b. / Internet emporium.
c. / Web ring.
d. / e-tail outlet.
____ 32. A(n) ____ is an electronic forum that manufacturers, suppliers, and competitors can buy and sell goods, trade market information, and run back-office operations.
a. / e-commerce consortiumb. / Web ring
c. / electronic exchange
d. / Web directory
____ 33. ____ is the process of transforming a Web site into the nuances, subtleties, and tastes of a particular culture for which it is targeted.
a. / Localizationb. / E-transformation
c. / Globalization
d. / E-specialization
____ 34. The wildcard symbols available for use in a query are the ______.
a. / double period (..) and the asterisk (*)b. / question mark (?) and the asterisk (*)
c. / double period (..) and the at symbol (@)
d. / question mark (?) and the ampersand (&)
____ 35. To find all customers whose names begin with Ba, enter ______in the Criteria row of the Name column in the accompanying figure.
a. / Ba* / c. / Ba@b. / Ba? / d. / Ba..
____ 36. To find all customers whose name is either Merks College or Marks College, enter ______in the Criteria row of the Name column in the accompanying figure.
a. / M@rks College / c. / M*rks Collegeb. / M&rks College / d. / M?rks College
____ 37. To omit duplicates from a query, use the Properties command and change the Unique Values property to ______.
a. / On / c. / Yesb. / Off / d. / No
____ 38. When an expression is entered for a calculated field, the field names used in the expression must be enclosed in ______.
a. / square brackets ([ ]) / c. / quotation marks (“ “)b. / curly braces ({ }) / d. / parentheses (( ))
____ 39. To find the smallest amount paid amount for a customer, select ______as the entry in the Totals row for the Amount Paid column.
a. / LITTLE / c. / MINb. / SMALL / d. / LEAST
____ 40. Physically rearranging the records in a table is called ______.
a. / indexing / c. / seekingb. / sorting / d. / repositioning
Completion
Complete each sentence or statement.
41. ______is an object-oriented programming language from Sun Microsystems that allows small programs to be embedded within an HTML document.
42. ______is a form of e-commerce where the participants are organizations.
43. Web pages that don't change can be classified as ______.
44. A field with a data type of ______can contain any characters.
45. A question that is asked of Access, or any other database management system, is called a(n) ______.
Answer Section
1. T
2. T
3. T
4. F
5. T
6. T
8. T
9. F
10. F
11. F
12. F
13. T
14. T
16. T
17. F
18. F
19. F
20. T
21. T
22. T
23. T
24. T
25. F
26. D
27. A
28. A
29. C
30. D
31. C
32. B
33. A
34. C
35. A
36. B
37. A
38. D
39. C
40. A
41. C
42. B
43. Java
44. B2B
45. static
46. Text
47. query
1