D075 Information Technology Management Essentials - Set 4 - Part 1

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 1: What is the primary purpose of Structured Query Language (SQL)?

To design web pages

To manipulate and query data in relational databases

To manage networking protocols

To encrypt sensitive information

Question 2: Which of the following refers to the process of combining large datasets for analysis?

Data Mining

Data Warehousing

Data Encryption

Data Validation

Question 3: Which component of a computer network manages and directs data traffic between devices on the same network?

Router

Firewall

Switch

Modem

Question 4: What is the function of a bus topology in networking?

Connects each computer to a central node

Connects all devices in a linear fashion with a common backbone

Connects devices in a ring formation

Connects multiple LANs across a wide area

Question 5: Which technology allows the transmission of voice, video, and text data over the internet?

VoIP

HTTP

DNS

VPN

Question 6: What does the acronym RDBMS stand for?

Random Data Backup Management System

Relational Database Management System

Resource Data Backup and Management System

Remote Database Management Software

Question 7: What is the purpose of an Ethernet cable in networking?

To provide wireless connectivity

To connect devices to a wired network

To increase internet speed

To store data locally

Question 8: Which term refers to the data stored in rows and columns in a database?

Field

Record

Table

Query

Question 9: Which protocol is responsible for secure communication over the internet?

FTP

HTTP

HTTPS

SMTP

Question 10: Which network topology connects all devices in a circular format?

Bus

Star

Ring

Mesh

Question 11: Which term describes a set of protocols used to communicate data over the internet?

DNS

HTTP

TCP/IP

FTP

Question 12: Which device is used to connect a private network to the internet?

Switch

Modem

Server

Proxy

Question 13: Which tool is used to create visualizations from large datasets to gain insights?

Spreadsheet Software

Tableau

SQL

Microsoft Word

Question 14: What is the primary function of a firewall?

To route data between networks

To protect a network from unauthorized access

To speed up data transfer

To store backup data

Question 15: Which component of the cloud allows businesses to store data and applications remotely?

Virtual Machine

Cloud Storage

Ethernet Cable

Local Server

Question 16: What is the purpose of a Gantt chart in project management?

To represent the hierarchy of tasks

To visually display the project schedule

To assign team members to tasks

To record project risks

Question 17: Which device allows multiple computers to communicate with each other over a network?

Router

Firewall

Switch

Modem

Question 18: Which component of a computer stores temporary data for quick access by the CPU?

Hard Drive

RAM

SSD

BIOS

Question 19: What does the acronym GUI stand for in computing?

General User Information

Graphical User Interface

Global User Integration

Generic Utility Interface

Question 20: Which tool is primarily used for analyzing large datasets and identifying patterns?

Data Encryption

Data Mining

Data Validation

Data Querying

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support