wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ITF+ Study Quiz 3

Total questions: 51

Worksheet time: 2hrs 42mins

Name
Class
Date
1.

A developer needs to add a table to a database. Which of the following database activities should the user perform?

a)

UPDATE

b)

ALTER

c)

CREATE

d)

REPORT

2.

Which of the following does a NoSQL database use to organize data?

a)

Primary keys

b)

Schemas

c)

Keys/values

d)

Tables

3.

A systems administrator is setting up a new server using RAID technology. If one hard drive in the array fails, the data is stored on another drive, preventing data loss. Which of the following business continuity concepts does this explain?

a)

File backup

b)

Data restoration

c)

Fault tolerance

d)

Restoring access

4.

A user needs to enter text and numbers to produce charts that demonstrate sales figures. Which of the following types of software would BEST complete this task?

a)

Text editing software

b)

Visual diagramming software

c)

Spreadsheet software

d)

Web browsing software

5.

Which of the following BEST describes the physical location of the data in the database?

a)

Table

b)

Column

c)

RAM

d)

HDD

6.

A user logs into a laptop using a username and complex password. This is an example of:

a)

biometrics

b)

multifactor authentication

c)

least privilege

d)

single-factor authentication

7.

To establish a theory of probable cause, one technician investigates network issues in the server room while another technician troubleshoots the user's workstation. Which of the following troubleshooting methodologies is being performed?

a)

Question the obvious

b)

Divide and conquer

c)

Duplicate the problem

d)

Research the knowledge base

8.

A remote user, who is working from home, requires significant bandwidth to connect to the corporate systems. Which of the following types of Internet service connections would BEST meet the user's needs?

a)

T1 line

b)

Satellite

c)

Fiber optic

d)

DSL

9.

Which of the following types of encryption would BEST protect a laptop computer in the event of theft?

a)

Disk

b)

Email

c)

VPN

d)

HTTPS

10.

Which of the following tasks is typically performed during the identification phase of the troubleshooting methodology?

a)

Question users.

b)

Verify functionality.

c)

Divide and conquer.

d)

Implement the solution.

11.

A technician overhears a systems administrator mention the term 'IOPS'. To which of the following operating system functions would the term BEST apply?

a)

Disk management

b)

Process management

c)

Application management

d)

Service management

12.

Which of the following is the BEST option for a developer to use when storing the months of a year and when performance is a key consideration?

a)

Array

b)

Vector

c)

List

d)

String

13.

A company wants an application to be accessed by concurrent users and store company information securely. Which of the following would be the BEST option for storing the information?

a)

Word processing document

b)

Flat file

c)

Database

d)

Spreadsheet

14.

Which of the following would MOST likely use an ARM processor?

a)

Laptop

b)

Tablet

c)

Workstation

d)

Server

15.

A systems administrator wants to run a script at a certain time every day. Which of the following is the BEST way to achieve this?

a)

Perform process management

b)

Perform task scheduling

c)

Set the system date and time

d)

Set a reminder to run the script

16.

Which of the following would indicate the FASTEST processor speed?

a)

3.6GHz

b)

3.6Mhz

c)

3.6Mbps

d)

3.6Gbps

17.

A gaming console needs to allow for inbound connectivity on a home network to facilitate chat functions. Which of the following devices is a user MOST likely to configure to allow this?

a)

Cable modem

b)

Wireless router

c)

Access point

d)

Network switch

18.

The computer language that is closest to machine code is:

a)

query language

b)

scripting language

c)

markup language

d)

assembly language

19.

Employee information is stored in a database. Which of the following BEST describes where all of an employee's information is stored?

a)

Record

b)

Report

c)

Column

d)

Procedure

20.

Which of the following is an example of an interpreted language?

a)

C++

b)

Java

c)

Python

d)

Go

21.

An employee's laptop does not connect to the Internet when it is used in a coffee shop. Which of the following is the MOST likely cause?

a)

Script blocker

b)

Proxy settings

c)

Private browsing

d)

Full browser cache

22.

Which of the following filesystems would a Linux computer MOST likely use?

a)

HFS

b)

NTFS

c)

FAT32

d)

ext4

23.

Which of the following concerns does installing cross-platform software address?

a)

Subscription

b)

Licensing

c)

Product key

d)

Compatibility

24.

Which of the following requires the MOST frequent updating to remain effective?

a)

Antivirus

b)

Host firewall

c)

Web browser

d)

Device drivers

25.

Which of the following BEST explains the use of float over integer to store monetary values?

a)

It accepts negative values.

b)

It stores symbols

c)

It accommodates larger values.

d)

It supports decimals.

26.

An IP address is 32 bits long. If converted to bytes, it would be:

a)

4 bytes

b)

8 bytes

c)

16 bytes

d)

64 bytes

27.

Which of the following BEST describes the purpose of a vector in programming?

a)

Storing a collection of data

b)

Repeating a similar operation

c)

Capturing user input

d)

Performing mathematical calculations

28.

Which of the following WiFi security options would create the MOST need for a VPN connection on the client device?

a)

Open

b)

WEP

c)

WPA

d)

WPA2

29.

Which of the following BEST describes a technology that allows multiple users to create and edit reports at the same time?

a)

Text file on a shared drive

b)

Managed relational database

c)

Informational intranet page

d)

Locally installed productivity software

30.

A company has installed an application that only requires a workstation to function. Which of the following architecture types is this application using?

a)

One-tier

b)

Two-tier

c)

Three-tier

d)

n-tier

31.

A global variable called 'age' will be created in a program and incremented through the use of a function. Which of the following data types should be defined with the age variable?

a)

Integer

b)

Float

c)

Double

d)

String

32.

Meaningful and accurate reporting is essential to retailers in making business decisions while managing inventory. Which of the following offers the BEST assistance in generating reports?

a)

Data capture and collections

b)

Asset inventory inputs

c)

Sales statistics

d)

Average loss output

33.

A business would like to create an employee portal that employees will have access to when they are at work. The employees will not be able to connect to the portal from home without a VPN connection. Which of the following types of application does this describe?

a)

Local application

b)

Intranet application

c)

Extranet application

d)

Internet application

34.

A computer technician receives a ticket to install a laptop for a new employee. Due to the workspace layout, the employee requests that the laptop be installed with the lid closed. Which of the following would be necessary to fulfill this request? (Choose two).

a)

External hard drive

b)

Mouse

c)

Webcam

d)

Monitor

e)

Printer

35.

A company wants its employee to use an email client that downloads and deletes messages from the email server. Which of the following protocols should be configured on the email client to facilitate this?

a)

POP3

b)

IMAP

c)

ICMP

d)

SMTP

36.

Consider the following statements: if userin = "commander" then clearance = "topsecret" else if userin = "analyst" then clearance = "restricted" else clearance = "normal" Given the input (userin) of 'analyst', which of the following would the clearance variable be set to?

a)

topsecret

b)

normal

c)

analyst

d)

restricted

37.

Which of the following is a reason why complex passwords are required?

a)

To encourage password variety

b)

To prevent someone from guessing them

c)

To make them harder to remember

d)

To reduce social engineering attacks

38.

A technician is troubleshooting an error message and tests the same program on a separate, identical machine. Which of the following troubleshooting methodology steps is this an example of?

a)

Duplicate the problem

b)

Gather information

c)

Question users

d)

Divide and conquer

39.

Which of the following storage types is MOST vulnerable to magnetic damage?

a)

Flash

b)

SSD

c)

Optical

d)

HDD

40.

When developing a game, a developer creates a boss object that has the ability to jump. Which of the following programming concepts does jump represent?

a)

Method

b)

Object

c)

Property

d)

Attribute

41.

Concerned with vulnerabilities on a home network, an administrator replaces the wireless router with a recently released new device. After configuring the new device utilizing the old SSID and key, some light switches are no longer communicating. Which of the following is the MOST likely cause?

a)

The light switches do not support WPA2.

b)

The router is operating on a different channel.

c)

The key does not meet password complexity requirements.

d)

The SSID is not being broadcast.

42.

Given the following pseudocode: For each apple in the basket, eat two oranges unless it is the last apple, then eat three oranges. If there are seven apples in the basket, which of the following would be the number of oranges a person eats?

a)

10

b)

14

c)

15

d)

17

43.

Which of the following are the primary functions of an operating system? (Choose two.)

a)

Provide system resources.

b)

Provide peer-to-peer networking capability.

c)

Provide user data encryption.

d)

Provide protection against malware and viruses.

e)

Provide structure for file and data management.

44.

SQL databases use primary and foreign keys to enable which of the following?

a)

Rows

b)

Fields

c)

Schemas

d)

Relationships

45.

Which of the following is a logical structure for storing files?

a)

Folder

b)

Extension

c)

Permissions

d)

Shortcut

46.

Which of the following is both an input and output device?

a)

Microphone

b)

Speaker

c)

Touch-screen monitor

d)

Keyboard

47.

A technician has successfully verified full system functionality after implementing the solution to a problem. Which of the following is the NEXT troubleshooting step the technician should do?

a)

Determine if anything has changed.

b)

Document lessons learned.

c)

Establish a theory of probable cause.

d)

Duplicate the problem, if possible.

48.

A large payment website was breached recently. A user is concerned that the breach will affect account security on other sites. Which of the following password best practices would mitigate this risk?

a)

Password history

b)

Password reuse

c)

Password expiration

d)

Password age

49.

Which of the following can be used to increase database availability?

a)

Backups

b)

Prioritization

c)

Indexes

d)

Failover

50.

Which of the following would MOST likely identify the issue when a user is warned that a website may not be secure?

a)

Checking the proxy settings

b)

Checking that caching is enabled

c)

Checking browser add-ons

d)

Checking certificate validity

51.

Which of the following describes where the user should verify the port is open for remote desktop on a PC?

a)

Antivirus

b)

Anti-malware

c)

Device Manager

d)

Host firewall