Intro to IT Practice Test Flashcards

1
Q

A local area network (LAN)

A

Allows hardware sharing within one office.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

All of the following are compiled languages except for:

Javascript
BASIC
Java
C++

A

Javascript

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Planning

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Student ID and credit card numbers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

eMail server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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.

A

Beta

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

IaaS (Infrastructure as a Service)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A scanner is a peripheral device for what system?

A

I/O

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Machine

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

The Uniform Resource Locator (URL)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

COBOL (Common Business Oriented Language)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

Closing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

Router

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which of the following best describes the Internet?

A

The Internet is a global network of networks.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

The role of a (blank) is to respond to requests most typically come from web browsers, such as HTTP.

A

Web server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

Initiation, Planning, Execution and Closing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

All of the following are parts of a URL except for:

A

LAN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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.

A

CPU

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

Hierarchal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Which of the following statements best defines the CPU?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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.

A

The data used applies to the question being answered.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

During (blank) 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.

A

User Acceptance Testing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

(Blank) sometimes referred to as middleware, facilitate the communication of hardware and software.

A

Device driver

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

The (blank) 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.

A

WHERE clause

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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.

A

PaaS (Platform as a Service)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

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?

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What is an advantage of outsourcing?

A

Cost-effective if time is constrained.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

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

A

Linux

30
Q

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

A

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

31
Q

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

A

Answering e-mails from potential customers

32
Q

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

A

Hierarchical, Flat File, Relational

33
Q

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

A

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

34
Q

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

A

Business continuity plan

35
Q

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

A

RAM (Random Access Memory)

36
Q

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

A

By knowing the purpose, the developer can determine how many fields are needed in the database.

The developer can determine which data types would help fulfill the purpose.

The purpose determines the structure of the database.

37
Q

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

A

Planning

38
Q

Which of the following is the correct function of the compiler?

A

Translates the entire program, creating an executable program, which can be run at a later time.

39
Q

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

A

STAR network

40
Q

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

A

Operating system

41
Q

Which of the following would NOT be considered hardware?

A

Word processor

42
Q

(Blank) is a general term that describes any attack that takes advantage of humans’ trusting nature.

A

Social engineering

43
Q

(Blank) uses the concept of reflection of light through a core made up of glass or plastic.

A

Optical wire

44
Q

A (blank) is also known as a datasheet.

A

Database Table

45
Q

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?

A

Information

46
Q

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

A

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.

47
Q

The (blank) 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.

A

FROM

48
Q

Which of the following best describes a hierarchical database format?

A

Data are modeled using parent-child relationships.

49
Q

The (blank) 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).

A

SELECT

50
Q

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

A

Ports

51
Q

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

A

Fourth generation

52
Q

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

A

System Software

53
Q

Learning about social engineering and how to protect passwords is (blank).

A

Education

54
Q

In a SQL query, the (blank) operation combines two tables together?

A

JOIN

55
Q

(Blank) is ephemeral, meaning data stored is lost when the computer is powered off.

A

RAM (Random Access Memory)

56
Q

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.

A

Relational

57
Q

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

A

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.

58
Q

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

A

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

59
Q

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

A

Insert, Update and Delete

60
Q

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

A

Open Source software

61
Q

In the (blank) 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.

A

Design

62
Q

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

A

Loading a statistical program on your personal computer.

63
Q

The scope of the project is considered what?

A

Always accurately identified in the initiation phase.

64
Q

The (blank) is the electronic circuit responsible for executing computer program instructions.

A

Central Processing Unit

65
Q

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?

A

Data mirroring

66
Q

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

A

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.

67
Q

Which two are both types of scripting languages?

A

Ruby and Python

68
Q

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

A

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

69
Q

What is another term that defines a script?

A

Interpreted program

70
Q

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

A

Application

71
Q

What is the definition of business intelligence?

A

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

72
Q
A