Pre-Assessment: Intro to Information Technology

What are the three (3) main categories of databases?

* Flat file * Hierarchical * Relational

What port is the HDMI port on the laptop?

3

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

An Internet browser displays a web page.

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

Brute force

Which item is a storage device?

Flash Drive

in what phase of a project does time estimation occur?

Planning

Which is a type of two-factor authentication?

Smart Card

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

Machine Language

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

Mesh

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

Network Administrator

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

Proxy Server

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

Radio Signals

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

Resource Path ID

What allows an organization to use software through the Internet?

SaaS

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

Security Breach Notification Laws

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

Shareware

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

String

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?

String Data

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

* Arithmetic Logic Unit (ALU) * Control Unit

What are two (2) necessary elements of business continuity planning

* Assessing key organizational activities * Identifying risks that may occur

Which two (2) are parts of an information system?

* Databases * Networks

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

* External Microphone * USB Flash Drive

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

* Monitor * Printer

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

* Python * TCL

Which two (2) software application packages would be classified as productivity software?

* Word Processor * Spreadsheet Program

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.

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

A copyright

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 easy access to customer account information

Which statement correctly describes the operating system?

Allows the user to control the actions of the: * Software * Through the software * To access hardware

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

Applications are interdependent with the database.

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

Availability

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

Batch

Match each description with the type of computing eco-system it describes. Answer options may be used more than once or not all. Select your answer from the pull-down list

Define Next Question * Virtual Machines * Peer-to-Peer * Client-server

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

Desktop

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

Translates human-readable aliases into IP addresses

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

By developing policies for information usage

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

Client-server

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

FROM

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 component facilitates communication between the other two (2) components in the MVC architecture model?

Controller

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

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?

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

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

Data Mirroring

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

Establishes the customer's right to use the software

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

Expanding the infrastructure to support additional locations

Which motherboard component helps cool the CPU?

Heat Sink

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

Information System

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.

What is the definition of Information Technology (IT) ?

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

How does a compiler work?

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

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

Knowledge

Which is a characteristic of a high-level language?

Language translator programs are used to compile the code.

What is true about the Linux operating system?

Linux runs on both servers and workstations.

Match each action with the corresponding category. Answer options may be used more than once or not at all.

Part of the role of an IT professional association Outside of the role of an IT professional association

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

On which tier of an 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

What is the difference between processing and storage?

Processing involves temporary information, while storage involves permanent information.

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

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

Which characteristic identifies application software that is cloud-based?

Provided by third-party providers

What indicates a specific Internet location?

The IP address

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

They allow the application to interact with the database.

In which generation were silicon chips first used in computers?

Third Generation

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

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

To aid in making strategic decisions

What is a 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 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

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