What does the acronym IPOS stand for?
Input, process, output, storage. (IPOS) represent the different tasks of computers.
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.
Correct. This is a description of how a computer uses the IPOS cycle.
Which of the following include only elements of a computer system? Select all that apply
CPU, users, keyboard, and memory
Monitor, print drivers, operating system, and mouse
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 accurate statement about the software in a computer system? Select all that apply.
A computer system needs software to be able to communicate with users as well as other computers.
Software must be part of the computer system in order for the system to be useful.
The software in a computer system may be shared if the system is a part of a network.
Correct. All three of these are accurate statements about the software in a computer system.
Which of the following would NOT be considered hardware?
Correct. A word processor is a software program to enter data and is not part of a computer's hardware.
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.
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.
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.
Which statements about the history of computer development are correct? Select all that apply.
The development of new hardware and software requires special training.
The following are examples of Graphical User Interface systems: GPS systems, ATM machines, and tablets and smart phones.
The capabilities and complexities of computers have grown substantially, but the ease of use has also made them user friendly.
Correct. These three options accurately describe the history of computer development.
How have computer users changed over the last 75 years?
Almost anyone can be a computer user today whereas in the past only computer scientists and those with specialized training used computers.
Which of the following would NOT require the use of a network?
Loading a statistical program on your personal computer.
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 statements describe why businesses use networks? Select all that apply.
Businesses use networks for data sharing.
Businesses use networks to reduce costs.
Businesses use networks for customer support.
Which of the following statements is true of computer networks
Computer networks allow individuals to share many types of resources.
Which of the following describes local computers only?
Is a computer that a person is physically at.
Correct. Where a person and computer are located together makes a computer local.
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.
Correct. Computer networks include the physical computers as well as other hardware devices such as printers and software and networks allow all devices to communicate.
What is the most common type of network connection in use today?
Fiber optic and UTP
Which of the following type of transmission is paired correctly with the given media?
fiber optic cable - light impulses
Why would it be desirable to use a switch as opposed to a hub in a network?
Because switches only transfer information to specific computers within a network and not all of the computers, the bandwidth used with a switch is less than that of a hub.
Which of the following devices is used to connect one network to another network?
router
Which of the following communication system hardware devices is commonly used as a wireless access point?
router
Correct. Routers can be used as a wireless access point.
Which of the following are characteristics of a packet-switched network?
B. The choice of pathway is based on network availability and amount of message traffic.
C. The route is established one branch at a time.
How do a router and switch differ when handling a message?
The router will purposefully drop messages if message traffic exceeds its capacity.
Correct. A router has additional decision-making capabilities compared to a switch.
In a client-server network, what is the role of the server?
The role of the server is to take requests from the client and send back the requested information.
How do virtual machines support a business computing ecosystem?
A virtual machine (VM) is made available by software and permits a computer to run multiple OSs. In a business ecosystem, this allows for improved collaboration that is not restricted by platform software.
Correct. A virtual machine allows a computer of one operating system to run other operating systems and applications specific to that alternative OS.
Which of the following servers responds to HTTP requests on the Internet?
web server
Which of the following servers monitors requests, but doesn't send files in return?
print server
Which of the following servers can generate reports from client queries?
database server
Which of the following is NOT a characteristic of a bus network topology?
Expensive compared to other topologies.
Which of the following types of networks has each device in the network connected in a single point-to-point connection with a central HUB?
star network
Which of the following best describes the benefits of a star network topology?
It is easy to add (or remove) devices on a star network and maintain the efficiency of message transferal.
Which of the following describes the knowledge stage in the DIKW model?
A management decision on how many people to hire after observing current employee levels and upcoming marketing promotions.
As a new sales manager, Sylvia is studying the sales report numbers to determine the top three salespersons of the year. At which stage of the DIKW hierarchy is Sylvia working?
Information
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 statements are true about an information system? Select all that apply.
An information system does not need to involve technology.
An information system is different than Information Technology.
Which of the following statements describes the difference between information systems and information technology?
An information system does not have to use computer hardware or software; whereas information technology requires the use of hardware and software.
Which of the following descriptions best represents the reliable characteristic of quality data?
Each year, the annual sales data was gathered for the same time period, using the same instruments and collection processes.
Which of the following statements best represents the relevant characteristic of quality data?
The data used applies to the question being answered.
Which of the following statements is true of cloud computing?
Cloud computing allows for the offloading of computation and storage from your local computer.
Which of the following statements is true of intranet?
A company's internal email system would be an example of a intranet.
Which software is run automatically rather than by the end user?
System
What is a program that will allow a computer to easily access the hardware and software of the computer system?
Operating system
An operating system will issue commands using the command line prompt by?
Typing in commands
Which of the following operating systems is for workstations?
Windows 7/8
Which of the following operating systems is for mobile devices?
Android
Which of the following operating systems is for servers?
Windows Server
Which layer of the operating system will handle process management, resource management, and memory management?
Kernel
Which layer of the operating system provides access to the kernel?
Shell
Which layer of the operating system run in the background and will handle an event?
Services
Which of the following is a role of an administrator account?
Manipulate system files
Which account is also referred to as root or superuser?
Administrator
Adding/deleting user accounts is the role of which account?
Administrator
Windows Server 8 is an operating system for type of device?
workstation
Which of the following statements applies to a proprietary software license?
Purchased from a vendor and gives you the right to use the software but is not yours to own.
Which of the following statements applies to an open source software license?
Made freely available as a source code to enhance and distribute the software.
Which two types of software licenses are free?
Freeware and Open source
What will protect the original work and the creation of inventive concepts?
Patent
What will prevent others from making, selling, or using an invention for 20 years?
Patent
When must a software license agreement be accepted when using proprietary software?
After downloading but before using the software
What will violate a proprietary software agreement?
What will violate a proprietary software agreement?
The proprietary software license agreement gives the purchaser the right to
use the software.
The End User License Agreements is a contract between the Licensor and the
the purchaser that gives the purchaser the right to use the software.
What rights does the End User License Agreement for proprietary software typically give to purchasers?
The right to use the software
The End User License Agreement for proprietary software
Limits modifying the software
Which of the following statements applies to a business intelligence system?
Used when making long-term decisions.
A business intelligence system is used by which of the following groups of people?
High-level management
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
Which OLAP operation involves viewing the data using a different filter first?
Pivoting
Correct. Pivoting is viewing the data from a different perspective.
What is the main difference between a data warehouse and OLDP?
OLDP deals with data in real time while a data warehouse does not.
Correct. This is the primary difference between the two database systems.
Which of the following are examples of real-time processing? Select all that apply.
Playing an online multiplayer video game.
Paying your bills online.
Which of the following interacts between a database and an application?
A driver
Which of the following is an interface between a database and the application?
ODBC application
Correct. OBDC is an application that interfaces with databases.
What does a JDBC driver allow a user to do?
Have an application interact with any database when developing in Java.
Correct. Developers using Java can use JDBC in conjunction with ODBC to have an application interact with any database.
Which of the following is a SQL command? Select all that apply.
INSERT
SELECT
DROP
SQL stands for
Structured Query Language.
Which of the following operators is used to select all of a certain data?
LIKE
Why is it essential to know what information will be needed from the database from the outset of development? Select all that apply.
The developer can determine which data types would help fulfill the purpose.
By knowing the purpose, the developer can determine how many fields are needed in the database.
Correct. All three of these are reasons why it is essential to know what information will be needed.
The purpose determines the structure of the database.
Indicate which of the following statements about databases and data types are accurate. Select all that apply.
Once the database is designed, the user doesn't need to worry about determining data types.
Uniform data types can be searched and sorted.
Numbers can be entered as text or as numeric values
Which of the following would be a field in a database?
19943-5568
63.2%
Which of the following statements about data organization are correct? Select all that apply.
A relationship may exist between each individual record.
You cannot perform mathematical functions on string data.
Not all records need to contain data about every attribute.
Which of the following are forms of queries?
projection
join
Which of the following are operations used to alter the data within a relation of a database?
update
delete
insert
In order for a relational database to work, at least one of the fields has to contain unique values.
Unique identifier
Which of the following are the three main categories of databases?
Flat File
Hierarchical
Relational
Which of the following database categories is the most similar to a spreadsheet or MS Excel document?
Flat File
Which of the following examples best describes hierarchical databases
A tree-like structure
Parent-child relationships
Which of the following skills are needed to assist with application design and development?
performance tuning
schema development
Database administrators might be involved with the integration of data from where?
Older systems to new
What is the focus of the list of responsibilities for database administrators?
design development and DBMS support
