ITF+ Midterm Review

Question 1

Which concept of RDBMS describes “values entered in a field is consistent w/ what information is supposed to be stored"?

Accepted Answer

GIGO

Question 2

A table stores information about __________ (rows) in __________ (columns).

Accepted Answer

Records, fields

Question 3

What shows the structure of code without using the specific syntax of any one language?

Accepted Answer

Pseudocode

Question 4

Which of the following are the main two mobile OSes available on the market today? (Choose TWO)

Accepted Answer

Android, Apple iOS

Question 5

When a programmer inserts a data point into a program for data that will change over time, what data type is used?

Accepted Answer

Variable

Question 6

Which database access method provides a GUI to select actions to be performed & converts them to SQL statements?

Accepted Answer

Query/Report Builder

Question 7

Which of the following are examples of active cooling strategies? (Choose two).

Accepted Answer

Fan, Liquid cooling

Question 8

What is the SQL command to create a database called MYDatabase?

Accepted Answer

CREATE DATABASE MYDatabase;

Question 9

How many bits is two bytes?

Accepted Answer

16

Question 10

A(n) __________ programming language does not need compilation to run.

Accepted Answer

Interpreted

Question 11

What language is usually used to request data from an RDBMS such as Oracle?

Accepted Answer

Structured Query Language (SQL)

Question 12

What type of key can be used to provide a link between data in two tables?

Accepted Answer

Foreign

Question 13

Which of the following are the basic computing operations?

Accepted Answer

Input, process, output, and storage

Question 14

Which elements are required for a computer to perform useful tasks? Select 3.

Accepted Answer

Software, User, Hardware

Question 15

Which of the following troubleshooting steps is the technician using by browsing to the same site as the user?

Accepted Answer

Duplicate Problem

Question 16

Which firmware supports 64-bit CPU operation, a full GUI and mouse operation, and better boot security?

Accepted Answer

UEFI

Question 17

Computers with wired networks can be connected to the internet using which of the following? (Select 2)

Accepted Answer

Network Interface Card (NIC), Ethernet port (RJ-45)

Question 18

What is any computer providing services to other computers and is more powerful and reliable?

Accepted Answer

Server

Question 19

You have just replaced a part in your laptop, it is important that it is assembled in the _______ it was taken apart.

Accepted Answer

Reverse order

Question 20

Which of the following terms would best describe an item that can hold multiple variables without a fixed length?

Accepted Answer

Vector

Question 21

Which of the following numbering systems are decimal values referred to as?

Accepted Answer

Base-10

Question 22

Which of the following protects an author's work from being copied or reused without permission?

Accepted Answer

Copyright

Question 23

Which of the following actions is the FINAL step in the CompTIA troubleshooting theory?

Accepted Answer

Document your findings

Question 24

Which basic SQL data manipulation would be used to modify data in a database?

Accepted Answer

UPDATE

Question 25

What is the decimal number 75 in binary?

Accepted Answer

1001011

Question 26

You are creating a database for a marketing company to store a million contacts. Which should you use to store the data?

Accepted Answer

Relational database

Question 27

Which of the following programming logics utilizes a WHILE statement?

Accepted Answer

Looping

Question 28

Which of the following factors largely determines a computer’s performance? (Choose 3).

Accepted Answer

Capacity of storage, System Memory, Speed of CPU

Question 29

Which notation system supports presenting the largest numbers using the fewest digits?

Accepted Answer

Hexadecimal

Question 30

For support, the software vendor wants to know the application’s product ID. Where to locate this information?

Accepted Answer

Help > About menu

Question 31

Which process occurs before the operating systems software is loaded and enabled by firmware?

Accepted Answer

Bootstrapping

Question 32

Which types of user accounts are supported by Windows? Choose 2.

Accepted Answer

Local, Microsoft

Question 33

You want to check if a condition has been met. If so, perform an action. If not, perform a second action. This is a __?

Accepted Answer

Conditional branch (such as if...then)

Question 34

Windows comes with web server software, but it is not enabled by default. How would you install this software?

Accepted Answer

Use the “Turn Windows features on or off” dialog from Program and Features

Question 35

Which application architecture model describes the application front-end & database engine hosted on the same computer?

Accepted Answer

One-tier

Question 36

A technician is troubleshooting a problem. The theory is tested and confirmed. What is the next step?

Accepted Answer

Establish a plan of action

Question 37

What are the two main types of storage?

Accepted Answer

System memory, Mass storage

Question 38

Which of the following can be considered a basic function of a desktop OS?

Accepted Answer

Provide an environment for software to function.

Question 39

What data protection could you implement to restrict the type of activity users could employ on digital products?

Accepted Answer

Digital Rights Management (DRM)

Question 40

Constants and variables are examples of ?

Accepted Answer

Identifiers

Question 41

Which of the following data types is used in programming to express a variable with a fractional value?

Accepted Answer

Float

Question 42

Which of the following computer components are used to store data? (Select TWO).

Accepted Answer

RAM, HDD

Question 43

The types of PC firmware used on laptops and desktops are: (choose TWO)

Accepted Answer

BIOS, UEFI

Question 44

Which of the following computer components retrieve instructions or data file from memory and processes it?

Accepted Answer

CPU

Question 45

Joe reports his neck/back hurt after being at his desk for the whole day. Which are possible causes? Choose 2.

Accepted Answer

The chair is not properly adjusted to Joe's needs., The monitor height is not adjusted to Joe's needs.

Question 46

To maintain safety , User Account Control (UAC) runs accounts in a protected area called a ____?

Accepted Answer

Sandbox

Question 47

Which defines the rules and structure of a database?

Accepted Answer

Schema

Question 48

Which PC type is housed in a case that can sit on or under a desk and often referred to as a desktop?

Accepted Answer

Workstation

Question 49

Which of the following is performed by the computer to check that main components work and then loads Windows?

Accepted Answer

POST

Question 50

Which is used to manage open windows (applications and files), and is usually positioned at the bottom of the desktop?

Accepted Answer

Taskbar

ITF+ Midterm Review

Questions 50

ITF+ Midterm Review

Questions 50