ITF+ Most Missed Q's Practice Test 2.0

ITF+ Practice Exam 2.0

Frequently missed questions

ITF+ Practice Exam

Which TCP/IP (Transmission Control Protocol/Internet Protocol)

layer encapsulates packets and deals with routing between

different networks?

Most missed
question

Multiple Choice

Which TCP/IP (Transmission Control Protocol/Internet Protocol) layer encapsulates packets and deals with routing between different networks?

• Internet

• Transport

• Network interface

• Application

ITF+ Practice Exam

ANSWER:

Internet

Most missed
question

ITF+ Practice Test

ITF+ Practice Test

Which of the following SQL (Structured Query Language)
commands is NOT a DML (Data Manipulation Language)

command?

Multiple Choice

Which of the following SQL (Structured Query Language) commands is NOT a DML (Data Manipulation Language) command?

• INSERT

• DROP

• SELECT

• DELETE

ITF+ Practice Test

ANSWER:

Create 2 new tables: Products and Purchases.

3rd most missed
question

ITF+ Practice Test

ANSWER:

DROP

DML commands refer to SQL commands that access or modify the

contents of the database. The DROP command deletes (drops) a table

or the entire database, and is a DDL (Data Definition Language)

command, which modifies the structure of the database.

ITF+ Practice Test

Why is it not…..

DML commands include DELETE, which deletes records from a table, and

therefore modifies the contents of the database.

DML commands include INSERT, which adds a new row into a table, and

therefore modifies the contents of the database.

DML commands include SELECT, which is the first building block of a query

to retrieve data from a database.

ITF+ Practice Test

How much storage does a character data type use?

Multiple Choice

How much storage does a character data type use?

• 1 byte

• 4 bytes

• 8 bytes

• 1 bit

ITF+ Practice Test

ANSWER:

1 BYTE

A character (or char) is a single textual character, and can be a letter,

a symbol, or a numerical character, such as A, a, @, 1, etc. Each

character consumes one byte of storage.

ITF+ Practice Test

Why is it not…..

The data type that consumes 1 bit of storage is the boolean data type,
which is a special numeric data type indicating that something is either

TRUE or FALSE.

Floating-point numbers, which can be whole numbers or decimal

fractions, consume a minimum of 4 bytes of storage.

ASCII characters use 1 Byte. Hexadecimal uses 4 bits.

ITF+ Practice Test

A user needs to back up a 6 GB (GigaByte) video file from
a Windows desktop to a new 64 GB flash drive. An error

message warns that the file cannot copy over to the
flash drive, due to file size limitations. What does the

user need to do?

Multiple Choice

A user needs to back up a 6 GB (GigaByte) video file from a Windows desktop to a new 64 GB flash drive. An error message warns that the file cannot copy over to the flash drive, due to file size limitations. What does the user need to do?

• Increase the size of the flash drive's partition.

• Reformat the flash drive into NTFS.

• Reformat the flash drive into HFS.

• Reformat the flash drive into FAT32.

ITF+ Practice Test

ANSWER:

Reformat the flash drive into NTFS.

ITF+ Practice Test

Why is it not…..

FAT32 (File Allocation Table, 32-bit version) is used for formatting

removable drives and disks, by default, as it provides the best

compatibility between different types of computers and devices.

FAT32 allows for maximum file size of 4 GB, so the drive needs to be
reformatted into NTFS (New Technology File System) which allows file

sizes of up to 16 ExaBytes.

ITF+ Practice Test

Which of the following would be used to connect a VoIP phone?

Multiple Choice

Which of the following would be used to connect a VoIP Phone?

• USB

• RJ-11

• RJ-45

• Thunderbolt

ITF+ Practice Test

RJ-45

Voice over internet protocol (VoIP) is a type of phone system that uses an internet connection to make and receive calls, rather than traditional landlines. 

ITF+ Practice Test

Which of the following would be used to connect a user's DSL WAN connection?

Multiple Choice

Which of the following would be used to connect a user's DSL WAN connection?

• USB

• RJ-11

• RJ-45

• Thunderbolt

ITF+ Practice Test

Answer:

RJ-11

DSL is a very high-speed connection that uses the same wires as a regular telephone line.

ITF+ Practice Test

REVIEW

Multiple Choice

Which TCP/IP (Transmission Control Protocol/Internet Protocol) layer encapsulates packets and deals with routing between different networks?

• Internet

• Transport

• Network interface

• Application

Multiple Choice

Which of the following SQL commands would be considered DDL?

• CREATE

• INSERT INTO

• SELECT

• DELETE

Multiple Choice

Which file system allows a file with the name "Mr_Beck_Secret:File01.txt

• HFS+

• NTFS

• FAT32

• Ext4

Multiple Choice

What will be printed by this snippet of code?

for i in range(1,50)

print(i)

• The number 0-49

• The numbers 0 - 50

• The numbers 1-50

• The numbers 1-49

Multiple Choice

A database administrator needs to extend a table with another column. What method contains the command to do that?

• DDL (Data Definition Language)

• XML (eXtensible Markup Language)

• DCL (Data Control Language)

• DML (Data Manipulation Language)

Multiple Choice

What is the first step in the troubleshooting process?

• Document Findings

• Identify the Problem

• Establish a Theory of Probable Cause

• Research

Multiple Choice

Convert the hexadecimal number 2F into decimal notation.

• 12

• 32

• 47

• 45

Multiple Choice

Which of the following authentication factors is an example of something you know?

• A password

• A software token

• A geographic location

• A fingerprint pattern

Multiple Choice

Which of the following is NOT a Scripting Language

• Bash

• Unix

• Java

• Powershell