cgs 2060 final
select the usual tasks for Info systems program managers
-supervise IS technicians -working with developers and senior management to procure and implement IS processes -developing training plans and policies for IS
Which of these extensions, if you open it, will probably install software onto your computer? Be careful!
.exe
Which of the following file extensions is commonly used for drawings?
.gif
The 3 phases that should be accomplished in the investigation step of the SDLC include:
1. Defining the problem. What should this system do? Who will by using this IT system? 2. Examining alternatives. Can available hardware and software perform the same task? 3. Reporting. Document your investigation's findings.
The fifth step in the SDLC process is the system implementation phase. During this phase the new system is brought online. Select methods of converting an organization from an older IT system to a newer IT system.
1. Direct conversion - shutting down the old system completely and starting the new one. 2. Parallel conversion - running both systems side-by-side for a while and then shutting the old system. 3. Pilot conversion - starting the new system in one sector of the organization to ensure that it works smoothly.
Select what's true about packet Specialized hardware or software that capture packets transmitted over a network
1. Legitimate sniffers are used for routine examination and problem detection. 2. Unauthorized sniffers are used to steal information.
Select the Android operating systems.
1. Lollipop 2. marshmallow
Select the anti-virus software options.
1. Mcafee 2. Norton 3. AVG
There are several ways to rename a folder in Windows. Which of these would work?
1. On the command bar, click Organize and then click Rename. 2. Click the folder icon and press F2 to activate the edit mode. 3. Right-click a folder and click Rename.
Select the phases included in the system development step of the SDLC process.
1. Purchasing necessary software. 2. Purchasing needed hardware. 3. Setting up, installing, and testing system.
Select the qualities that make a trait useful for biometic recognition.
1. The trait must not change over time. 2. cannot change over time 3. must be measurably different
select the characteristics of a CD
1. holds approx 700 MB of data 2. uses pits and lands to store data
Select the characteristics of a OneDrive account
1. microsoft email account 2. provides free cloud storage 3. can serve as extra storage space
Select the features common in DSLR cameras.
1. often allow for interchangeable lenses 2. usually have a mirror that allows the photographer to look directly through the lens
Select the reasons for compressing a file.
1. reduce the bandwidth needed to transmit a file 2. reduce storage space requirements
a typical laptop has a strong capacity of approx
500 GB - 1 TB
2GL
Assembly language - an assembler converts 2GL into machine language.
To remove a file from one folder and place it in another, click on the item and press ___, then move your cursor to the new location and press CTRL + V.
CTRL + X
which of the following are considered storage media?
DVDs blu ray discs
A DDoS attack is when computers that have been infected by a virus act as "zombies" and work together to send out illegitimate messages creating huge volumes of network traffic. The acronym DDoS stands for ___ .
Distributed Denial of Service
5GL
Extremely advanced - uses statements (scripts) rather than algorithms.
a quick way to rename files or folders in Windows is to select the item and then press the ____ key
F2
While not technically a programming language, ___ refers to the protocols that allow content to display on the web.
HTML
3GL
High-level programming language - uses a compiler to convert into machine language.
a switch distinguishes between various devices within a network by their ______ addresses
MAC
which category of MIS combines the forecasting capacity of decision support software with the records keeping capability of transaction processing systems software to help businesses manage inventories efficiently?
SCMS
4GL
Specifically designed for creating database management programs.
which category of management info systems (MIS) focuses on tracking sales and inventories
TPS
examples of management info systems (MIS) include
TPS ESS DSS
PaaS (distribution)
The distribution of computer applications over the Internet. Commonly referred to as web apps.
spam messages are sometimes referred to as _________
UBE
What type of port do most digital devices use to attach peripherals?
USB port
URL stands for ___ Resource Locator.
Uniform
While not technically a programming language, ___ refers to the protocols that allow content to displayed on the web.
XML
select the advantages of using a database instead of a traditional filing system
a database can hold larger amounts of data a database can provide better data integrity
zip
a lossless compression format
Software that collects the user's web browsing history and uses the data collected to create unsolicited targeted pop-up advertisements is called
adware
which of these operating systems is based on the Linux and used on smartphones
android
if you believe you have fallen victim to a phishing scam you should
contact the institution the message was allegedly sent from contact US CERT
The first commercially available computer with a graphical user interface was NeXT's ___ computer.
cube
An integral part of a databases management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data ___ .
dictionary
A database that stores data in different physical locations and that users access though client/server networks is called a ___ database.
distributed
a database that stores data in different physical locations and that users access thru client/server networks is called a ________ database
distributed
DDoS stands for?
distributed denial of service
A ___ name identifies a server site on the Internet.
domain
The distance between two adjacent sub-pixels on a display is referred to as ___ .
dot pitch
When you drag a file into the Recycle Bin it cannot be recovered. T/F
false
a refracted laser beam striking a photo reactor from many different angles allows _______ storage to retain many bits of data in the same location
holographic
Which of these is found on iPhones and iPads?
iOS
select apple tablet offerings
iPad pro series ipad air series iPad mini series
phased
implements new areas of the system in a predetermined period of time
the role of installing, maintaining, repairing, and replacing info system hardware and software typically falls to the __________
info systems (info technology) technician
Rout kits allow a remote user to do which of the following
install rogue kits create backdoor programs delete files
Adam was in the fifth grade when he was adopted by the Smith's. Because his school used a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how a centralized database can help improve data ___ .
integrity
which of these browsers was developed by microsoft
internet explorer
what 3 items are needed to install a wifi network
internet signal modem router
A process that has an initial value, a process, and a test condition that can potentially return the program to the initial value is called a ___ .
loop
select the characteristics of fiber optic lines
made of 1 or thousands of fiber high speed transmission
The final step in the SDLC has two phases, a system audit and an evaluation phase. This final step is referred to as ___ the system.
maintaining
be careful to only open emails from senders you know and trust. __________ may be contained
malware
Because Microsoft Access includes not only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries and other capabilities, it is often referred to as a Database ___ System.
management
When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ___ subsystem.
manipulation
L3 cache
memory located adjacent to the processor
L1 cache
memory located directly on the processor itself
Disk Cache
memory used to increase a hard drive's efficiency
One advantage that the Samsung tablets have over the iPads is that you can add ___ to the Note or Tab.
microSD storage
By upgrading to it's maximum capacity of 16 GB of RAM and 1 TB of storage, the ___ tablet could be an extremely powerful computer!
microsoft surface pro 4
Megahertz is equal to one _____ cycles (or instructions) per second.
million
Because it locates cellular devices, assigns frequencies, transmits signals to the correct sites, the ___ is probably the most important part of any cellular network.
mobile switching station (MSS)
A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ___ database.
multidimensional
a storage device that uses lasers to read CDs, DVDs, or blu ray discs is referred to as an
optical drive
The BitTorrent protocol is often called ___ file sharing.
peer to peer
Using cells of ionized gas to create images, ___ displays are actually becoming less popular.
plasma
RFID stands for which of the following.
radio frequency identification
In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ___ .
record
which of the following are internet service options
satellite cable router
since it comes with a full computer operating system, some consider the ______ a laptop computer rather than a tablet computer
surface pro 4
Because Objective-C was difficult to write in, Apple developed ___ , a programming language for writing software for the Mac OS and the iOS.
swift
Connecting your phone to your laptop to transfer photos, videos, or music files is referred to as ___ .
syncing
A collection of related records in a database is referred to as a _____.
table
Which devices use a virtual keyboard?
tablet smartphone
HTML and it's 5th revision (HTML5) allow content to be displayed on ___ .
the world wide web
select the reasons you might add a microSD card to your smartphone
you want to save more music files you want to save more image files
Select the common video file formats.
.mov .avi
Select the common audio file formats.
.mp3 .mp4 .wav
Select the common word processing file extensions.
.odf .docx
Select what's true about database fields
1. A group of related characters in a database 2. Represents a characteristic of someone or something 3. Primary key is a field designation
Select what's true regarding all-in-one computers.
1. All-in-one computers house every component except the keyboard and mouse inside the same case as the monitor. 2. An all-in-one computer is a stationary device with a separate keyboard and mouse.
The system analysis step of the SDLC involves 3 phases. Select these three phases.
1. Data collection - gathering info about needs and existing hardware and software. 2. Analyze data - determine the system requirements. 3. Prepare the system specifications.
There are several ways to create a new folder in Windows. Which of these would work?
1. Right-click any blank area in the Contents pane. Click New and then click Folder. 2. Right-click a folder in the folders list. Click New and then click Folder. 3. On the command bar, click New folder.
The data definition, as described in the data dictionary, tells users how each unit of data is defined in the database. Which of the following elements will be used to describe the data?
1. What field name will the data fall under 2. What data type will be included
Which of the following are output?
1. a YouTube video displayed on a screen 2. an anti-lock brake system applying brakes
Select the methods of using cloud storage.
1. emailing a file to yourself 2. saving a photo on Flickr 3. purchasing online storage space
select the characteristics of a bluray disc
1. holds approx 25 gb of data 2. uses pits and lands to store data
Your college has a database with a Students table. Which of the following could be a primary key in the table?
1. student number 2. social security number
The final step in the system development life cycle is maintaining the system. Select the two phases of this step.
1. system audit 2. evaluation phase
Select the characteristics of a projector.
1. usually requires a darkened environment 2. allows large audiences to view digital output 3. usually used with a screen
How can you attach a mouse or other pointing device to your computer?
1. with a Bluetooth connection 2. with a wire through a USB port 3. with a WiFi connection
You can change your Firefox settings to allow you to
1.approve cookie storage requests. 2.deny cookie storage requests. 3.delete stored cookies automatically when you start Firefox.
SaaS (testing)
A programming environment used to develop, test, and disseminate web apps via the Internet.
A set of programs that allow data to be exchanged on a website without changing the website's display is ___ .
AJAX
business managers, copyright holders, and network administrators publish ________ so that users understand what is expected and permissible when they use the network computer equipment and/or software
AOPS
IaaS (business)
An organization uses servers in the cloud instead of buying and maintaining storage servers for their day-to-day business operations.
The 3rd generation programming language that most students learned when most computers used MS DOS was ___ . It remains a safe programming language for using 3rd party code and provides a coding standard that integrates easily with other programming languages.
BASIC
The coding step of the PDLC might use which of the following languages?
C++
which optical drive stores approx 700 mb of data
CD
If you have 2 folders open on your desktop and you want to copy a file from one folder to the other, hold down ___ and drag the file.
CTRL
One way to copy a file to a new location is to click on the file and press CTRL + C, then move your cursor to the new site and press ___ .
CTRL + V
Which of these programs make data more readable to programmers by parsing XML files?
JSON
A program that makes creating websites and webpages much faster is ___ .
Javascript
1GL
Machine language - represented by a series of 1s and 0s.
Broadband is measured in _____ .
Mbps
When you make an online purchase and enter your shipping or billing information, you're actually filling out a form that was generated by a database management system. The DBMS subsystem that allows for form creation is the ___ generation subsystem.
application
AJAX stands for ___ JavaScript and XML.
asynchronous
select the video compression formats
avi mp4 quicktime
The volume of data that can be carried on an Internet transmission media in an amount of time is called _____.
bandwidth
the capacity of a particular transmission medium is called its ___________
bandwidth
The final steps in the PDLC process include testing and documenting the software. When testing is conducted by potential customers of the software, it's referred to as a(n) ___ test.
beta
server banks have capacities measured in _____
betabytes
If it can be answered as either yes or no, or true or false, the question is called ___ .
binary
Once so commonly used that people even called it the "Crackberry", the ___ popularity dropped significantly in the U.S. after 2007.
blackberry
intrusion detections systems (IDS) are several techniques to protect networks. One is called "halt" which stops the hacker from progressing into the network. Another is called a __________ which closes the access point used by the hacker.
block
This technology provides short-distance wireless communication between electronic devices using extremely low power radio signals.
bluetooth
The two major factors that impact processor speed are clock speed and _____
bus width
In addition to the RAM, modern processors temporarily keep frequently accessed data in a _____.
cache
the first commercially available computer with a graphical user interface was NeXT's ___________
cube
Harming or harassing a person or group of people via information technology and networks in a repeated and deliberate manner is called _____.
cyberbullying
The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ___ subsystem.
data administration
What element of a database field specifies the data in a field such as text, numeric, or date/time?
data type
what element of a database field specifies the data in a field such as text, numeric, or data/time
data type
Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ___ .
database
The third step of the SDLC has 3 phases, specifically, developing several system proposals, selecting the most feasible proposal, and reporting on the selected system to be developed. This step is called the system ___ step.
design
When you ___ a file Windows should automatically open it. If it can't Windows will prompt you to select the correct app to open the file.
double click
routers than can send internet signals over 2 distinct frequencies are called _______ routers
dual band
which transmission has the lightest bandwidth
fiber optic
Defining the problem is the ___ step in the Program Development Life Cycle.
first
in the body of a professionally formatted business email, where should a request be placed?
first sentence of the body in email
A graphic representation of a process is called a ___ .
flowchart
In order to keep your files organized, it's a good idea to create ___ and place your files in them.
folders
when you need to link 2 tables in a database that don't have a field in common, one solution is to create a ________ in one table that links to the primary key in another table
foreign key
To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.
forms
which of these devices are manufactured by samsung?
galaxy note
The level of complexity of the programming language, or the degree from which it is separated from machine language itself, is called the ___ of the programming language.
generation
The visual image output that a computer creates is known as ____ .
graphics
A person who gains unauthorized access to networks and in order to steal and corrupt information and data is called a _____.
hacker
the act of hacking or breaking into a computer system for a politically or socially motivated purpose is called ______
hacktivism
Databases are built by starting with single characters of data, organizing the data into fields, organizing the related fields into records, the records then make up a table. This organization is referred to as a data ___ .
hierarchy
The first step in the SDLC involves defining the problems that the IT system should address, examining various alternatives, and reporting the findings. This is referred to as the ___ step.
investigation
Once the algorithm or plan has been created, the next step in the PDLC is to write the coding for the program. This highly structured process may be completed using which languages?
java C++ english
Spyware is software that collects information about your Internet surfing habits and behaviors. Spyware includes the collection of
keystrokes passwords confidential info
Another term for a programming code is a programming ___ .
language
Instructions (software) that allow a computer (hardware) to be used are written using specific symbols, letters and numbers known as a programming ___ or code.
language
select whats true about packet sniffers
legit sniffers are used for routine examinations and problem detection unauthorized sniffers are used to steal info
The process used to develop and maintain an IT system is referred to as the SDLC. SDLC stands for the System Development ___ Cycle.
life
The DBMS engine provides an interface for the end user of the database, Mis interface is called the ________ view
logical
The DBMS engine provides an interface for the end user of the database. This interface is called the ___ view.
logical
select whats true about trojan malware
often found attached to free downloads and apps often used to find passwords, destroy data, and to bypass firewalls
parallel
old and new systems run side-by-side for a while
Changing the appearance of your can make it easier to keep your information organized. To change your folder's appearance, first click on the folder, and then go to the command bar and click ___ .
organize
Paul Baran developed the technology called _____ switching that made the internet possible and reliable
packet
A type of phishing that seeks to obtain personal information through malicious software that is inserted on a victim's computer is called _______ .
pharming
A request for an electronic "echo" or response from another computer or server is called a ____.
ping
a request for an electronic echo or response from another computer or server is called a _______
ping
Written in natural language, but often including programming shorthand to assist in writing the program itself, ___ is the term that describes an intermediate step in creating an algorithm from a flowchart.
pseudocode
lossy
reduces space required by reducing redundancy within files
lossless
reduces space required by removing less valuable data
The type of database that uses common fields to create links between tables is called a ___ database.
relational
to display or distribute info from a database, programmers or database admins create _________
reports
the device that connects 2 networks is a ______
router
Because they're both Apple products, the browser that works smoothest with Macintosh OS X is ___ .
safari
You're tired of losing documents so you've decided to save your research paper to your desktop where you know you'll be able to locate it quickly. To save it to the desktop, you first click the File tab to open the file menu. Next you select ___ .
save as
The diagonal measure of the visible display is known as _____ .
screen size
To look for a file or folder in Windows 10, just type the file name in the __ box.
search
The two major concerns regarding cloud storage are reliability and ___ .
security
Pseudocode is written in natural language, but often including programming ___ to assist in writing the program itself. Pseudocode is the term that describes an intermediate step in creating an algorithm from a flowchart.
shorthand
direct
shuts down the old system and starts the new system
amateur computer hackers w/ little programming expertise that illegally gain access to computer systems using programs (scripts) that others have written are called ________
skript kiddies
A combination input and output device that allows users to interact with large computer displays that is sometimes found in classrooms is called an interactive whiteboard or a ___.
smartboard
Specialized hardware or software that capture packets transmitted over a network are called packet _____.
sniffers
Which of the following are online nuisances?
spam spyware spoofing
pilot
starts in one area of the organization and then is deployed to the rest of the organization
the component of a computer that allows data to be retained after power is turned off is referred to as
storage
select whats true about object oriented databases
store instructions for how to compute data as well as the data to be processed equipped to handle unstructured data such as MP4 files use object query languages to construct queries that extract data from the database
what group determines the standards for world wide web
the world wide web consortium (W3C)
The most common printers for printing receipts are ___ printers.
thermal
A programming design that breaks down a problem into a series of tasks is called ___ programming.
top down
match the business info systems (IT) activity with the appropriate management level
top level management - business executives and presidents(use it to monitor overall business performance) middle managers - use is for record keeping and reporting purposes first level managers(supervisors, floor managers) - use is for scheduling daily and weekly
Select the smartphone input device.
touchscreen or keyboard
one of the largest data requirements of the future will be
tracking patient's genomes
Often accompanying downloaded music or apps, programs that appear to be legitimate, but executes an unwanted activity when activated is called a _____.
trojan horse
By default Windows hides file extensions for known file types but you can unhide them if you wish.
true
whats true about passwords
use combo of letters, symbols, and numbers; the more characters you use, the more secure your password will be regularly check your accounts to ensure they haven't been tampered with
common types of malware are
viruses worms trojan horses
Select the functions of a Digital Signal Processor
1. analyzes signals received from the analog-digital converter to enhance audio quality 2. reduces unwanted noise 3. moderates call volume
Select the statements that are true regarding IP addresses.
1. assigned to your home network by your ISP 2. means by which your network is identified by other servers and computers on the Internet 3. ISPs often have blocks of IP addresses that they assign as demanded
Select the characteristics of a modem.
1. converts analog signals into digital signals 2. converts digital signals into analog signals 3. usually provided by the ISP
Select the statements that are true regarding Fiber Optic Internet service.
1. fastest home network option when available 2. not available in all areas 3. signal is carried by light waves so it's less subject to electromagnetic interference
Select the statements that are true regarding Cellular Internet service.
1. uses cell phone radio waves to transmit and receive Internet signals 2. Many providers offer data packages that may place limits on uploading and downloading. 3. Many smartphones can send and receive WiFi signal, allowing them to become hotspots.
Select the statements that are true regarding cable Internet service.
1. uses the same coaxial cable that brings the cable television signal 2. usually has more bandwidth than DSL lines 3. Internet service can often be bundled with television service
According to US-CERT if you receive a phishing message you should contact them using which of the following methods.
1.In Outlook Express, you can create a new message and drag and drop the phishing email into the new message. Address the message to [email protected] and send it. 2.In Outlook Express you can also open the email message* and select File > Properties > Details. The email headers will appear. You can copy these as you normally copy text and include it in a new message to [email protected]. 3.If you cannot forward the phishing message, at a minimum, send the URL of the phishing website to US-CERT.
Most touchpads use _____ to sense when a finger has moved across the pad.
capacitance
Clockspeed, also referred to as _________, is the speed at which the processor performs the operations required to run a digital device and instructions executed by the digital device.
clock rate
The malicious use of computer code to modify the normal operations of a computer or network is called a
cyberattack
Because he wanted to be able to sort gifts according to continent and time zone, in 1984 Santa switched from using long lists to using ___ .
databases
Screensize is measured by the ___ across the monitor.
diagonal
Hardware or software used to keep a computer secure from outside threats such as hackers and viruses by allowing or blocking Internet traffic is called a
firewall
Once the virus is identified the antivirus software attempts to remove the virus from the file. If the software cannot remove the infected file it will send the file to an isolated area on the hard disk called _____.
quarantine
To search a database for information, create a ___ .
query
Which colors make up a typical monitor's pixels?
red green blue
To display or distribute information from a database, programmers or database administrators create ___ .
reports
The number of pixels in a display is called the display's ___ .
resolution
Your ___ can provide hardware firewall protection for your home network where it connects to the ISP's network, just as ISP networks have firewalls where they connect to the Internet.
router
3D mapping, feature charting, and skin texture are some of the methods facial recognition software uses to identify individuals. T/F
true
Some cell phone carriers promising "unlimited data" will actually limit your high-speed, 4G LTE data to a couple of gigabytes per month. T/F
true
You must individually adjust cookie settings in every browser you use. T/F
true
Match the extension with the type of document.
webpage - .html spreadsheet - .accdb database - .xlsx presentation - .pez
Non-malicious computer security experts that test the security measures of an organization's information systems to ensure they are protected against malicious intrusions are called ___.
white hat hackers
After the code has been written there are nearly always mistakes. The 4th step in the PDLC involves finding and correcting these errors in a process called ___ .
debugging
If you have 2 folders open on your desktop and you want to move a file from one folder to the other, simply ___ the file.
drag
After the problem has been clearly defined, the next step in the PDLC is to create the plan or algorithm. This plan is usually written as a flowchart, and is in written in an ordinary language, such as ___ .
english
The machine cycle consists of which four steps?
fetch, decode, execute, and store
Which transmission media has the largest bandwidth?
fiber optic
In a database a _____ is a group of related characters in a database table that represents a characteristic of someone or something.
field
A URL identifies a particular __ address on the World Wide Web.
file
You created a flyer and saved it in your Documents folder. To find this file you could open Cortana (in Windows 10) and type the flyer's name in the search window, or you could click on the ___ icon (all Windows versions, on your toolbar) and access the Documents folder from there.
file explorer
