WGU C182 FInal Exam Study Set, Intro to IT practice Test A and B , INTRO TO IT PRACTICE QUIZ

Which of the following statements best describes the difference between information systems and information technology?

An information system does not have to use computer hardware; whereas information technology requires the use of hardware and software.

Which action by application programs requires support from an operating system?

An internet browser displays a web page.

A website logs the timestamp, location, and browser of every visitor. It then aggregates this content into peak traffic times and days,minimum and maximum hits for each country and region, and popularity of certain browsers among visitors. What is the timestamp considered in this scenerio?

Data

What is the definition of information technology (IT)?

It is the technology used to create, maintain, and make information accessible.

What is the definition of information technology?

It is the technology used to create, maintain, and make information accessible.

In a SQL query, the __________ operation combines two tables together?

JOIN

SQL (Structured Query Language), a query for databases, was invented by?

IBM

With ________ an IT department resources (i.e. servers, data storage) are located outside of the organization and are accessible by anyone, anywhere.

IaaS (Infrastructure as a Service)

Which of the following best describes the differences between memory and the hard drive?

Memory stores instructions and data used by programs in the moment; whereas a hard drive stores data, programs, and files that can be accessed at a future time.

What is another term for a formula that outlines how to execute a task?

Algorithm

Which system requirement is an example of considering user needs in the design of an information system?

Allowing secure access to customer account information

A local area network (LAN)

Allows hardware sharing within one office

Writes laws dealing with information technology

Outside of the role of an IT professional association

This form of cloud computing is offered as a service by some major organizations, such as Amazon and Google, and used extensively by app developers. Its intent is to be able to quickly and reliably develop and deliver applications

PaaS(Platform as a Service)

which form of cloud computing enables teams of developers to quickly and reliably develop and deliver applications by accessing the same environment in real-time.

Paas or Platform as a Service

Engages in best practices for information systems

Part of the role of an IT professional association

Provides professional standards for ethical behavior

Part of the role of an IT professional association

Each computer is roughly equal to every other computer.

Peer-to-peer

What external component will allow peripherals to be connected to the system unit and connect additional input, output, storage, and communication devices?

Ports

Which characteristic identifies application software that is cloud-based?

Provided by third-party providers

What is part of the role of an It professional assocation?

Provides professional standards for ethical behavior.

Temporarily stores data before it is processed and sent to your screen or printer.

RAM

Volitile memory that disappears when the computer is turned off or loses power.

RAM

Which is found on the motherboard and stores information, but the information is not permanent?

RAM

________________ is a general term that describes any attack that takes advantage of humans' trusting nature.

Social engineering

Which two software application packages would be classified as productivity software?

Spreadsheet program and word processor

Which data type is used to represent product order code that comprises alphanumeric characters?

String data

The device that permits information to move between each component.

The bus

During which generation did computers begin to see widespread use in business?

Third generation

In which generation were silicon chips first used in computers?

Third generation

What is the database administrators role in security?

To institute protocols to protect the databases from external threats.

A service portfolio is simply a list of the services the department offers?

True

The selection operation takes rows from one table and creates a new table?

True

The abbreviation "URL" indicates:

Uniform Resource Locator

Which type of systems testing includes having developers test internal structures of software?

White box

Which component facilitates communication between the other two components in the MVC architecture model?

controller

What gives the author of a software package the ability to prevent unauthorized duplication for at least 35 years?

copyright

Which item is a storage device?

flash drive

Language that consists of English words, mathematical notation, and familiar syntax such as a semicolon used to end statements.

high level language

What does http stand for?

hypertext transfer protocol

Android, Chrom, and iOS are common operating systems for which type of computer?

mobile devices

The name, address, and telephone number of each individual patient in Dr. Alan's office is known as a:

record

the programs and other operating information used by the computer

software

proprietary software produced by a company that commercially markets software

software house

what type of computer still uses silicon chips?

tablet

While hardware is ______, software is ______

tangible and intangible

Which data format is not in an easily usable format and takes greater effort to extract?

unstructured

The people who use the computer system

users

What is a program that allows the user to monitor and improve system performance and extends the capabilities of an operating system?

utility software

Which of the following would NOT be considered hardware?

word processor

Why is it essential to know what information will be needed from the database from the outset of development? Select all that apply.

-By knowing the purpose, the developer can determine how many fields are needed in the database. -The purpose determines the structure of the database. -The developer can determine which data types would help fulfill the purpose.

Which of the following describes the knowledge stage in the DIKW model? Number of hours worked by an employee. A management decision on how many people to hire after observing current employee levels and upcoming marketing promotions. Average number of hours worked by department. Report on employee attendance.

A management decision on how many people to hire after observing current employee levels and upcoming marketing promotions.

Which action by application programs requires support from a networked operating system?

An Internet browser displays a web page.

What is the main difference between a compiled language and an interpreted language?

An interpreted language runs inside of a special environment called the interpreter.

A stand alone entity that would be programmed to handle its own internal methods as well as messages received from other objects.

An object

What are two necessary elements of business continuity planning?

Assessing key organizational activities. Identifying risks that may occur

Which goal of information Assurance (IA) requires that information is accessible when needed?

Availability

The basic operating system that runs when a computer is first turned on. It runs test of memory and the cpu,and initilizes hardware components so that the actual Operating system can be loaded from the hard disk.

BIOS ROM

What type of information processing allows input data to be accepted as a set of records and processed as a unit?

Batch processing

Less reliance on internal IT expertise.

Benefits of cloud computing

Which statement is NOT true of compilers and interpreters? All errors must be debugged before a compiler can compile the source code. Interpreters translate and execute one line of source code at a time. Perl and Python are examples of programming languages that use an interpreter. Compilers do not translate source code into machine code.

Compilers do not translate source code into machine code. A

Prohibits intentionally accessing a computer without authorization or in excess of authorization. The anti-hacking law.

Computer Fraud and Abuse Act

Select the statement that best describes the difference between software and hardware.

Computer software is developed by writing a program using programming language whereas computer hardware is the physical components such as memory modules and disk drives.

What step should be taken by a business when a third-party solution is found that will benefit a project?

Contact the group to arrange a demo of their product

What step should be taken by a business when a third-party solution is found that will benefit a project?

Contact the group to arrange a demo of their product.

Which two components are parts of a central processing unit?

Control Unit (CU)

Retrieves instructions and raw data (input) and manages the transmission of the instructions and data to the alu.

Control unit

Which two components are parts of a central processing unit (CPU)?

Control unit (CU) Arithmetic logic unit (ALU)

Which benefit is provided by a computer network in a business?

Cost for hardware resources are decreased.

What is an advantage of outsourcing?

Cost-effective if time is constrained

Which is a benefit of multiple interconnected computers (distributed) versus mainframes or large computers?

Costs for hardware resources are decreased

Which risk assessment question is part of the Initiation Phase?

Could the end users reject the outcome of the project?

Which risk assessment question is part of the initiation phase?

Could the end users reject the outcome of the project?

Marcus has a summer job working at a real estate agency. He is entering client addresses into the company's computer system. At which stage of the DIKW hierarchy is Marcus working?

Data

Which of the following best describes a hierarchical database format?

Data are modeled using parent-child relationships.

An operating system will write and change data to multiple hard drives at the same time so that if something happens to one hard drive, another hard drive is available to speed up data recovery. This statement best describes which of the following?

Data mirroring

Which disaster recovery strategy is used to save information to multiple hard drives at the same time?

Data mirroring

Which disaster recovery strategy is used to save information to multiple hard drives at the same time?

Data mirrorring

What is the purpose of the End User License Agreement for a commercial software package?

Establishes the customer's right tot use the software.

Which action would be important for the IT department to take in order to help their business meet the goal of increased expansion?

Expanding the infrasturcture to support additional locations.

Which of the following best describes the purpose of expansion slots in modern computers?

Expansion slots allow additional cards to be connected to the motherboard that interface with peripheral devices.

Which two computer peripherals are connected to the computer through a port?

External microphone and USB flash drive

The ______ keyword in SQL is used to inform the DBMS what tables are to be interrogated by the query and, if more than one table contains the data of interest, how they are to be combined or joined.

FROM

Which SQL clause is used to inform the database management system (DBMS) which tables should be interrogated by the query?

FROM

Which sql clause is used to inform the database management system which table should be interrograted by the query?

FROM

Hot storage is a low cost and slow means of storing critical data, while cold storage is high cost and fast.

False

The four computers based on size and processing speed are supercomputers, workstation, mainframe, and microcomputer.

False

_____________ are system development methodologies that propose incremental implementations, respond to rapidly changing requirements, and reduce the emphasis on rigorous requirements. Waterfall Prototyping Extreme programming Agile methods

Agile methods

Which of the following statements represents the relevant characteristic of quality data? Select all that apply. The data used applies to the question being answered. The data has been gathered using consistent, detailed collection processes. The data has been inputted correctly and is accurate for its intended use. The data is current enough to still serve its purpose for being accessed.

All of the above

Which of the following are the three main categories of databases?

Hierarchical , Flat File, Relational

What is a tree-like structure of records in a database referred to as?

Hierarchical database structure

A monitor is a peripheral device for what system?

I/O (input/output)

A scanner is a peripheral device for what system?

I/O (input/output)

What indicates a specific Internet location?

IP address

Which department supports day-to-day technology needs of an organization?

IT

Within this CLOUD computing function all the resources hardware and software(e.g., servers, data storage) an IT department needs are located outside of the organization and are accessible by anyone, anywhere

IaaS (Infrastructure as a Service)

Which cloud service provides all the resources (servers, data storage) tha an IT dept needs ouside of the org making them accessible by anyone, anywhere

IaaS or Infrastructure as a Service

What are two necessary elements of business continutiy planning?

Identifying risks that may occur

A form of backup that creates a copy of everything that is on a hard drive including the OS, programs, and configuration files. This statement best describes which of the following?

Image backups

Which system requirement is an example of considering user needs in the design of an information system?

Allowing easy access to customer account information.

Which statement correctly describes the operating system?

Allows the user to control the actions of the software, and through the software, to access hardware

Which term is defined as a collection of information used to support management of an organization?

Information system

What is the correct order of project phase for Project Management?

Initiation, Planning, Executing, Closing

What does the acronym IPOS stand for?

Input, process, output, storage. (IPOS) represent the different tasks of computers.

What is another term that defines a script?

Interpreted program

What is one of IT's role in golobalization?

It allows companies to reach a wider customer base.

What is one of IT's roles in globalization?

It allows companies to reach a wider customer base.

What is the purpose of an IT department?

It helps the organization achieve strategic goals.

What effect does scope creep have on a project?

It increases unplanned costs for the project.

Read the following scenario and determine the best hardware or software solution for the situation. Teachers in the Lincoln County School District are complaining about the speed of the Internet in their classrooms. Marcus, the IT Coordinator, has a limited amount of money to spend to address the issue. Select the option below that uses hardware or software to help solve the problem.

Marcus determines the school's routers that transmit information from the Internet across the district are slow and outdated, so he will use the money to replace them.

In which type of network topology is each networked device directly connectd to every other networked device?

Mesh

In which type of network topology is each networked device directly connected to every other networked device?

Mesh

Which of the following technologies was introduced in the fourth generation of computers?

Microprocessors

What is the phenomenon observed that the number of transistors on a chip doubles every year and will continue for at least the next ten years?

Moore's law

Which IT position has the responsibillity of working with routers and switches?

Network Administrator

Which of the following statements describes why network protocols are necessary.

Network protocols are necessary for computers to communicate with each other.

Which of the following is/are true of the IPOS cycle?

Once words, numbers or images are entered, a computer processes the data into useable information that can then be accessed to answer questions or meet specific needs.

What is the difference between proprietary and open-source software license?

Open-source software can be freely modified whereas proprietary software cannot be modified.

__________ uses the concept of reflection of light through a core made up of glass or plastic.

Optical wire

What are the risks of cloud computing?

Org becomes dependent on the reliability and performance of a third party vendor.

Which type of systems conversion involves starting the conversion with a portion of end users?

Pilot

In what phase of a project does time estimation occur?

Planning

What is the difference between processing and storage?

Processing collects and translates data into useful information, while storage places the translated data in specific locations.

What is the difference between processing and storage?

Processing involves temporary information, while storage involves permenant information.

What is the difference between proprietary and open-source software license?

Proprietary software has a cost whereas open-source software is free.

___________ is ephemeral, meaning data stored is lost when the computer is powered off.

RAM

What does RFID stand for?

Radio frequency identification device

Which communication medium is typically used when sending data transmissions over very long distances?

Radio signals

Which transmission medium should be used when sending data transmissions from Singapore to Mexico City?

Radio signals

a dept manager is creating a budget estimate for the upcoming year. The manager would like to determine whether the data will be available when the decision for the next year have to be made. Which characteristic of valuable data is the manager considering?

Reliable

What is one probable advantage of outsourcing?

Reliance can be placed on the expertise of outsourcing vendors.

Which part of a Uniform Resource Locator (URL) identifies the location of the document on the server?

Resource path ID

Which part of a Uniform Resource Locator identifies the location of the document on the server?

Resource path id

Which of these is NOT a category of risk in a project Risks in execution Risks in integration Risks in deployment Risks of the unknown

Risks in deployment

Which device permits packet switching so that a message can be routed to the next link in a network?

Router A router is a device that permits packet switching in order to send messages to the next link in the network.

Which two are both types of scripting languages?

Ruby and Python

The _______ keyword in SQL is used to inform the DBMS what fields or attributes are of interest (and where they are located, i.e. which table/relation they can be found in).

SELECT

Thru this CLOUD computing function, businesses can access and use software through the Internet?

SaaS (Software as a Service)

What is a cloud model that delivers third-party software such as email or games through the internet?

SaaS (Software as a Service)

What allows an organization to use software through the internet?

Saas or Software as a Service

what cloud service provides access and use of software to businesses through the internet?

Saas or software as a service

Which regulation governs the actions of a company in case of data records being compromised, lost, or stolen?

Security Breach Notification laws

Which regulation governs the actions of a company in the case of data records being compromised, lost, or stolen?

Security Breach Notification laws

What type of software permits free temporary use followed by long term activation for a fee?

Shareware

What type of software permits free temporary use followed by long-term activation for a fee?

Shareware

What external component will allow peripherals to be connected to the system unit and insert modem cards, wireless access cards, and other PC cards?

Slots. Incorrect answers: Hard drives. Bays. Ports.

Which of the following types of information present a threat to someone's privacy?

Student ID and credit card numbers

Which statement describes the role of a systems administrator?

Systems administrators are responsible for supporting, monitoring, and maintaining workplace technology and end users.

Which language is often used for rapid prototyping and the creation of GUIs?

TCL

Which two languages have traditionally been used for automation rather than software development?

TCL and Python because they are scripting languages

Which of the following statements best defines the ALU?

The ALU processes the raw computer data, including mathematical calculations and logical operations.

Which of the following statements best defines the CPU?

The CPU controls the speed at which instructions are retrieved and processed in the computer.

Which of the following best describes the Internet?

The Internet is a global network of networks.

Also known as the chassis or cabinet.

The case of a computer

What indicates a specific internet location?

The ip address

Allows the user to control the actions of the software and through the software, to access hardware.

The operating system

controls the speed at which instructions are processed.

The system clock

What is the role of drivers in facilitating communication between application and databases?

They allow the ODBC to be used for interactions with the database and applications.

What is the role of drivers in facilitating communication between applications and databases?

They allow the application to interact with the database.

Which of the description of duties below would be for a System Administrator? This individual has responsibility for developing new software applications to improve the functionality of an organization's information technology. This individual is in charge of ensuring that the network is working properly. Duties may include connecting devices using cable, configuring individual employee computers, working with the network hardware, and troubleshooting. This individual has responsibility for all aspects of an organization's databases and database management systems. This individual updates an organization's computer hardware and software, performs troubleshooting, and maintains the operating system of a computer system.

This individual updates an organization's computer hardware and software, performs troubleshooting, and maintains the operating system of a computer system

Why is it important to ensure that data support business goals?

To aid in making strategic decisions

Why is it important to ensure that data support business goals?

To aid in making strategic decisions.

What is the purpose of a business continuity plan?

To enable an organization to continue offering critical services in the event of disruptions

What is a role of the systems administrator?

To install and maintain network resources

What is the role of the systems administrator?

To install and maintain network resources.

What is the database administrator's role in security?

To institute protocols to protect the databases from external threats

Which is not a common operating system used today? Windows Top Hat Mac Linux

Top Hat

Which description explains the role of a domain name system (DNS)?

Translates human-readable aliases into IP addresses

A service portfolio is simply a list of the services the IT department offers.

True

IT functions cover these five different domains: communication data collection and management information security management consumer relationship management process improvement

True

In the SDLC implementation phase, the design goes to the programmers who translate it into code to execute the plan.

True

In the design phase of the SDLC, architects think about the components they would need to solve the problem or implement the plan.

True

RAM is ephemeral, meaning data stored in RAM is lost when the computer is powered off?

True

Traditional flat file systems are one-dimensional and present information from a single point of view and do not interact with other files.

True

The _______ includes the protocol, domain, and all subdomains, as well as the resource path ID and name of the document.

URL

Which of the following are operations used to alter the data within a relation of a database?

Update, Delete, Insert

Which action would support confidentiality?

Updating security software.

Which type of systems testing includes having the customer test the system in an operational setting to see if it is useful?

User Acceptance

During _______ users test the system in an operational setting to make sure the system continues to align with business objectives and meet the goals of the stakeholders.

User Acceptance Testing

The _____ keyword in SQL is used to inform the DBMS of the specific criteria the data should match to be returned as the output of the query.

WHERE clause

What is outside of the rold of an IT professional assocation?

Writes laws dealing with information technology

A website logs the timestamp, location, and browser of every visitor. It then aggregates this content into peak traffic times and days, minimum and maximum hits for each country and region, and popularity of certain browsers among visitors. What is the timestamp considered in this scenario?

data

Marcus has a summer job working at a real estate agency. He is calculating the zip code with the most houses for sale. At which stage of the DIKW hierarchy is Marcus working?

data

in the dikw, what is data?

data is the input directly received by human or computer.

What is the collection of names, addresses, and account balances of all the patients of Mei's office more technically known as?

database

permits database access across a network. Performs tasks such as data analysis, data manipulation, security, and archiving.

database server

A ____________ is also known as a datasheet.

database table

Which category of computer has an external flat screen monitor, optical disk drive, and a large capacity hard drive?

desktop

computer with the most amount of performance capability

desktop

________, sometimes referred to as middleware, facilitate the communication of hardware and software.

device driver

a piece of the operating system that provides specific interfaces between the OS running a computer and hardware.

device drivers

consists of long term storage devices

disk drives

Translates human readable aliases into IP addresses

domain name system (DNS)

software more specific towards artists and graphic designers

drawing software

This server addresses protocols such as: IMAP, POP3, SMTP, HTTP, MAPI, and MIME?

email server

________ is defined as a code of moral conduct or a set of principles that govern behavior?

ethics

Which of the following type of transmission is paired correctly with the given media?

fiber optic cable - light impulses

a computer with a large hard disk storing files that any or many users of the network may wish to access.

file server

What generation used vacuum tubes in computers?

first generation

software free from purchase, but not necessarily free in how you use it.

freeware

what types of software is ususally software that has become obsolete because a new software has replaced it, or is software that the original producer no longer wants to maintain and provide support for?

freeware

How long has Moore's law continued to be a trend?

from 1965 to the present

like a web server, this server host files and allows clients to access those files. However, it instead provides access in the form of uploading and downloading files.

ftp server

computer that has the least amount of performance

handheld

The physical components of a computer

hardware

in dikw, what is wisdom?

having both knowledge and experience

Which motherboard component helps cool the CPU?

heat sink

Which motherboard component helps cool the cpu?

heat sink

This database structure format organizes data using a tree-like or organizational chart type structure (i.e. parent-child structure).

hierarchal

Which factors should Mike NOT consider when choosing a file organization system? Hierarchy Scalability Security Data retrieval speed

hierarchy

Includes all peripheral devices for input, output, storage and network.

i/o subsystem

a location beacon that uses bluetooth technology and can be embedded in any location aware mobile device.

iBeacons

data that has been processed

information

in dikw, what is information?

information is inferred from data, meaning that one or many processes have been applied to the data to tranform it into a more useful form.

Which term is defined as a collection of information used to support management of an organization?

information system

The business case, feasibility study, and stakeholder input are 3 key elements of which project phase?

initiation

What four operations does a computer perform?

input

what does ipos stand for?

input, process, output, storage

Relies on a session and allows you to test out an idea because they are executed as they're written.

interpreter

loaded when the computer is first booted, included components that handle process mgmt, resource mgmt, and memory mgmt

kernel

As a new sales manager, Edgar is studying the historical and current sales report numbers to determine the top three salespersons of the year. At which stage of the DIKW hierarchy is Edgar working?

knowledge

In which category of the Data, Information, Knowledge, Wisdom (DIKW) hierarchy would business intelligence be located?

knowledge

which is a characterisc of high level languages?

language translator programs are required.

computer that has the mid amount of performance capability

laptop

software stored on an individual computer

local application

What is NOT part of data hygiene? Data is valid Lots of data Free from malicious or inadvertent tampering Data is good

lots of data

A program written in a high-level language must be converted into __________ code to be executed by the computer.

machine

Which low-level language corresponds one to one with assembly?

machine language

Which low-level language corresponds one-to-one with assembly?

machine language

a programming language that is a lengthy list of 1s and 0s.

machine language

A single chip process developed in 1974 by IBM

microprocessor

a collection of computers and resources connected by various media so they can communicate with each other.

network

Which IT position has the responsibility of working with routers and switches?

network administrator

Is moore's law an observation or a physical law?

observation

software created in the open source community and made freely available as source code

open source

This type of software is made freely available as source code.

open source software

What is a program that will allow a computer to easily access the hardware and software of the computer system?

operating system

Each computer is roughly equal to every other computer.

peer-to-peer

Which type of systems conversion involves starting the conversion with a portion of end users?

pilot

The fetch-execute cycle is performed in an overlapped fashion on several instructions.

pipelines cpu

In what phase of a project does time estimation occur?

planning

Project managers work with project scope, the management plan, and SMART frameworks in this project phase?

planning

Which project phase consists of determining the objectives and activities, organizing the activities, and estimating the time and costs?

planning

During this phase of Project Management, the projects scope and project management plan are defined

planning phase

Can connect additional input, output, storage, and communication devices

ports

On which tier of the n tier architecture model are user interfaces developed?

presentation

Which field must contain a unique value in order for a relational database table to function?

primary key

An employee needs to edit a contract and prepare a hard copy for a project team. Which two peripheral devices should be used?

printer

An employee needs to edit a contract and prepare a hard copy for the project team. Which two peripheral devices should be used?

printer, monitor

also referred to as horizontal software

productivity software

consists of applications that are usefule to everyone such as word processor, presentation software, spreadsheet program, database mgmt systems, calendar program, address book, and data organizer.

productivity software

commercial software purchased from a vendor

proprietary

Which characteristic identifies application sotware that is cloud based?

provided by third party providers

The chief information officer wants to update the network server to improve Internet access while also blocking certain social media websites. What type of server will meet this need?

proxy server

Used in an organization to act as a giant cache of web pages that anyone in the organization has recently retrieved.

proxy server

what type of server has the capability of blocking specific servers and rejecting responses that contain certain content?

proxy server

Which classification for documents is used when the unauthorized disclosure, alteration, or destruction of data would result in little or no risk?

public

software that has been moved into the public domain and are made available as executables.

public domain

in dikw, what is knowledge?

refined information that hte user of the knowledge is able to call forth only relevant portions of information when needed.

This type of database is the most common format for storing data as it provides users with a great deal of flexibility, allowing for multiple tables.

relational

Which is a database structure containing multiple tables (relations) with interrelated fields and has a unique identifier?

relational database

which characteristic of quality data requires data being used to be applied directly to the decision being made.

relevance

characteristic of quality data whereas data should reflect stable and consistent data collection processes across collection points and over time, whether using manual or computer based systems or a combination.

reliable

Which device receives a message, examines its destination IP address, and sends the message on to the next location in the network (could also be called a gateway)?

router

perl, php, ruby, python, and asp are interpreted languages that are also what other type of language?

scripting languages

What generation of computers began to use transistors?

second

Which one of these is NOT a operation for database queries? Union Serve Product Join

serve

dedicated computers within a network whose function is to respond to network requests and provide a network service

server

works with hardware to provide a network service, types of software includes web servers, email servers, and database servers

server software

What do integrated circuits need to function?

silicon chip

can insert modem cards, wireless access cards, and other PC cards such as camera cards

slots

Which is a type of two-factor authentication?

smart card

What does the GOTO statement create?

spaghetti code

In this network topology ALL devices have a single point-to-point connection with a central device.

star network

Which data type is used to represent product order code that comprises alphanumeric characters?

string

What replaced the GOTO statement with high level control constructs such as while loops, and if-else statements, and is not allowed to use the GOTO statement?

structured programming

Which software is run automatically rather than by the end user and provides the infrastructure needed to run application software, allowing it to interface with the hardware of the computer system?

system

Which software is run automatically rather than by the end user?

system software

progams that make up the operating system and directly supports the computer system itself.

system software

programs that allow the user to monitor and improve system performance

system utilities

A collection of protocols that is sometimes referred to as a protocol stack

tcp/ip

The circuitry and electrical channels that enable communication among the electronic components.

the bus

The myriad of types of devices that can and will be connected to the internet in the next few years.

the internet of things (IoT)

When a programmer enters a command, what converts that command to machine language and executes it?

the interpreter

sits on top of the hardware and is the interface between hardware and software

the kernel

the printed circuit board that houses the cpu, memory chips, and expansion cards in any computer.

the motherboard

What generation of computers introduced operating systems?

third

what generation of computers introduced the silicon chip?

third

In which generation were silicon chips first used in computers?

third generation

characteristic of quality data whereas data must be complete and not contain errors or lapses of data.

thorough

There are how many tiers of ISPs?

three

A departmental manager is creating a budget estimate for the upcoming year. The manager would like to determine whether the data will be available when the decisions for the next year have to be made. Which characteristic of valuable data is the manager considering?

timely

characateristic of quality data where data is provided efficiently and on time so that companies can utilize it in their business.

timely

hat is the role of a web server

to respond to HTTP requests

a requirment of all computers to communicate over the internet

transmission control protocol/ internet protocol or TCP/IP

the ability to have computation anywhere at any time

ubiquitous computing

Software used by select groups with an organization or to a specific discipline such as music sequencers, samplers, and digital recorders for muscians.

vertical software

A software emulator program that permits a computer user to use multiple computers and multiple platforms without the expense of purchasing multiple computers.

virtual machines

A software emulator program that permits a computer user to use multiple computers and multiple platforms without the expense of purchasing mutiple computers.

virtual machines

The role of a ______ ______ is to respond to requests most typically come from web browsers, such as HTTP

web server

The scope of the project is considered what?

work that needs to be done

Learning about social engineering and how to protect passwords is ___.

Education

Pieces of the operating system that run in the background all of the time

daemons or services

What does BIOS stand for

Basic input output system

Which is a characteristic of high-level languages?

The source code has to be complied.

an interface for the user that provides access to the kernel

the shell

A petabytes consists of how many terabytes?

1000

A typical database application has how many layers?

2

Which is true of databases and the application that interact with them?

Applications are interdependent with the database.

What is the definition of a Platform as a Service (PaaS)?

A Platform as a Service is the ability to quickly and consistently develop and deliver applications.

What statement is true concerning compiled and interpreted computer language?

A compiler translates an entire program into executable program, which can be run at a later time, while the interpreter does this incrementally.

Which of the following is the best definition of a computer network?

A computer network is a collection of computers and computer resources (e.g., printers, file servers) connected in such a way that the computers can communicate with each other and their resources.

Which of the following is an accurate definition of a computer system?

A computer system is a collection of hardware and software components that work together to meet the needs of the user.

Which of the following is an example of a relational database?

A database containing student records with fields such as Student ID, First Name, Last Name, Major, GPA that links to other databases in the University's system.

What is a primary difference between a modern handheld computer and a modern desktop computer?

A desktop has more processing power.

Which statement is correct given that usability is very subjective, and handheld and desktop computers may be more or less usable based on the demands of the user?

A desktop has more processing power.

Which of the following would NOT be the responsibility of the system administrator?

Answering e-mails from potential customers.

51. Which is true of databases and the applications that interact with them?

Applications are interdependent of the database

A company's ability to recover after a disaster is directly related to which of the following?

Business continuity plan

What is the definition of business intelligence?

Business intelligence is a term used to reflect the knowledge a business can create by analyzing data gathered from multiple sources.

How can an organization assist employees with the ethical use of information technology?

By developing policies for information usage

How can an organization assist employees with the ethical use of information technology?

By developing policies for information usage.

Over the years, the number of transisters that can be placed on a chip has increased by how much?

By orders of maginitude rather than linearly

In 2nd generation computers, which of the following high-level programming languages was created to be business-oriented?

COBOL

What are the main components in a computer?

CPU

Which of the four main components of a computer is described by this statement: This component executes all of the arithmetic and logic operations and is responsible for controlling (commanding) all of the components in the computer.

CPU

also referred to as "the chip"

CPU

The __________________ is the electronic circuit responsible for executing computer program instructions.

Central Processing Unit

One computer will request information from another computer, which responds with requested information.

Client-server

What is the purpose of an End User License Agreement for a commercial software package?

Establishes the customer's right to use the software

Read the following scenario, and then select the job title that most accurately depicts the descriptions. Javier starts the day by checking his e-mails. Sandra in payroll would like him to print a report detailing how much money has been spent on training new employees. She would like a comparison of the training dollars spent over the last five years. Javier spends the morning retrieving the appropriate information from the database and e-mails a report to Sandra. In the afternoon, Javier begins a performance analysis of the new database management system that he installed last week. He also double-checks that the old data has properly transferred to the new system. He then develops a list of procedures for those who work under him so they can also run performance analyses. Finally, he heads upstairs to the Chief Operating Officer's office to make a brief presentation on the new database system and how it can be used most effectively.

Database Administrator

Which two are parts of an information system?

Databases and Networks.

In the _______ phase of the SDLC (system development life cycle), architects think about the components that they would need to solve the problem or implement the plan.

Design

Which category of computer has an external flat screen monitor, optical disk drive, and a large capacity hard drive?

Desktop

Which answer most accurately describes the timeline of computer development? First, computers built and programmed by engineers. Next, limited use of computers by large organizations. Next, introduction of personal computers. Lastly, Graphical User Interface systems are introduced. First, Graphical User Interface systems are introduced. Next, limited use of computers by large organizations. Next, computers built and programmed by engineers. Lastly, introduction of the personal computer. First, limited use of computers by large organizations. Next, computers built and programmed by engineers. Next, introduction of personal computers. Lastly, Graphical User Interface systems are introduced. First, computers built and programmed by engineers. Next, Graphical User Interface systems are introduced. Next, limited use of computers by large organizations. Lastly, introduction of personal computers.

First, computers built and programmed by engineers. Next, limited use of computers by large organizations. Next, introduction of personal computers. Lastly, Graphical User Interface systems are introduced.

Which of the following database categories is the most similar to a spreadsheet or MS Excel document?

Flat File Database

What are the three main categories of databases?

Flat file, relational, and hierarchal

What are the three main categories of databases?

Flat file, relational, hierarchal

What two types of software licenses are free?

Freeware and Open source

What is the measurement unit used to identify clock speed on today's computers?

GHz

Which statement allowed the programmer to transfer control from any location in a progam to anywhere else in the program?

GOTO

What does GUI stand for?

GUI stands for Graphical User Interface.

how does a compiler work?

It requires the components of the software to be defined from the onset.

How does an interpreter work?

It takes the most recently entered instructions, converts it into machine language, and executes it.

All of the following are compiled languages except for: Javascript BASIC Java C++

JavaScript

In which category of the DIKW hierarchy would business intelligence be located?

Knowledge

All of the following are parts of a URL except for: LAN Protocol Host name TLD

LAN

In a __________ shell forward slash (/) is used to express directory paths?

Linux

What is true about the Linux operating system?

Linux runs on both servers and workstations

Which of the following would NOT require the use of a network?

Loading a statistical program on your personal computer.

What is the difference between a compiled and interpreted computer language?

compiler translates an entire program into executable progam which can be run at a later time, while the interpreter does this incrementally.

excluse right to make copies, prepare derivative works, and distribute copies of the work for the duration of the author's life plus 70 years.

copyright

A set of rules established to govern how people behave and interact with each other

a protocol

What was the operation system called in the early 1960s?

a resident monitor

Which is NOT part of the history of the computer? Abacus Leibniz Punch cards Abracadabra

abracadabra

characteristic of quality data whereas data is captured once only, where possible, and captured as close to the point of activity as possible.

accurate

sometimes referred to as root or superuser

administrator account

What is another term for a formula that outlines how to execute a task?

algorithm

During this phase of the SDLC (system development life cycle) the team determines the user requirements for the new system and develops logical models of the system?

analysis

Which type of software includes programs such as Microsoft Word and PowerPoint?

application

consists of programs that end users run to accomplish tasks. An example of a type of this software includes the email client, web browser, and ftop client

application software

Completes mathematical calculations and logical operations to process the data, converting the input of keyboard text entry to output displayed on the screen.

arithmetic logic unit

An early language translator that would translate an assembly program into machine language.

assemblers

Which goal of Information Assurance (IA) requires that information is accessible when needed?

availability

Houses CDs and DVDs, typically located on the front of the system unit for easy access.

bays

In this phase of testing the system is given to a segment of end users for testing from their perspective before the final version is released.

beta

Refers to data sets that are so large and complex that they will require more advanced database management/processing tools than we currently use.

big data

______ refers to data sets that are so large and complex that they will require more advanced database management/processing tools than we currently use?

big data

Which technique uses all possible combination of letters and numbers to crack a password?

brute force

Which technique uses all possible combinations of letters and numbers to crack a password?

brute force

As a part of effective IT governance, the IT plan should be consistent with the organization's what?

business plan

Armando is a freelance graphic designer. He has decided to create a database of the artwork he has done throughout the years. Each of his pieces of art is sorted using an assigned name and number. Which data type will be required in order to create his database?

character string

One computer will request information from another computer, which responds with requested information.

client-server

The team will write a final report detailing the processes and outcomes of the project in which project phase?

closing

A ________ translates source code into machine language and translates the entire program, creating an executable program which can be run at a later time.

compiler

Requires that the componenets of the software all be defined from the onset and is considered to have more efficient code.

compiler

protects an original work, but no the ideas behind the work

copyright