Font size
WorksheetsIT fundamentals Practice quiz 1
Total questions: 76
Worksheet time: 39mins
In SQL, which statements are used to grant or deny specific rights to user accounts over objects in the database?
Data control language
Data Definition language
Data Manipulation Language
Data Querylanguage
Which of the following methods of authentication involves something that the user has?
Security questions
Pin
Hardware Token
Biometrics
Which component(s) of a computer system are involved in graphics processing? (Select TWO).
Power supply Unit (PSU)
Radom access memory
GPU
Cooling System
Hard disk drive
Which of the following interfaces would you use to connect a device to a network over a telephone line?
USB
RJ-45
RJ-11
Thunderbolt
In the context of object-oriented programming, what is a property of an object?
A property is a contract between an object and its subclass
A property is a specific action or function that the object can perform
A property is the relationship two or more objects.
A property is a characteristic or attribute to an object, used to hold date
How do document databases differ from traditional relational databases?
Document Database only store text documents.
Document Database cannot establish data relationships.
Document Database store data in a semi-structured format allowing for flexibility in a date structure.
Document Database are inherently slower
What does GPU stand for in the context of computer hardware?
Gaming Process Unit
General Process Unit
Graphics Process Unit
Graphical Performance Unit
Assembly language is a type of programming language used in various computing contexts. Which of the following options BEST describes the characteristics of assembly language?
Its a query language used mainly for managing Ana manipulating databases
It is a low-level language closely related to machine code but readable by humans
It is a high-level language used primarily for web development.
It is an interpreted language with functionalities like scripting languages like python or Javasscript.
Mark is a data analyst at a health tech company. They've collected data on customers' physical activity levels and sleep quality. Mark's task is to understand if there's a relationship between these two variables. Which is the BEST approach Mark should use?
Utilize data correlation to determine the statistical relationship between physical activity and sleep quality.
remove any outlier in the data set before analyzing , as they couldn't distort the results.
focus solely on the data about physical activity's its the most important factor.
ignore the acquired data and ,are assumptions based on personal experience.
John, a project manager at Dion Training, wants to terminate a resource-hungry application. Which of the following would BEST help achieve this?
Memory Management
Process Management/ Scheduling
Access Control/Protection
Disk Management
Maria, an IT administrator, wants to enhance password security for Dion Training's employees. Which of the following is the BEST policy to implement?
Enforce a password minimum length of 4.
Encourage employees to use simple and common dictionary words as passwords for easy memorization.
allow employees to share passwords within their department for ease of collaboration.
implement a password manager tool to generate and store complex passwords for each employee.
Which type of CPU architecture is commonly found in mobile phones and tablets?
64-bit
32-bit
ARM
SSD
Which of the following software types is tailored to meet a company's unique requirements and help streamline its operations?
Instant Messaging Software
Email Client
Business-Specific Specification
Conferencing Software
Why would a programmer opt to use a query language?
To design and manipulate database effectively
To develop mobile application for various platforms
To Write impressive graphical user interface
To write high-performance, system-level programs.
Your company's CEO has just tasked your IT team with creating a safeguarding measure that could be used to completely restore the customer database in the event of a system failure or data loss. This measure should include a comprehensive backup of all data and structures in a format that can be used to recreate the original database. What term BEST describes this safety measure?
Using query builders and report generation tools.
the process assigning roles and permissions
manual scripting of SQL commands for database interaction.
creating a database dump.
Which of the following BEST describes one of the main purposes of a database?
To provide structured storage of data
to design website interface.
to automate document creation
to create animations for video games.
Samuel is setting up his computer workstation and wants to connect his computer to an older display device that uses analog signals. Which of the following is MOST used to connect a computer to a display device using analog signals?
VGA
DisplayPort
DVI-D
HDMI
Aaliyah is faced with a complex problem in her software development project. Which of the following strategies would be the most effective for Aaliyah in solving this problem?
waiting for a colleague to solve the problem.
breaking the problem down into smaller, manageable parts and solving each part individually
Trying random solutions until one works
ignoring the complexity and trying to solve the problem in one go.
You are given an array arr = [12, 7, 15, 21, 27] in a programming language. You wish to access the third element of this array using zero-based indexing. Which of the following sorts of access will provide you the desired result?
arr [0]
arr [2]
arr [3]
arr [4]
What is the primary purpose of creating written IT policies and procedures in an organization?
to guide employees in using it resources securely
to monitor employee performance to regulate internet usage.
to reduce It cost
to regulate internet usage
What is the main difference between OEM websites vs third-party websites?
OEM websites focus on hardwares sales, while third party websites specialize in software distribution
OEM websites provide software directly from the original manufacturer, while third party websites offer modified versions or unauthorized copies.
OEM websites requires users registration and verification, while third- party websites allow Anonymous downloads
OEM websites offer discounted prices and exclusive deals, while third party websites have higher prices
You are the IT support technician for a company. An employee reports that their computer is running slower than usual. When asked, the employee mentions that file saving, program launching, and overall computer processing are slower, but internet browsing speed is unaffected. What could be the potential issue based on these symptoms?
Network Connectivity Issues
Browser Hijack
Operating system corruption
Insufficient Ram or disk Space
What is the purpose of password history requirements?
to prevent users from re-using old passwords
to track and monitor use login activities
to enforce a maximum number of failed login attempts
to remind users to change their password regularly
Which of the following tools assists in managing multiple unique passwords, thus aiding in avoiding password reuse across sites?
Password history
Password complexity
Password expiration
Password managers
Jacob is setting up a network for his company. He is comparing various internet service providers and their offers. In the context of network throughput, which unit should he consider for evaluating their data transfer rates?
Megabits per second (Mbps)
Ampere
Graphics double data rate (GDDR)
Watts
Which of the following is designed to efficiently handle multiple concurrent users?
Databases
Both databases and flat files
Flat files
Neither databases and flat files
Sarah is a computer technician at a large office. She is tasked with setting up and configuring several network printers and scanners for the newly established marketing department. Sarah needs to ensure that the IP addresses for each device are correctly assigned to enable network communication. What type of peripherals typically require manual configuration of IP addresses for network connectivity?
driver Installation
plug-and play
web-based configuration
Ip-based peripherals
Jane needs to share a large amount of data with her team, who all work in the same office building. Which local network storage type would be more suitable for her?
NAS
HDD
Flash Drive
SSD
Kris is a software engineer tasked with developing a new feature for an application. Which of the following strategies would be the MOST effective for Kris in ensuring the best solution?
Ignoring other potential solutions once he has found not that works
waiting on a colleague to suggest a solution.
considering multiple approaches and choosing the one that best fits the requirements.i
implementing the first solution that comes to mind
Which of the following devices are specifically built to offer entertainment by streaming digital content such as videos or music?
IoT devices
Streaming media devices
Servers
Workstations
When designing a database, what feature allows you to impose certain limitations on the values that can be entered into each field, ensuring consistency and data integrity?
Normalization
Constraints
Encryption
Indexing
In software programming, what functions do loops typically serve? (Select TWO).
establishing data connectivity
make secret function variables
encrypt the code
iteratively access array elements
perform a task repeatedly until a certain condition is met.
Which of the following interfaces is used primarily for connecting Mac computers and devices, and offers the MOST data transfer speed?
Thunderbolt
VGA
Firewire
RJ-11
What is the primary difference between plain text and cipher text?
Plain Text is encrypted, while cipher text is decrypted
Plain Text is readable and understandable, while cipher is encrypted
Plain Text is transmitted over the network, while cipher text is stored locally
Plain Text is compressed, while cipher text is uncompressed
Which of the following is unique to each network device and cannot be changed?
MAC address
Network Name
Serial number
IP address
What are folders/directories primarily used for?
Modifying file extensions
organizing files within a system
setting file permissions
file encryptions
What is the main purpose of prioritizing data restoration during disaster recovery?
to reduce the time needed to restore all data
to comply with the data protection regulations
to save storage space during recovery
to ensure the most critical systems and data are recovered first to minimize business disruption.
Mike, a network engineer at Dion Training, needs to understand the advantages of encrypting his files. What is the primary benefit of file encryption?
increase processing speed
protection from unauthorized access
reduced file size
facilitate data recovery
How does cloud storage service differ from local storage types like RAM, hard drives, etc.?
Cloud storage is accessed over the internet and is not physically present at the users' location.
cloud storage only supports a limited under of files formats.
Cloud storage is a volatile storage.
cloud storage requires no internet connections.
Which licensing model would you likely encounter when subscribing to a Software as a Service (SaaS) product?
subscription
group use/site license
on-time purchase
Opensource
Lisa has just come across an awesome extension that can help her productivity. She uploaded the extension to her browser but can't utilize it. What could be responsible for this?
The cache has not been cleared
Certificate is invalid
Incorrect proxy Setting
The extension is disabled
What is a significant difference between Assembly language and Machine code?
Assembly Language is not translated into machine code for execution
machine code pertains to high-level languages , while assembly is low-level language
Machine code cannot be read or written by programmers, while assembly language can be read and written
assembly language is platform-independent, while machine code is platform-dependent
Which of the following fundamental data types is used to represent a sequence of characters or text in a programming context?
Strings
Char
Numbers
Boolean
Which of the following fundamental data types is used to represent truth values, typically true or false, in a programming context?
Boolean
Strings
Number
Char
Which of the following BEST describes the function of a table in a Database Management System (DBMS)?
To speed up the query processing engine
to record the transaction history in the database
to store related records, each consisting of one or more fields
To determine user access permissions in the database.
Which of the following is NOT primarily used as a processing device in a computer system?
GPU
SSD
CPU
ALU
Sasha is working on her laptop. She types a command into a command terminal using her keyboard. The computer processes the command, and then information about the completed task is displayed on her screen. Which of the following statements BEST lists all of the functions described in the scenario?
Input,Output,Storage
Input, processing, and storage
Output and processing
Input, Processing, and output
A high-end computer has a 3.5 GHz multi-core processor. If a graphic-intensive task requires 2.5 billion cycles to complete, approximately how long will the CPU take to complete the task, considering it processes all cycles in a single core and efficiency is perfect?
2.5 Seconds
5.0 Seconds
Less than 1 second
10.0 seconds
Which aspect of an operating system ensures that resources are used only in ways that satisfy predetermined policies?
Date encryption
Firewall
Access Control
Security Patch
Sarah works as a data entry clerk in Dion Training. Her job involves entering large amounts of data and commands into the computer system. This requires a specific peripheral device designed for this purpose. Which peripheral device is used for entering data and commands into a computer?
Printer
keyboard
Scanner
Mouse
Which of the following types of RAM architecture allows for larger memory addressing and better performance?
64-bit Ram
32-Bit Ram
SSD Ram
GPU- Ram
In a high-level programming language, you have a repeating sequence of actions that needs to process different sets of data at various points in your code. Which programming concept is BEST suited to bundle these actions for future reuse and maintain a DRY (Don't Repeat Yourself) approach?
Creating a function that encapsulates the repeating actions.
Defining an array that holds pieces of the repeating code.
establishing a list of variables for each repeating action.
creating a loop structure to continuously perform the repeating action.
What software maintains and manipulates datasets, often using structured query language (SQL)?
Database software
Conferencing Software
Web browser
Accounting Software
What software is specifically meant for managing work projects and tasks within a team?
Email client
Project Management Software
Visual diagramming software
Conferencing Software
Which of the following security measures is most effective in addressing known vulnerabilities and fixing software bugs in computer systems?
Patching updates
Host Firewall
Chaining Default passwords
Anti-Virus/AntiMaleware
In which of the following scenarios would a database manager need to use the CREATE command?
When they want to extract specific information from a table.
When they need to add a new table to the database .
when they need to remove an unwanted table from the database
when they want to modify the structure of an existing table
Susan is developing a program where the user must input a discount rate as a decimal number to calculate the final price of a product. However, Susan notices that whenever a user inputs a value like 0.15, the program is throwing an error. Which of the following is the MOST likely error?
The program can only accept negative numbers.
The user input is being received as a string.
The program field was designed to accept an integer, not a float.
The program doesn't recognize decimal numbers.
Which feature of a normal antivirus software is responsible for automatically scanning files and programs in real-time as they are accessed or downloaded?
Heuristic analysis
Quarantining and remediating infected systems,
on access scanning.
schedule scanning.
Two routers are installed in a house and both are using default settings. What could represent a security risk?
Both Routers are using different channels
Both routers are located near windows
Both Routers are using the default SSID and password
Both routers support the newest wireless standard 802.11ac
What term is used to describe data that is being transmitted over a network?
Data in Transit
Cipher in text
Data at rest
Plain text
Which of the following is a unique characteristic of the Ext4 filesystem in comparison to FAT32?
Limited to small capacity drives
compatible with windows system
encrypt data storage.
Its support journaling
Which of the following is NOT primarily used as an output device in a computer system?
Monitor
Speakers
Scanner
Printer
What is the key difference between an application that is 'locally installed' and one that is 'local network hosted'?
local availability of files
require of a network
use of cloud services
need for internet access
Lisa is continually pestered by unwanted ads while browsing. How could she reduce this annoyance?
Adding an invalid certficate
enabling a popup blocker
deactivating client-side scripting.
Clearing the browser cache.
Which of these file systems is designed with a limitation to a single user, making it unsuitable for multi-user systems?
NTFS
Ext4
HFS
Fat32
James, an IT professional, receives a report from a user complaining about their computer constantly freezing. The user mentions that the issue occurs only when they are using their web browser, with no such problems while using other applications. Which of the following options is MOST likely to be the problem?
The users web browser is experiencing issues
The computer ram is faulty
The computer power supply is malfunctioning
The computer hard drive is failing.
What is the purpose of a company using security controls in relation to its data?
To increase the data storage
to enhance the quality of data
to ensure the data is only accessible with authorization
to make data easily transferable
Which of the following computing devices can monitor and control alarms, locks, lighting, and provide videophone entry systems remotely?
Servers
Mobile Phones
Laptops
Security Systems
Which of the following best describes the primary function of encryption in mobile applications?
Speeding up the data Transmissions
Making the user interface more user friendly
decreasing the size of the application.
Securing data sorted within the application and during transmission.
Imagine you are setting up a wireless network for your home. You want to ensure that it is more challenging for potential attackers to detect your network. Which of the following BEST practices should you implement to achieve this?
Implementing a captive portal
allowing open access
changing SSID
keeping the default password
Mark, an IT technician at Dion Training, is tasked with implementing a security measure to protect the company's internal network from unauthorized external access. He decides to deploy a hardware or software-based solution that monitors and filters incoming and outgoing network traffic based on predetermined rules. Which of the following security measures is Mark implementing?
data encryption
user access control
antivirus software
firewall protection.
Which of the following external factors can cause an unplanned and temporary disruption of service specifically due to a loss of infrastructure?
Denial of service
Service Outage
Destruction
Power Outage
Mary, an IT specialist at Dion Training, is preparing for file management training for her team. She is explaining the concept of file types and extensions. Which of the following can serve as the correct justification for file types and extensions?
Control files access speed
determines the storage structure.
Help operating systems understand file;e content and determine the right program
validate user permissions
Which of the following cellular digital formats allows a subscriber to use a SIM (Subscriber Identity Module) card to use an unlocked handset with their chosen network provider and is internationally adopted?
LTE
GSM
CDMA
Wifi
Which of these applications would be considered bloatware? (Select TWO).
productivity Suite
Trial software with limited functionality
pre-installed software that offers unnessarry features and functions.
Antivirus software
In the context of object-oriented programming (OOP), how are functions typically associated with objects?
Functions are hardly used in loop.
each object can have only one function associated with it.
function renamed as method , represents behavior of objects
functions always get declared outside the object and can't be part of it
