C393 - IT Foundations Lesson 1

Which of the following statements is true of intranet?

A company's internal email system would be an example of a intranet.

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.

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 interacts between a database and an application?

A driver

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.

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 examples best describes hierarchical databases

A tree-like structure Parent-child relationships

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 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 would be a field in a database?

19943-5568 63.2%

Adding/deleting user accounts is the role of which account?

Administrator

Which account is also referred to as root or superuser?

Administrator

When must a software license agreement be accepted when using proprietary software?

After downloading but before using the software

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 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.

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.

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 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.

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 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 is an interface between a database and the application?

ODBC application Correct. OBDC is an application that interfaces with databases.

Which of the following statements best represents the relevant characteristic of quality data?

The data used applies to the question being answered.

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.

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.

What rights does the End User License Agreement for proprietary software typically give to purchasers?

The right to use the software

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 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.

Which of the following statements applies to a business intelligence system?

Used when making long-term decisions.

What will violate a proprietary software agreement?

What will violate a proprietary software agreement?

Which of the following operating systems is for workstations?

Windows 7/8

Which of the following operating systems is for servers?

Windows Server

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

fiber optic cable - light impulses

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 of the following database categories is the most similar to a spreadsheet or MS Excel document?

Flat File

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

Flat File Hierarchical Relational

Which two types of software licenses are free?

Freeware and Open source

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.

A business intelligence system is used by which of the following groups of people?

High-level management

Which of the following is a SQL command? Select all that apply.

INSERT SELECT DROP

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

What does the acronym IPOS stand for?

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

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 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 layer of the operating system will handle process management, resource management, and memory management?

Kernel

Which of the following operators is used to select all of a certain data?

LIKE

The End User License Agreement for proprietary software

Limits modifying the software

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 applies to an open source software license?

Made freely available as a source code to enhance and distribute the software.

Which of the following is a role of an administrator account?

Manipulate system files

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.

What will prevent others from making, selling, or using an invention for 20 years?

Patent

What will protect the original work and the creation of inventive concepts?

Patent

Which OLAP operation involves viewing the data using a different filter first?

Pivoting Correct. Pivoting is viewing the data from a different perspective.

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 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 layer of the operating system run in the background and will handle an event?

Services

Which layer of the operating system provides access to the kernel?

Shell

SQL stands for

Structured Query Language.

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

System

An operating system will issue commands using the command line prompt by?

Typing in commands

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 servers can generate reports from client queries?

database server

What is the focus of the list of responsibilities for database administrators?

design development and DBMS support

Which of the following skills are needed to assist with application design and development?

performance tuning schema development

Which of the following servers monitors requests, but doesn't send files in return?

print server

Which of the following are forms of queries?

projection join

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 types of networks has each device in the network connected in a single point-to-point connection with a central HUB?

star network

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.

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

update delete insert

The proprietary software license agreement gives the purchaser the right to

use the software.

Which of the following servers responds to HTTP requests on the Internet?

web server

Windows Server 8 is an operating system for type of device?

workstation

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 operating systems is for mobile devices?

Android

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.

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 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 computer networks

Computer networks allow individuals to share many types of resources.

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 of the following is NOT a characteristic of a bus network topology?

Expensive compared to other topologies.

What is the most common type of network connection in use today?

Fiber optic and UTP

Which of the following statements describes why network protocols are necessary

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

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.

Database administrators might be involved with the integration of data from where?

Older systems to new

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 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.

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

Operating system