Fund of Info Tech Final Exam Study Guide
Which of the following is not a method of cloud deployment" A) Hybrid B) Co-Channeled C) New Deployment D) Lift & Shift
Co-Channeled
An Excel spreadsheet is an example of a(n) ________ database. A) object-oriented B) flat C) relational D) hierarchical
flat
The SDLC follows the development of a system from planning to the final stage, ________. A) maintenance B) implementation C) analysis D) design
maintenance
What project was coordinated by the U.S. Department of Energy and the National Institutes of Health? A) ARPANET B) Integrated Automated Fingerprint Identification System C) Combined DNA Index System D) Human Genome Project
Human Genome Project
________ is similar to the way people think, acknowledging that not everything can be answered as a yes or no question. A) Fuzzy logic B) An expert system C) A neural network D) Neural logic
Fuzzy logic
Which of the following is not a type of programming error? A) Syntax B) Runtime C) Logic D) Grammatical
Grammatical
Which of the following is not a common LAN topology? A) Star B) Bus C) Hierarchical D) Ring
Hierarchical
Which statement about email is false? A) Copies of your email may exist on several servers even after the recipient deletes it. B) Your employer may read your email at your work. C) It cannot be accessed by hackers. D) Email can be used for targeted marketing.
It cannot be accessed by hackers.
Cloud governance includes: A) Monitoring, Security Patching, Funding B) Installation, Monitoring & Deployment C) System Tuning, Database Administration, User Experience D) Monitoring, Management, Security, Finance E) All are part of governance
Monitoring, Management, Security, Finance
What is not true about Twitter? A) Posts can be as long as you want. B) Posts are called Tweets. C) Twitter users have followers. D) Hashtags allow your posts to be searchable.
Posts can be as long as you want.
Employees who are traveling can connect securely to their office network through the Internet when a ________ has been established. A) PAN B) LAN C) VPN D) WLAN
VPN
A company with offices in Buffalo and Seattle would use dedicated ________ lines to connect the two offices. A) PAN B) WLAN C) WAN D) MAN
WAN
When sending one email to everyone in your address book, you should use the ________ field to keep their addresses private. A) To B) Cc C) Subject D) Bcc
Bcc
Fifth-generation programming languages are primarily used in ________ applications. A) binary B) SaaS C) artificial intelligence D) webpage
artificial intelligence
In a transaction-processing system, ________ insures that transactions are either completed or not begun. A) consistency B) atomicity C) isolation D) durability
atomicity
A ________ changes your home page and redirects you to other websites. A) zombie B) browser hijacker C) rootkit D) botnet
browser hijacker
A ________ network is one that has at least one computer that provides centralized management, resources, and security. A) homegroup B) peer-to-peer C) workgroup D) client-server
client-server
A(n) ________ improves over time by learning from its interactions. A) knowledge base B) cognitive computing system C) decision support system D) inference engine
cognitive computing system
An email claiming that you have won a lottery might be an example of ________. A) cyberbullying B) computer fraud C) cyber-stalking D) cyber-harassment
computer fraud
The cyberbullying of one adult by another adult, using a computer is known as ________. A) pharming B) phishing C) stalking D) cyber-harassment
cyber-harassment
The part of the web that is encrypted and hidden is known as the ________. A) deep web B) surface web C) clear web D) dark web
dark web
A doctor may use a(n) ________ to help diagnose an illness. A) knowledge base B) neural network C) expert system D) clone
expert system
A ________ can be set by an employer to prevent you from accessing eBay. A) switch B) firewall C) router D) wireless access point
firewall
A ________ could be used to retrieve all the phone numbers from a student database. A) table B) record C) query D) form
query
________ is responsible for addressing and routing packets of data to their destination. A) Internet Protocol B) FTP C) HTTP D) POP
Internet Protocol
Machine language is written in ________. A) binary B) C++ C) assembly language D) Java
binary
When you set up your wireless router, you should change the ________, which is also called the wireless network name. A) WAP B) SSID C) NAT D) WEP
SSID
________ sites let users evaluate hotels, movies, games, books, and other products and services. A) Social bookmarking B) Really Simple Syndication C) Captcha D) Social review
Social review
The desired output from the ________ phase of the SDLC is a list of requirements for a new system. A) analysis B) maintenance C) planning D) design
analysis
A ________ is similar to an online journal, in which you can write about anything you want to share. A) bulletin B) log C) chronicle D) blog
blog
Knowledge engineers develop ________, which are programmed to make decisions in real-life situations. A) fuzzy logic B) clones C) knowledge bases D) expert systems
expert systems
A graphic view of an algorithm is called a ________. A) structure chart B) flowchart C) Venn diagram D) Gantt chart
flowchart
The # symbol used by Twitter is called a(n) ________. A) hashtag B) avatar C) forum D) digital footprint
hashtag
When you enter your credit card information in a website, you know the website is encrypted when you see ________ in the address bar. A) https B) http C) shttp D) ssl
https
A network that covers a single geographic area is known as a ________. A) local area network (LAN) B) campus area network (CAN) C) metropolitan area network (MAN) D) wide area network (WAN)
metropolitan area network (MAN)
A ________ contains the information for a single entity in the database. A) table B) record C) field D) cell
record
In a database, title, author, publication date, and ISBN are examples of ________. A) records B) fields C) tables D) queries
records
To secure your wireless network at home, you should ________. A) back up the computers on the network B) password-protect important document files C) set the SSID to CLOSED D) use wireless encryption with a difficult passphrase
use wireless encryption with a difficult passphrase
A data ________ rule would prevent a user from entering text in a date/time field. A) manipulation B) validation C) monitoring D) redundancy
validation
The SDLC, the traditional model for system development, is also called the ________ model. A) spiral B) whirlpool C) Gantt D) waterfall
waterfall
Hacking to make a political statement is called ________. A) politicking B) sneaking C) cracking D) hacktivism
hacktivism
An expert system is a computer programmed to ________. A) use SQL statements to respond to requests B) make decisions in real-life situations C) search the web for experts D) present possible decision outcomes
make decisions in real-life situations
Data in a ________ database are stored in data cubes. A) multidimensional B) relational C) hierarchical D) flat
multidimensional
In the ________ phase of the SDLC, the project team is assembled and the feasibility studies are completed. A) analysis B) planning C) maintenance D) implementation
planning
The ________ database is the most popular type used by businesses. A) hierarchical B) relational C) multidimensional D) flat
relational
When you trust the collective opinion of a crowd of people rather than an expert, it is known as ________. A) crowdsourcing B) wisdom of the crowd C) crowd sampling D) cross-referencing
crowdsourcing
Which is a type of data that can be stored in an object-oriented database? A) Documents and spreadsheets B) Documents C) Spreadsheets D) Images, audio, and video
Images, audio, and video
In what phase of the SDLC does testing occur? A) Implementation B) Analysis C) Maintenance D) Design
Implementation
In what phase of the SDLC does user training take place? A) Analysis B) Planning C) Maintenance D) Implementation
Implementation
Which of the following is a method of synchronous online communication? A) Instant messaging B) Email C) Forum D) Newsgroup
Instant Messaging
________ allows you to communicate with one or more people at a time. A) Instant messaging B) Really Simple Syndication (RSS) C) User-generated content D) Secure Sockets Layer (SSL)
Instant messaging
Which of the following is not true about Rapid Application Development? A) It begins with pre-defined requirements. B) It uses prototyping and user testing of the designs. C) Multiple prototypes are created. D) It uses object-oriented programming.
It begins with pre-defined requirements.
Which of the following is a client-side programming technology? A) Perl B) PHP C) JavaScript D) ASP
JavaScript
________ allows the user to selectively extract data from different viewpoints. A) An office support system (OSS) B) A transaction-processing system (TPS) C) Online analytical processing (OLAP) D) A decision support system (DSS)
Online analytical processing (OLAP)
The ________ is a set of five steps that a programmer follows to create a computer program. A) Software Design Lifecycle B) Program Development Cycle C) Program Design Lifecycle D) Computer Programming Cycle
Program Development Cycle
Which of the following is not a SQL relational keyword? A) WHERE B) QUIT C) FROM D) SELECT
QUIT
SaaS stands for: A) Security as a Service B) Software automatic augmentation Service C) Software as a Service D) Synchronization as a Service
Software as a Service
________ technology is used for sending email messages. A) Forward-and-push B) Store-and-forward C) Get-and-put D) Push-and-pull
Store-and-forward
Which would make the best primary key in a table? A) Last name B) Student ID C) First name D) Street Address
Student ID
A ________ appears to be a legitimate program, but is actually something malicious. A) Trojan horse B) worm C) rootkit D) botnet
Trojan horse
________ is an example of a microblogging site that allows a limited number of characters in a post. A) The Blogosphere B) Blogger C) Twitter D) Flickr
In blockchain, each block has a unique ________ that converts the data into an encrypted output of a fixed length. A) block B) chain C) code D) hash
hash
A database is a collection of ________ that has been organized in a meaningful way. A) spreadsheets B) files C) information D) documents
information
A ________ error is an error in programming design that results in an unexpected outcome. A) syntax B) grammatical C) logic D) runtime
logic
To ensure that a person does not misspell Wednesday in a field, a(n) ________ list can be used. A) lookup B) Find feature C) master D) inference
lookup
Cloud Contraction enables the cloud tenant to: A) avoid costs associated with hardware upgrades B) lower the cost of their products when demand increases C) reduce resources when demand slows
lower the cost of their products when demand increases
Microsoft Office is an example of a(n) ________. A) geographic information system (GIS) B) office support system (OSS) C) transaction-processing system (TPS) D) Structured Query Language (SQL)
office support system (OSS)
Each computer is considered equal in a ________ network. A) client-server B) wide area C) virtual private D) peer-to-peer
peer-to-peer
An email supposedly from your bank asking for your password so that it can troubleshoot your account is a form of ________. A) pharming B) cyber-stalking C) cyberbullying D) phishing
phishing
The rules for communication between network devices are called ________. A) firewalls B) protocols C) packets D) domains
protocols
To print data or display it in an easy-to-read format, a ________ can be used. A) report B) table C) record D) form
report
If you want to connect your home network to the Internet, you will need a ________ in addition to a modem. A) repeater B) router C) terminator D) switch
router
When a company pays people to hack into its own system, it calls in ________ hackers. A) green-hat B) black-hat C) gray-hat D) white-hat
white-hat
In an office acceptable use policy (AUP), which of the following might be prohibited? A) Checking work email B) Purchasing business supplies online C) Logging in to eBay D) Viewing an associate's electronic calendar
Logging in to eBay
A Facebook ________ is used to promote an organization, a product, or a service. A) Page B) Account C) profile D) user
Page
________ conveys the steps of an algorithm using English-like statements that focus on logic, not syntax. X) Quasicode B) Pseudocode C) Virtual code D) Structured code
Pseudocode
A GIS can be used by local municipalities to ________. A) capture criminals B) budget for waste management facilities C) warn citizens of weather-related events D) design emergency routes
design emergency routes
A data ________ defines the fields in a database and the type of data that each field contains. A) mine B) dictionary C) warehouse D) reference
dictionary
All the information someone can find out about you by searching the web is called your ________. A) avatar B) folksonomy C) tagged information D) digital footprint
digital footprint
When one business provides services for another, it is a type of e-commerce called ________. A) C2B B) C2C C) B2B D) B2C
B2B
When you buy a textbook online from Amazon.com, you are participating in ________ e-commerce. A) B2B B) C2A C) A2C D) B2C
B2C
________ raises money from multiple small investors rather than a few large ones. A) Crowdresourcing B) Crowdborrowing C) Crowdfunding D) Crowdsourcing
Crowdfunding
Which cybercrime is considered to be a form of harassment? A) Pharming B) Clickjacking C) Cyber-stalking D) Phishing
Cyber-stalking
________ is an unlawful attack on computers or networks done to intimidate a government or its people. A) Cybercrime B) Computer fraud C) Cyber-stalking D) Cyber-terrorism
Cyber-terrorism
Which generation of programming languages is closer to natural language but still requires some programming knowledge? A) Fourth-generation B) Third-generation C) Fifth-generation D) Second-generation
Fourth-generation
________ is a social network that is designed for business connections. A) Facebook B) Twitter C) LinkedIn D) Yahoo!
An email ________ is a block of text that is automatically put at the end of your messages. A) closing B) salutation C) identifier D) signature line
signature line
Junk email is also known as ________. A) spam B) spim C) malware D) phishing
spam
You should use a(n) ________ account for everyday computing on a computer running Windows. A) guest B) standard C) visitor D) administrator
standard
If you misspell a command word in a computer program, you have created a ________ error. A) runtime B) semantic C) syntax D) logic
syntax
In a database, a ________ stores data in rows and columns. A) field B) table C) cell D) matrix
table
C++ is an example of a ________-generation language. A) fourth B) fifth C) third D) second
third
Which is the correct order of the phases in the SDLC? A) Requirements, analysis, design, implementation and testing, maintenance B) Requirements, planning, design, implementation, testing C) Planning, analysis, design, implementation and testing, maintenance D) Planning, requirements, design, implementation, testing
Planning, analysis, design, implementation and testing, maintenance
To connect peripherals at short ranges, you would use the ________ wireless technology. A) Ultraviolet B) Bluetooth C) Infrared D) RFID
Bluetooth
________ is the process of converting an algorithm into a language the computer can understand. A) Debugging B) Flowcharting C) Coding D) Writing
Coding
Which of the following IS NOT a reason to adopt the cloud A) Reduction of operating costs B) Reduction of capital expenditures C) Quicker development D) Greater technical stability
Reduction of operating costs???orGreater technical stability
Which statement about cookies is false? A) They are used by websites to identify you. B) They are small text files. C) They cannot collect information you do not want to share. D) They can be installed without your knowledge.
They cannot collect information you do not want to share.
________ is one of the largest online video-hosting sites in the world. A) Flickr B) OneDrive C) Skype D) YouTube
YouTube
Procedural programming involves ________. A) writing executable pseudocode B) defining objects and the actions that can be performed on them C) a step-by-step list of instructions D) drawing flowcharts to ensure that procedures are followed
a step-by-step list of instructions
A router is a form of security because it ________. A) scans your email for malicious content B) implements User Account Control (UAC) C) scans webpages before displaying the content D) acts like a firewall
acts like a firewall
When using Windows to make changes, install hardware, or configure settings, you need to use the ________ account on your computer. A) client B) guest C) administrator D) master
administrator
