Name: 
 

COSC1300 Final Exam Study Guide



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

 1. 

The Web and the Internet are interchangeable terms.
 

 2. 

DSL service is not affected by the number of users on the line at the same time.
 

 3. 

Cookies store personal information to help customize Web pages for users.
 

 4. 

You cannot connect to the Internet wirelessly unless you’re in a WiFi hotspot.
 

 5. 

In a firewall, proxy servers act as a go-between from computers on an internal network and the Internet.
 

 6. 

Client/server networks are said to be decentralized.
 

 7. 

MAC addresses and IP addresses are the same thing.
 

 8. 

A node can NOT be a communications device, such as a modem.
 

 9. 

Repeaters are devices that are installed on long cable runs to amplify the signal.
 

 10. 

A query is designed to make data entry into a database easier.
 

 11. 

Consistency checks ensure that only reasonable data values are entered into a database.
 

 12. 

Reducing data redundancy by recording data only once is called data normalization.
 

 13. 

A data warehouse is a smaller slice of a data mart.
 

 14. 

The main reason businesses use data mining is to simplify transaction processing systems.
 

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

 15. 

Which one of the following statements is NOT true about instant messaging?
a.
It is a popular form of communication.
c.
More than two people can IM at the same time.
b.
You communicate in real time.
d.
Unlike e-mail, IM is good for private conversations.
 

 16. 

When shopping online, which of the following does NOT indicate that you have secure connection displays?
a.
A closed padlock icon in the status bar.
c.
The word “secure” in the title bar.
b.
The URL begins with https.
d.
The VeriSign seal on the Web page.
 

 17. 

With a podcast, you can _____.
a.
subscribe to video and audio content
c.
play the video and audio content on an MP3 player
b.
have the most recent content “delivered” automatically
d.
all of the above
 

 18. 

A Web page that enables online collaboration is a(n) _____.
a.
podcast
c.
blog
b.
wiki
d.
IM chat
 

 19. 

One scam that lures Internet users into revealing personal information is _____.
a.
malware
c.
spam
b.
phishing
d.
Internet hoax
 

 20. 

A combination of a phone and a PDA is referred to as a _____.
a.
smartphone
c.
cellular phone
b.
combo-phone
d.
personal digital assistant
 

 21. 

Which of the following is NOT an advantage of using mobile devices?
a.
You can access your files wherever you are.
c.
You can access the Internet at faster speeds.
b.
You can keep in contact with others via e-mail or phone wherever you are.
d.
You can access the Internet wherever you are.
 

 22. 

Which of the following allow you to carry media files?
a.
a PMP
c.
a PIM
b.
a PDQ
d.
a POM
 

 23. 

Text messaging is also called _____.
a.
test messaging
c.
short message service
b.
sending messages shortly
d.
short text messaging
 

 24. 

GPS refers to _____.
a.
goals performance system
c.
global parts system
b.
global positioning system
d.
ground position system
 

 25. 

Which is NOT a common server found on the Internet?
a.
Commerce server
c.
File server
b.
Web server
d.
Application server
 

 26. 

Data is sent over the Internet in small chunks called _____.
a.
pockets
c.
pieces
b.
packets
d.
switches
 

 27. 

A typical IP address is expressed as _____.
a.
a dotted decimal number
c.
32-bit numbers
b.
four octets
d.
all of the above
 

 28. 

SMTP is the protocol to do what over the Internet?
a.
Send e-mail.
c.
Upload files to another computer.
b.
Communicate via Instant Messaging.
d.
None of the above.
 

 29. 

Which of the following is a set of formatting technologies used on the Internet to add interactivity?
a.
HTML
c.
XML
b.
XHTML
d.
DHTML
 

 30. 

SSL is the protocol used to _____.
a.
create a secure connection between client and server
c.
encrypt e-mail messages
b.
transmit individual messages securely
d.
All of the above.
 

 31. 

Which type of network is NOT highly scalable?
a.
peer-to-peer
c.
Ethernet
b.
client/server
d.
intranet
 

 32. 

The geographical area for a LAN is most likely to be a _____.
a.
planet
c.
city
b.
nation
d.
building
 

 33. 

Which of the following is NOT  a component of a client/server network?
a.
transmission media
c.
network topology
b.
server
d.
computer manufacturer
 

 34. 

In a star topology, CSMA/CD is a technique for _____.
a.
avoiding and responding to data collisions
c.
routing data packets to the correct destination
b.
encrypting messages before network transmission
d.
configuring network topologies
 

 35. 

The type of cable with the lowest installation cost is _____.
a.
802.11
c.
coaxial
b.
fiber-optic
d.
twisted pair
 

 36. 

_____ are designed to send information between two networks.
a.
Hubs
c.
Repeaters
b.
Routers
d.
Switches
 

 37. 

A firewall ensures that incoming data came from a valid source via technique known as _____.
a.
access privileging
c.
authentication
b.
carrier sensing
d.
packet screening
 

 38. 

A _____ topology is the most widely deployed client/server network layout in businesses today.
a.
star
c.
token
b.
ring
d.
bus
 

 39. 

Which of the following cable types has the highest run length and the highest installation cost?
a.
ThickNet
c.
fiber-optic
b.
ThinNet
d.
twisted pair
 

 40. 

Which of the following does NOT perform its functions within a single network?
a.
router
c.
hub
b.
switch
d.
repeater
 

 41. 

An example of a UTP cable is _____.
a.
Cat 6
c.
coaxial
b.
RJ-45
d.
802.11
 

 42. 

Denial of Service (DoS) is _____.
a.
an act of bombarding a server with high volumes of false requests
c.
a firewall technique for blocking access to certain logical ports
b.
the malicious destruction of data by accessing the host’s FAT table
d.
a policy of withholding service from users who abuse the Internet
 

 43. 

Which of the following is NOT a benefit of networks?
a.
allow users to share printers
c.
allow users to transfer files easily
b.
allow users to share an Internet connection
d.
allow users to share monitors
 

 44. 

Viruses that change their own code (or periodically rewrite themselves) to avoid detection are called _____.
a.
multipartite viruses
c.
polymorphic viruses
b.
encryption viruses
d.
stealth viruses
 

 45. 

The best defense against viruses is to _____.
a.
install antivirus software
c.
install a firewall
b.
install spyware detector software
d.
install both antivirus software and a firewall
 

 46. 

Computer users who gain access to other companies’ or people’s computer systems with the intent to destroy information or for illegal gain are known as _____.
a.
black-hat hackers
c.
computer forensics experts
b.
Trojan horses
d.
wildcat hackers
 

 47. 

Dynamic addressing makes it more difficult for hackers to find likely victims because _____.
a.
the ISP hides the IP addresses for computers on their network
c.
the IP address is protected by a firewall
b.
the IP address changes each time a user logs on to their ISP
d.
the ISP assigns counterfeit IP addresses
 

 48. 

Which of the following is the most complex operating system to configure for a home network?
a.
Mac OS X
c.
Linux
b.
Windows XP
d.
Windows ME
 

 49. 

_____ services, such as MySpace and Facebook, have you list personal information about yourself and encourage you to list connections to your friends.
a.
Social networking
c.
Grid computing
b.
Switch chaining
d.
MIMO
 

 50. 

_____ computing is an efficient way of effectively linking millions of computers to perform complex calculations during lulls in their process cycles.
a.
Remote
c.
Grid
b.
Automated
d.
Functional
 

 51. 

Two lists reflecting different data about the same person is an example of _____.
a.
data redundancy
c.
data disparity
b.
data inconsistency
d.
data duplication errors
 

 52. 

Which of the following is NOT an advantage of using a database versus lists?
a.
Information can be easily shared among users.
c.
Data integrity can be assured with a database.
b.
Data entry errors can be minimized with databases.
d.
Databases are easier to build and maintain than lists.
 

 53. 

A group of related fields in a relational database is called a _____.
a.
primary key
c.
master key
b.
record
d.
table
 

 54. 

In databases, tables are related using _____.
a.
primary keys and foreign keys
c.
data marts
b.
boolean logic
d.
database logic
 

 55. 

A field that has a unique value for each record in a database is called the _____.
a.
logical key
c.
key field
b.
master field
d.
primary key
 

 56. 

A primary key of one table that is also found in a related table is a _____.
a.
linked key
c.
secondary key
b.
foreign key
d.
subordinate key
 

 57. 

Which of the following is one of the four main operations of a database management system?
a.
Querying data
c.
Structuring data
b.
Dissecting data
d.
Consolidating data
 

 58. 

Ensuring that a field must contain a number that is between two values is an example of a(n) _____.
a.
existence check
c.
range check
b.
completeness check
d.
consistency check
 

 59. 

A system that is designed to help perform routine daily tasks is known as a(n) _____.
a.
decision support system
c.
data warehouse
b.
office support system
d.
management information system
 

 60. 

An electronic system used to record sales of products through Web site is an example of a _____.
a.
transaction processing system
c.
management information system
b.
decision support system
d.
knowledge-based system
 



 
Check Your Work     Start Over