Comp4

1.

A dishwasher has an embedded computer.

True

False

2.

Speakers are an example of a computer output device.

True

False

3. 4. The is a collection of interconnected documents and other resources, linked by hyperlinks and URLs.

ARPANET

Domain Name System

Internet

World Wide Web

4. ____ 5. From the list provided below, select a valid URL.

Www.whitehouse.gov

Www.google/com

Ww.nih.gov

Www@nih.gov

5. 6. The WWW was created in by Dr. Tim Berners-Lee and others with the introduction of the Web browser and Web page coding.

1989

1969

1940

1995

6. 7. A(n) is a software program that lets a user use Web server resources over the Internet.

Web page

URL

HTML page

Browser

7. 9. A Web server sends back to the browser, which translates it for display on a monitor.

TCP/IP

HTML

HTTP

Header information

8. 10. HTML is a(n) .

Web page programming language

Web page

IP addressing scheme

Internet protocol used to communicate with Web servers

9. 11. HTTP is a(n) .

Web page programming language

Web page

IP addressing scheme

Internet protocol used to communicate with Web servers

10. 12. The Internet is owned by .

Google

Nobody

The U. S. government

Everybody

11. ____ 13. What is required for a device to communicate over the Internet?

An IP address and subnet mask.

A Web browser.

A Web server.

An IP address only.

12. 15. The Domain Naming System maps a(n) to a domain name.

Web site name

TCP address

IP address

Root server

13. 17. The slowest type of Internet connection is the connection type.

Satellite

Dialup

DSL

Cable

14. 18. The global standard governing wireless technologies is the standard.

802.11

568-A

UTE

802.3

15. 19. Home networks usually connect to the Internet through the use of the services provided by a(n) .

ASP

Tier

C. national provider

ISP

16. 20. A typical home network connecting to the Internet uses IP addressing.

Only Public

Only private

Both public and private

HTTP

17. ____ 24. How does a search engine provide you with a result set?

Web crawler searches Web pages to create a result set.

Database query to search each Internet Web site.

Searches its indexed data based on your search criteria.

None of the above.

18. 26. Examples of Boolean operators include the terms .

NOT, AND, OR

NOT, AND, *

AND, OR, CATCH

OR, TRY, NOT

19. 31. Antivirus software works by recognizing and stopping those things from causing harm to your computer.

Files

Patterns of bad behavior

Hackers

AV software

20. 34. Some experts recommend first party, third party, and session cookies.

Accepting, accepting, accepting

Accepting, rejecting, allowing

Accepting, allowing, rejecting

Rejecting, allowing, rejecting

21. 39. Macro viruses are usually associated with files.

Open Office

PDF

Image

Microsoft Office

22. 46. One difference between PHRs and EHRs is that PHRs are .

Governed by HIPAA

Maintained by individuals

Not for online use

Organized and utilized by medical doctors

23. 48. Patient medical records should be send electronically in a(n) format.

Zipped

Encrypted

HTTP

IP

24. ____ 49. According to HIPAA rules, who can view your medical information without a signed release?

Employer

Primary care physician

Spouse

All of the above

25. 1. The main function of a computer is to ____.

Execute instructions

Answer human questions

Service the CPU

Create input signals

26. 4. Today's computers connect the mouse and keyboard via a(n) ____ slot.

USB

IDE

SATA

PS/2

27. 13. What is an MRI?

A nuclear medicine imaging device that produces a 3-D image.

An x-ray, using specialized equipment, that takes cross-sectional pictures of the body.

A device that creates an image based on sound waves.

Magnetic imaging equipment that uses a radio frequency pulse to create an image.

28. 14. A binary digit value of one (1) indicates that electricity is ____.

Stored in RAM

On

Off

In a Boolean circuit

29. 15. In the binary number "01011010", the rightmost value of "0" is a placeholder for ____.

2^0

2^1

2^2

2^7

30.

Which of the following is NOT a form of software that is free?

A. Public Domain

B. Open Source

C. Packaged

D. Freeware

31.

Which of the following is NOT an example of word processing software?

A. Microsoft Word

B. OpenOffice Impress

C. OpenOffice Writer

D. Corel WordPerfect

32.

Select all of the following that are examples of communications software.

A. Email

B. Web browsers

C. Blog

D. Wiki

All of them

33.

When would you need a new device driver? Select all of the following that are reasons you'd need a new driver.

A. You install a new printer.

B. You do a major upgrade of your OS.

C. You buy a new computer.

D. Your driver was corrupted.

Submit

34.

_________ is a way that OS give the illusion of a large memory.

A. Physical memory

B. Permanent memory

C. Virtual memory

D. RAM

35.

What is the latest version of Microsoft Windows OS?

A. Windows XP

B. Windows 7

C. Windows Vista

D. Windows NT

36.

The file _______ identifies the file type.

A. Extension

B. Name

C. Size

D. Permissions

37.

Files that are stored in non-contiguous clusters are called __________ files.

A. Stored

B. Fragmented

C. Free

D. Protected

38.

The most important software on your computer is the operating system.

True

False

39.

Copying software from a friend is always okay.

True

False

40.

The device driver for your printer will need to be updated when you do a major upgrade of your operating system.

True

False

41. 4. Windows Server 2008 is an example of _______.

A machine-based or independent Operating system

Mobile-based or embedded operating system

Server-based operating system

Personal efficiency software

42. 9. An Applet is an example of a _______ language.

Binary

Legacy

Scripting

Object oriented

43. 15. The requirements analysis phase of the SDLC can involve all but the following.

Writing programming code

Talking to users

Examining a report

Analysis of a form

44. 26. A thorough testing phase will catch ___________.

All errors

About half of possible errors

Most common, but not all possible errors

All logic errors

45. 27. The consequences of an error in a health care application _____________.

Can result in loss of life

Is comparable to other industries

Is negligible because it can always be done over

May make it necessary to work overtime

46. 34. The kind of data stored in memory is described to the computer as a ________.

Memory location

Data type

Primary value

Data group

47. 36. The character set of 0-9 is contained in what data type?

Numeric and alphabetic

Numeric and alphanumeric

Alphabetic

Alphabetic and alphanumeric

48. 42. Most (if not all) scientific, business, industry, health care and personal use computer problems can be solved with just the three following logic constructs.

Continue, Choice and Steps

Recursion, Concurrency and Execution

Alternation, Sequence and Iteration

Conditional branch, Unconditional branch and Perform

49. 12. A foreign key is . . .

A. A well-known attribute value that uniquely determines a row in a table.

B. An automatically generated numeric value that uniquely determines a row of a table.

C. A unique key from another table.

D. A key that doesn’t belong in the table where it appears.

50. 14. What language is used to store and retrieve data from a database?

A. UML

B. DDLC

C. DBMS

D. SQL

51. 15. The most important source of specifications for database development is obtained from which of the following?

A. Forms and reports

B. Existing files

C. Users

D. Customers

52. 19. The data model is best described as which of the following?

A. The database design.

C. A fixed model from which the database is implemented.

D. A diagram that represents only one view of the database.

53. 28. Natural keys have the advantage over surrogate keys of which of the following?

A. They are short and almost always numeric.

B. They introduce a transitive dependency.

C. They are more likely to be known to the user or to the patient/customer.

D. Their value is automatic and do not require data entry.

54. 31. An example of a many-to-many relationship is which of the following?

A. Patient to hospital wrist band ID

B. Hospital medical procedure to patient

C. Insured to dependents

D. Toxicology report to Patient

55. 36. SQL commonly produces or projects which of the following?

A. one logical record

B. users of the system

C. record sets

D. one attribute

56. 38. Which of the following is involved in data modeling?

A. ER-diagram

B. SQL

C. Implementing the database

D. Maintaining the database

57. 44. Which normal form is commonly considered to be all that is necessary for most database situations?

A. Second normal form

B. Third normal form

C. Boyce-Codd form

D. Fourth normal form

58. 48. SQL is used to create a database (True or False).

True

False

59. 51. The SQL statement used to retrieve data from a database is which of the following?

A. UPDATE

B. SELECT

C. INSERT

D. WHERE

60. 1. From the choices below, select the best definition of a network.

A. A collection of printers with no media.

B. Devices interconnected by some common communication channel.

C. A device that sends communication to the Internet.

D. A shared folder stored on a server.

61. 2. A(n) _____ connection requires the services of an ISP.

A. network

B. Internet

C. Intranet

D. home

62. 6. A _____ IP address can change when you reboot your ISP device.

A. dynamic

B. static

C. DNS

D. public

63. 7. Private IP addresses _____.

A. have meaning on the Internet and in a home network

B. have no meaning outside of the home network in which the address resides

C. are the same thing as public IP addresses

D. None of the above.

64. 15. A _____ topology describes how a network is actually designed and laid out across a campus.

A. logical

B. physical

C. mesh

D. star

65. 21. A(n) _____ protects a device from spikes in power usually originating with the power company.

A. USPS

B. switch

C. surge protector

D. Either A or B

66. 1. A neighbor becomes aware of a medical condition you have been privately battling for the past six months. The neighbor says that if you do not pay her $5,000, she will use a pay phone to disclose this information to your father. This is an example of _____.

A. blackmail

B. compromised data

C. identity theft

D. impersonation

67. 10. Network security revolves around the setup and use of _____ to control who and how objects are utilized.

A. identification

B. authentication, authorization, and permissions

C. authentication and permissions

D. packet sniffers

68. 11. An authenticated object is an object that _____.

A. is able to print a document

B. in a directory

C. proved its identity

D. can delete a file in a folder

69. 12. An example of authentication is when a user _____.

A. is able to delete a file

B. can print a document

C. shuts down a computer

D. logs into a computer

70. 18. Software and/or hardware that blocks unauthorized communications on a computer is referred to as a(n) _____.

A. packet sniffer

C. switch

D. hub

E. firewall

71. 19._____ protect(s) a computer by locating and stopping programs attempting to harm computer operation.

A. Antivirus software

B. Firewalls

C. Routers

D. Spyware

72. 22. A simple step to secure data from those who do not have permission view it is to _____.

A. store the data on a flash drive

B. move the data on a corporate Web server

C. perform a background check on all employees

D. require employees to lock their computers when they leave their desk

73. 23. A complex password contains at least 6 characters, made up of at least: 1-upper case, 1-lower case, 1-number, and 1- _____ character.

A. special

B. numeric

C. typed

D. authorized

74. 27. The U. S. Government would like to implement electronic health records for most Americans by the year _____.

A. 2030

B. 2016

C. 2020

D. 2014

75. 28. Health information is stored as a(n) _____ in an EHR.

A. folder

B. table

C. record

D. entity

76. 29. HIPAA requires that health care providers, insurance companies, and employers abide by _____ standards.

A. accountability

B. privacy and security

C. state

D. international

77. 33. When users enter data on Web forms, the data should be _____ before it is saved to the database.

A. scrubbed

B. committed

C. balanced

D. validated

78. 10. Significant healthcare security breaches

A. have never occurred.

B. are published on a government web site.

C. are not a privacy issue.

D. are caused by virtual machine use.

79. 1. What is an information system?

A. A computer program.

B. A database.

D. None of the above.

80. 2. What is the goal of an information system?

A. Improve business knowledge.

B. Improve business processes and services.

C. Improve business communications and people collaboration

D. All of the above.

81. 7. A(n) _________ is an abstraction of a problem.

A. Model

B. Domain

C. Object

D. Attribute

82. 10. Systems Implementation includes

A. Application development

B. Testing

C. Training

D. All of the above

83. 11. The __________ is a centralized resource staffed by IT professionals who provide user support.

A. Systems maintenance

B. User trainers

C. Help desk

D. Database

84. 14. ________ testing focuses on the system as a whole.

A. Unit

B. Integration

C. Module testing

D. System

85. 15. Select all of the following that are part of a test plan.

A. Testing deliverables

B. Testing goals

C. What to do when a test fails

D. Maintenance

A,b,c

86. 17. Total cost of ownership includes

A. Acquisition costs, ongoing support costs and maintenance costs

B. Opportunity costs

C. Acquisition costs only

D. Economic feasibility

87. 21. System users are the only stakeholders for an information system.

True

False

88. 23. Project teams do not require management.

True

False

89. 25. Web-based applications have less complex security issues than traditional applications.

True

False

90. 27. Maintenance requests are formalized processes to document and fix problems.

True

False

91. 29. Software testers perform actions that may cause software to malfunction.

True

False

92.

Which part of the computer is its "brain"?

A. Monitor

B. Memory

C. CPU

D. Keyboard

93.

Where are programs stored when they are running?

A. DVD

B. Memory

C. Monitor

D. Keyboard

94.

What is the most important software that runs on your computer?

A. Operating System

B. Word processor

C. Spreadsheet

D. Browser

95.

Which of the following are example(s) of personal computers? Select all that apply.

A. Desktop

B. Supercomputer

C. Laptop

D. Smartphone

A,c,d

96.

Which of the following is an input device for a personal computer?

A. Speaker

B. CPU

C. Memory

D. Mouse

97.

When was the World Wide Web first developed?

A. 1969

B. 1979

C. 1989

D. 1999

98.

What was the first use of electronic medical records?

A. Storing dental records

B. Automating antibiotic ordering

C. Implementing Computerized Physician Order Entry

D. None of the above

99.

Where can you find up to date information about current computing systems? Select all that apply.

A. Recent online reviews

B. Current issues of computer magazines

C. Year-old issues of computer magazines

D. Books published more than a year ago

Submit

100.

What was the first personal computer?

A. Apple I

B. IBM PC

C. Altair

D. iMac

101.

Personal computers were first developed in the 1970s.

True

False

102. 1. The is a global system of computer networks that communicate using TCP/IP and is a large network made up of many smaller networks.

Domain Naming System

Internet

World Wide Web

ARPANET

103. 2. The Internet began because .

People realized the business potential of having a global communication system

Scientists needed to be able to share secrets securely

The U. S. government wanted to be able to communicate, even in the event of a nuclear attack

Stanford researchers sold the design to ICANN, who began selling IP addresses to ISPs.

104. 6. Macro viruses usually infect Microsoft Office files and _____.

A. install themselves when users click files

B. delete all hard disk files on a specified date

C. install themselves when the computer reboots

D. None of the above

105. 8. You receive an email that appears to be from eBay asking you to login to verify a transaction. This is an example of (a) ________ attack.

A. worm

B. virus

C. phishing

D. buyware

106. 9. A _____ is a free protocol analyzer software tool that can display unencrypted network traffic on a monitor screen.

A. packet sniffer

B malware-analyzer

C. spyware tracer

D. server

107. 16. Your company decides that it should back up computer files every four hours during the week and at the end of the day on weekends. This process needs to be recorded in the company's _____.

A. permissions

B. security policy

C. WAN documentation

D. email

108. 20. _____ are hardware and/or software that monitor network traffic for malicious activity.

A. Routers

B. Intrusion Protection Systems

C. Packet sniffers

D. Antivirus installations

109. 21. Encryption is a process whereby communication is made unreadable to _____.

A. everyone

B. authorized viewers

C. unauthorized viewers

D. None of the above

110. 26. You were asked to configure wireless authentication. Which protocol should you select?

A. WEP

B. NTFS

C. WLAN

D. WPA2

111. 30. Privacy is to _ as confidentiality is to _.

A. people; data

B. security; blackmail

C. blackmail; security

D. data; people

112. 31. The law of _____ regulates the type of information which may be collected and how this information may be used and stored.

A. security

B. privacy

C. confidentiality

D. torts

113.

A computer is:

A. A system with a processor, memory, storage, keyboard, mouse and monitor.

B. A person who computes.

C. An electronic programmable device that inputs, processes and outputs data.

D. An electronic device that is embedded in objects and that controls the object based on certain inputs.

E. All of the above.

114.

Which of the following are important factors to consider when selecting a computer? Select all that apply.

A. Budget

B. Storage needs

C. Application requirements

D. Type of user

E. Mobility needs

Submit

115.

What technology was used in the first general purpose electronic computers?

A. Transistors

B. Integrated circuits

C. Mechanical gears

D. Vacuum tubes

116. 8. A browser uses to communicate with Web servers.

TCP/IP

HTML

HTTP

Coding

117. ____ 14. Select a valid IP address and subnet mask from below:

192.168.0 and 255.255.255.0

10.10.10.1 and 255.255.255.224

10.10.10.1 and 255.255.256.0

192.168.0.1 and 255.255.280.0

118. 23. A(n) is a set of instructions set out logically to solve a problem.

Web crawler

HTML coded page

Web page

Algorithm

119. 25. A(n) is also known as a query.

Index

Search phrase

Boolean operator

Web crawler

120. ____ 27. You search the Web using the term health and informatics not education. What result below best matches your search?

Health network

Health informatics

Health informatics educational opportunities

Informatics and health

121. ____ 28. What does it mean when a Web site is at the top of a search results list?

Web crawler HTTP results best match Boolean operators used.

The top site paid Google the least amount of money for that ranking.

Keywords on that site best matched the search terms used.

Either A or C

122. 29. A router is a device that .

Sends traffic from a private network to the Internet

Sends traffic from the Internet a private network

Is utilized only by home networks

Both A and B

123. 30. Installing updates is important to securing your operating system from attack.

Optional

Crucial

Critical

Recommended

124. ____ 32. What is the preferred method to use when closing a suspicious Web site popup window?

Press Alt + F4

Click to close the popup window

Shut down the computer

Close all browser windows

125. 33. permit(s) or deny a computer the ability to connect to another computer.

Antivirus software

Firewalls

Operating systems

Viruses

126. 35. A complex password should include at least characters.

Six

Nine

Five

Eleven

127. 45. HIPAA requires that health care providers, insurance companies, and employers .

Abide by privacy and security standards

Provide employers with medical information required to make hiring decisions

Store medical records in electronic formats

Both A and C

128. 2. The motherboard is made up of circuitry and thousands of copper wires known as ____.

Binary code

RAM

Buses

Chips

129. 3. The motherboard contains ____ slots, into which device expansion cards are inserted.

RAM

SATA

AGP

PCI

130. 6. A(n) ____ jack is used to connect a network cable to a network interface card.

RJ-11

802.11N

RJ-45

Either A or C

131. 8. Hard disk storage is known as ____ storage.

Secondary

Volatile

Nonvolatile

Primary

132. 9. RAM is installed ____.

On the motherboard

In PCI slots

Within the CPU

In SATA slots

133. 10. The operating system is stored ____.

In RAM when the computer is running

On the hard disk

Either A or B

None of the above

134. 11. What is a CT scan?

A nuclear medicine imaging device that produces a 3-D image.

A device that creates an image based on sound waves.

An x-ray, using specialized equipment, that takes cross-sectional pictures of the body.

Magnetic imaging equipment that uses a radio frequency pulse to create an image.

135. 12. What is a PET scan?

A nuclear medicine imaging device that produces a 3-D image.

An x-ray, using specialized equipment, that takes cross-sectional pictures of the body.

A device that creates an image based on sound waves.

Magnetic imaging equipment that uses a radio frequency pulse to create an image.

136. 16. 1024 bytes x 1024 x 1024 = ____.

1 KB

1 GB

1 TB

1,024 KB

137. 19. Roughly how much storage does a chest x-ray require?

35 megabits

20 megabits

30 megabytes

20 megabytes

138.

There are two types of software: application and _________ software.

A. System

B. Multimedia

C. Process

D. Utility

139.

Which of the following is an example of business software?

A. Video games

B. Electronic medical records

C. Recipe manager

D. Project management software

140.

Select all of the following that are examples of healthcare software.

A. EHRs and EMRs

B. Health Information Systems

C. Imaging

D. Statistical software

A,b,c

141.

Which of the following is NOT true about an operating system?

A. It is a set of programs that coordinate all activities of hardware resources.

B. It is the layer between the application software and the hardware.

C. It is unique to each individual computer hardware system.

D. There is only one operating system available for all computers.

142.

A ________ interface is one where the user types in all the commands.

A. Command line

B. Graphical User

C. BIOS

D. Windows

143.

A(n) ________ is a way of organizing files and their data.

A. Operating system

B. File manager

C. BIOS

D. File system

144.

Which of the following are examples of file utilities? Select all that apply.

A. Search

B. File compression

C. Backup

D. Read

Submit

145.

Disks are formatted into _____, which make up tracks.

A. Heads

B. Arms

C. Sectors

D. Addresses

146.

Which of the following operating systems support the NTFS file system? Select all that apply.

A. Microsoft Windows Vista

B. Microsoft Windows 7

C. Microsoft Windows XP

D. Microsoft Windows 95

Submit

147.

Folders and directories are logically the same thing.

True

False

148. 3. iPhone OS is an example of _______.

A machine-based or independent Operating system

Mobile-based or embedded operating system

Server-based operating system

Personal efficiency softwarePersonal efficiency softwarePersonal efficiency softwarePersonal efficiency softwarePersonal efficiency softwarePersonal efficiency software

149. 5. Mac OS is an example of _______.

A machine-based or independent Operating system

Mobile-based or embedded operating system

Server-based operating system

Personal efficiency software

150. 6. Machine code is a _______ language.

Binary

Legacy

Scripting

Object oriented

151. 8. COBOL is a _______ language.

Binary

Legacy

Scripting

Object oriented

152. 10. SQL is a _______ language.

Binary

Data oriented language

Scripting

Object oriented

153. 16. The half-life of software has the most effect on what phase of a program's life cycle.

Design

Implementation

Obsolescence

Maintenance

154. 18. Pseudocode is an example of a(n) ____________ design tool.

Sequential

Object

Text-based

Graphical

155. 22. Which of the following is a translation process that translates an entire program and creates an executable module?

Sequential

Compiler

Interpreter

Structured execution

156. 23. Which type of error may require a programmer to redo their pseudocode solution?

Logic

Missing keyword

Misspelled word

Syntax

157. 25. A syntax error is most like a ___________.

Run on sentence

Standing in two lines at once

Loop process that has no way to end

Improper sequence of events

158. 29. A value that cannot be changed while a program is running is called a ________.

Variable

Constant

Array

Passed variable

159. 31. Data that can be derived is called ________ data.

Variable

Secondary

Primary

Passed

160. 35. The character set of A-Z is contained in what data type?

Numeric and alphabetic

Numeric and alphanumeric

Numeric

Alphabetic and alphanumeric

161. 37. Which data type is used more often in programming for A-Z?

Numeric

Literal

Alphanumeric

Alphabetic

162. 38. The number of minutes in a day (24 hour period) is a good candidate for being declared as a _______?

Constant

Literal

Variable

Secondary data

163. 39. A structured programming language statement could possibly be used for all but which of the following ?

Statements that define variables, constants, and files

Statements that execute code repetitively

Unconditionally branch to another statement

Statements that assign values to variables

164. 40. A programming logic construct that may either do something or not based on a conditional test is known by all but which of the following?

Selection

Choice

If-Then-Else

Alternation

165. 41. A programming logic construct that executes code over and over again while or until a certain condition test is satisfied is known by all but which of the following?

Continue

Repetition

Iteration

Looping

166. 43. Two processes that are executed at the same time are said to be executed _________.

In unison

Together

Independently

Concurrently

167. 45. A programming logic construct that executes code one statement after the other as they are written in the program is called _____________.

Sequence

Concurrency

Alternation

Iteration

168. 46. A programming logic construct that provides for exclusive options of code to be executed is called __________.

Sequence

Concurrency

Alternation

Iteration

169. 47. A form of a programming logic construct that only evaluates a conditional test based on the results of a prior conditional test is called which of the following?

Nested alternation

Simple alternation

Case structure alternation

Compound alternation

170. 50. A form of a programming logic construct that involves one conditional test or at most two exclusive options and that doesn't involve an AND or an OR operator is called which of the following?

Nested alternation

Simple alternation

Case structure alternation

Compound alternation

171. 54. A logic error that executes code repetitively and limitlessly?

Pre-test loop

Post-test loop

Endless loop

Continuous

172. 57. A statement that jumps to another module without any strings attached as to what to do when the machine is finished executing the invoked module illustrates what kind of branching?

Conditional branching

Unconditional branching

Modular structure branching

Blind branching

173. 59. Which form of branching is conducive to structured design?

Conditional branching

Unconditional branching

Modular structure branching

Blind branching

174. 60. Another name for unconditional branching is ____________.

Endless loop

Spaghetti

GoTo

Blind branching

175. 63. A class can contain which of the following?

Variables and modules

A customer’s name like “Sam Jones”

Domains and literals

Attributes and methods

176. 65. The things that an object can do are referred to as ________.

Methods

Attributes

Variables

Modules

177. 4. The purposes of a database include all of the following EXCEPT . . .

A. Acquire data.

B. Provide internal security.

C. Retrieve data on command.

D. Data is never repeated.

178. 8. What database term involves connecting two or more tables together when a user needs data from more than one table in the database?

A. Sweeping

B. Conduit

C. Concatenation

D. Relationship

179. 9. A surrogate key is most similar to which of the following?

A. Natural key

B. Foreign key

C. Candidate key

D. Door key

180. 11. A natural key is . . .

A. A well-known attribute value that uniquely determines a row in a table.

B. An automatically generated numeric value that uniquely determines a row of a table.

C. A unique key from another table.

D. A key that not the primary key.

181. 17. Primary keys can be selected from a list of . . .

A. Natural keys

B. Surrogate keys

C. Candidate keys

D. Foreign keys

182. 20. Testing of the database can be accomplished by which of the following?

C. Create a small test version of the database where queries can be executed and the results monitored.

D. Testing is not important since users will have been involved throughout the entire process.

183. 22. Attributes must depend on the ____of the entity to which they belong.

A. Primary key

B. Foreign key

C. Relationship

D. Domain

184. 27. It is best if primary keys . . .

A. Are composite

B. Do not change in value

C. Can be used for all tables in the database

D. Are shared

185. 29. An example of a one-to-one relationship is which of the following?

A. Patient to Doctor

B. Nurse to work shift

C. Drug to pharmaceutical company

D. Patient to Hospital wrist band ID

186. 33. In a super to subtype relationship attributes of the super type are which of the following?

A. incompatible with the subtypes

B. mirror images of the subtypes

C. have identical attributes to the attributes of the subtypes

D. inherited by the subtypes

187. 35. SQL cannot do which of the following?

A. Update the contents of a database

B. Identify the user of the system

C. Query a database for information

D. Execute intrinsic functions

188. 37. The first phase in database development is which of the following?

A. data modeling

B. testing

C. deployment

D. specification gathering

189. 39. The Referential Integrity Constraint is which of the following?

A. making sure that data is within the domain of the attribute

B. making sure that a foreign key value is also a value in the primary key to which it belongs

C. making sure that the user has permission to access data that they have requested

D. making sure that the user is who they say they are

190. 40. An attribute is said to be functionally dependent on another attribute if . . .

A. both attributes can be determined by another attribute

B. the attribute can be determined by the other attribute

C. both attributes are candidate keys

D. both attributes are non-unique keys

191. 41. Constraints are which of the following?

A. ways of making sure that attributes are related.

B. making sure that attributes can be considered candidate keys

C. making sure that attribute values follow rules

D. limiting user access to the database

192. 42. First normal form of the Normalization process involves which of the following?

A. making sure that data within a row when deleted will not eliminate data that will be needed later.

D. Columns of data are uniquely named and contain only one piece of data.

193. 43. Second normal form of the Normalization process involves which of the following?

A. making sure that data within a row when deleted will not eliminate data that will be needed later.

B. Columns of data are uniquely named and contain only one piece of data.

C. Eliminating transitive dependencies

D. Making sure that every determinant is a candidate key

194. 46. In the final design which element of the ER-diagram a name for a piece of data in the database?

A. attribute

B. relationship

C. entity

D. domain

195. 47. SQL is used to create tables (True or False).

True

False

196. 49. SQL is used to create relationships (True or False).

True

False

197. 53. "Count" is which of the following?

A. type of statement

B. function

C. clause

D. transaction processing statement

198. 55. Which of the following best describes a subquery?

A. The projection of one query is passed as input to another query.

B. The values in one table are combined with the values in another table.

C. All of the data from one table is projected.

D. None of the data from any tables are projected.

199. 56. In transaction processing changes to the database can be retracted before the end of the transaction is reached (true or false).

True

False

200. 3. A wired network connection requires the use of:

A. NIC, WAP, switch, router.

B. Wireless NIC, WAP, router

C. NIC, copper cabling, switch, router.

D. NIC, WAP, switch.

Comp4

1. A dishwasher has an embedded computer.

2.

What first name or nickname would you like us to use?

2. Speakers are an example of a computer output device.

3. ____ 4. The ____ is a collection of interconnected documents and other resources, linked by hyperlinks and URLs.

4. ____ 5. From the list provided below, select a valid URL.

5. ____ 6. The WWW was created in ____ by Dr. Tim Berners-Lee and others with the introduction of the Web browser and Web page coding.

6. ____ 7. A(n) ____ is a software program that lets a user use Web server resources over the Internet.

7. ____ 9. A Web server sends ____ back to the browser, which translates it for display on a monitor.

8. ____ 10. HTML is a(n) ____.

9. ____ 11. HTTP is a(n) ____.

10. ____ 12. The Internet is owned by ____.

11. ____ 13. What is required for a device to communicate over the Internet?

12. ____ 15. The Domain Naming System maps a(n) ____ to a domain name.

13. ____ 17. The slowest type of Internet connection is the ____ connection type.

14. ____ 18. The global standard governing wireless technologies is the ____ standard.

15. ____ 19. Home networks usually connect to the Internet through the use of the services provided by a(n) ____.

16. ____ 20. A typical home network connecting to the Internet uses ____ IP addressing.

17. ____ 24. How does a search engine provide you with a result set?

18. ____ 26. Examples of Boolean operators include the terms ____.

19. ____ 31. Antivirus software works by recognizing ____ and stopping those things from causing harm to your computer.

20. ____ 34. Some experts recommend ____ first party, ____ third party, and ____ session cookies.

21. ____ 39. Macro viruses are usually associated with ____ files.

22. ____ 46. One difference between PHRs and EHRs is that PHRs are ____.

23. ____ 48. Patient medical records should be send electronically in a(n) ____ format.

24. ____ 49. According to HIPAA rules, who can view your medical information without a signed release?

25. 1. The main function of a computer is to ____.

26. 4. Today's computers connect the mouse and keyboard via a(n) ____ slot.

27. 13. What is an MRI?

28. 14. A binary digit value of one (1) indicates that electricity is ____.

29. 15. In the binary number "01011010", the rightmost value of "0" is a placeholder for ____.

30. Which of the following is NOT a form of software that is free?

31. Which of the following is NOT an example of word processing software?

32. Select all of the following that are examples of communications software.

33. When would you need a new device driver? Select all of the following that are reasons you'd need a new driver.

34. _________ is a way that OS give the illusion of a large memory.

35. What is the latest version of Microsoft Windows OS?

36. The file _______ identifies the file type.

37. Files that are stored in non-contiguous clusters are called __________ files.

38. The most important software on your computer is the operating system.

39. Copying software from a friend is always okay.

40. The device driver for your printer will need to be updated when you do a major upgrade of your operating system.

41. 4. Windows Server 2008 is an example of _______.

42. 9. An Applet is an example of a _______ language.

43. 15. The requirements analysis phase of the SDLC can involve all but the following.

44. 26. A thorough testing phase will catch ___________.

45. 27. The consequences of an error in a health care application _____________.

46. 34. The kind of data stored in memory is described to the computer as a ________.

47. 36. The character set of 0-9 is contained in what data type?

48. 42. Most (if not all) scientific, business, industry, health care and personal use computer problems can be solved with just the three following logic constructs.

49. 12. A foreign key is . . .

50. 14. What language is used to store and retrieve data from a database?

51. 15. The most important source of specifications for database development is obtained from which of the following?

52. 19. The data model is best described as which of the following?

53. 28. Natural keys have the advantage over surrogate keys of which of the following?

54. 31. An example of a many-to-many relationship is which of the following?

55. 36. SQL commonly produces or projects which of the following?

56. 38. Which of the following is involved in data modeling?

57. 44. Which normal form is commonly considered to be all that is necessary for most database situations?

58. 48. SQL is used to create a database (True or False).

59. 51. The SQL statement used to retrieve data from a database is which of the following?

60. 1. From the choices below, select the best definition of a network.

61. 2. A(n) _____ connection requires the services of an ISP.

62. 6. A _____ IP address can change when you reboot your ISP device.

63. 7. Private IP addresses _____.

64. 15. A _____ topology describes how a network is actually designed and laid out across a campus.

65. 21. A(n) _____ protects a device from spikes in power usually originating with the power company.

66. 1. A neighbor becomes aware of a medical condition you have been privately battling for the past six months. The neighbor says that if you do not pay her $5,000, she will use a pay phone to disclose this information to your father. This is an example of _____.

67. 10. Network security revolves around the setup and use of _____ to control who and how objects are utilized.

68. 11. An authenticated object is an object that _____.

69. 12. An example of authentication is when a user _____.

70. 18. Software and/or hardware that blocks unauthorized communications on a computer is referred to as a(n) _____.

71. 19._____ protect(s) a computer by locating and stopping programs attempting to harm computer operation.

72. 22. A simple step to secure data from those who do not have permission view it is to _____.

73. 23. A complex password contains at least 6 characters, made up of at least: 1-upper case, 1-lower case, 1-number, and 1- _____ character.

74. 27. The U. S. Government would like to implement electronic health records for most Americans by the year _____.

75. 28. Health information is stored as a(n) _____ in an EHR.

76. 29. HIPAA requires that health care providers, insurance companies, and employers abide by _____ standards.

77. 33. When users enter data on Web forms, the data should be _____ before it is saved to the database.

1.

A dishwasher has an embedded computer.

2.

Speakers are an example of a computer output device.

3. 4. The is a collection of interconnected documents and other resources, linked by hyperlinks and URLs.

5. 6. The WWW was created in by Dr. Tim Berners-Lee and others with the introduction of the Web browser and Web page coding.

6. 7. A(n) is a software program that lets a user use Web server resources over the Internet.

7. 9. A Web server sends back to the browser, which translates it for display on a monitor.

8. 10. HTML is a(n) .

9. 11. HTTP is a(n) .

10. 12. The Internet is owned by .

12. 15. The Domain Naming System maps a(n) to a domain name.

13. 17. The slowest type of Internet connection is the connection type.

14. 18. The global standard governing wireless technologies is the standard.

15. 19. Home networks usually connect to the Internet through the use of the services provided by a(n) .

16. 20. A typical home network connecting to the Internet uses IP addressing.

18. 26. Examples of Boolean operators include the terms .

19. 31. Antivirus software works by recognizing and stopping those things from causing harm to your computer.

20. 34. Some experts recommend first party, third party, and session cookies.

21. 39. Macro viruses are usually associated with files.

22. 46. One difference between PHRs and EHRs is that PHRs are .

23. 48. Patient medical records should be send electronically in a(n) format.

30.

Which of the following is NOT a form of software that is free?

31.

Which of the following is NOT an example of word processing software?

32.

Select all of the following that are examples of communications software.

33.

When would you need a new device driver? Select all of the following that are reasons you'd need a new driver.

34.

_________ is a way that OS give the illusion of a large memory.

35.

What is the latest version of Microsoft Windows OS?

36.

The file _______ identifies the file type.

37.

Files that are stored in non-contiguous clusters are called __________ files.

38.

The most important software on your computer is the operating system.

39.

Copying software from a friend is always okay.

40.

The device driver for your printer will need to be updated when you do a major upgrade of your operating system.

92.

Which part of the computer is its "brain"?

93.

Where are programs stored when they are running?

94.

What is the most important software that runs on your computer?

95.

Which of the following are example(s) of personal computers? Select all that apply.

96.

Which of the following is an input device for a personal computer?

97.

When was the World Wide Web first developed?

98.

What was the first use of electronic medical records?

99.

Where can you find up to date information about current computing systems? Select all that apply.

100.

What was the first personal computer?

101.

Personal computers were first developed in the 1970s.

102. 1. The is a global system of computer networks that communicate using TCP/IP and is a large network made up of many smaller networks.

103. 2. The Internet began because .

111. 30. Privacy is to _ as confidentiality is to _.

113.

A computer is:

114.

Which of the following are important factors to consider when selecting a computer? Select all that apply.

115.

What technology was used in the first general purpose electronic computers?

116. 8. A browser uses to communicate with Web servers.

118. 23. A(n) is a set of instructions set out logically to solve a problem.

119. 25. A(n) is also known as a query.

122. 29. A router is a device that .

123. 30. Installing updates is important to securing your operating system from attack.

125. 33. permit(s) or deny a computer the ability to connect to another computer.

126. 35. A complex password should include at least characters.

127. 45. HIPAA requires that health care providers, insurance companies, and employers .

138.

There are two types of software: application and _________ software.

139.

Which of the following is an example of business software?

140.

Select all of the following that are examples of healthcare software.

141.

Which of the following is NOT true about an operating system?

142.

A ________ interface is one where the user types in all the commands.

143.

A(n) ________ is a way of organizing files and their data.

144.

Which of the following are examples of file utilities? Select all that apply.

145.

Disks are formatted into _____, which make up tracks.

146.

Which of the following operating systems support the NTFS file system? Select all that apply.

147.

Folders and directories are logically the same thing.