NEW
Font size
WorksheetsComputer Fundamentals & Networking Questions
Total questions: 55
Worksheet time: 28mins
Which are disadvantages of Cloud Computing
High upfront capital costs
Internet dependent service access
Guaranteed on‑premises privacy
Requires daily hardware upgrades
A type of online fraud, the purpose of which is to gain access to confidential user data – logins and passwords
Phishing through fake sites
Smishing by text messages
Vishing with voice calls
Spoofing headers only
What type of user interface where the user has a list of items to choose from, and can make selections by highlighting one?
Gesture based interface
Menu driven interface
Voice only interface
Command line interface
What is a big C/C++ program written by someone else that allows us to manage efficiently a large database
Spreadsheet application
Web browser engine
Operating system kernel
Database management system
The basic data structure of the relational model is …
Document key–value pairs
Tree of nested records
Graph nodes and edges
Table with rows and columns
Choose Operating system
Chrome web browser
Python scripting language
Linux open‑source OS
MySQL database server
Choose antiVirus programs
Notepad text editor
Slack collaboration app
Apache HTTP server
McAfee security suite
Characteristics of Primary key in DBMS
Identify a row uniquely in a table
Stores large binary files
Allows duplicate values
Creates automatic backups
With which documents we work in Excel?
Text-only notes
Presentation slides
Database catalogs
Workbooks with worksheets
To write a formula into a cell, we select it and press the button ....
"+" arithmetic sign
"=" equals sign
Enter confirm key
Ctrl+F formula mode
What type of user interface uses windows, icons, menus and pointers?
Command line interface
Form-based interface
Graphical user interface
Menu-driven interface
The basic data structure of the relational model is ...
Table relation entity
Queue first-in first-out
Array sequential list
Stack last-in first-out
In the range A1:A4, the values 1, 2, 3, 4 are entered in order. What will be the result in cell B1 if it specifies the formula "=MAX(A1:A4)"?
4 largest value found
3 middle value returned
1 minimum value found
2 averaged value returned
What format of cells does not exist?
Text string format
Date and time format
General numeric format
Foreign exchange format
Microcomputers in the network communicate directly with one another without relying on a server?
Cloud hosted mesh
Star hub topology
Peer to peer model
Client–server topology
Which of these is NOT a type of server?
RAM server memory
File server storage
Mail server messaging
Web server hosting
Which of these best describes the regular telephone line that is used in most homes today?
Twisted‑pair wire cabling
Coaxial cable medium
Fiber‑optic glass strands
Satellite microwave links
What is hardware and/or software that protects computers from intruders?
Compiler build tool
Router path selector
Proxy cache server
Firewall network barrier
Which attack slows down or crashes equipment and programs?
Denial of Service (DoS)
Phishing credential theft
Spoofing address forgery
Sniffing packet capture
What is the purpose of an IP address?
It identifies the source and destination of data packets
It encrypts all payloads end to end
It blocks unsolicited network traffic
It logs user browsing histories
What is an advantage of the peer‑to‑peer network model?
Guaranteed centralized backups
Dedicated enterprise servers
Ease of setup for small groups
Strong role-based governance
Short for electronic commerce, it is the business of buying and selling products online.
T‑commerce television
S‑commerce social
M‑commerce mobility
E‑commerce transactions
What is a collection of files storing related data?
Database structured set
Spreadsheet grid tool
Archive zip bundle
Folder directory only
Give an example of Database Management System
Linux desktop shell
TensorFlow ML library
Chrome browser client
Oracle relational DBMS
What concepts don't relate to database?
Folder file container
Table relational unit
Tuple record instance
Attribute column type
Which language is primarily used to communicate with relational databases?
Database Command Language
Structured Query Language
Hierarchical Query Language
Relational Script Language
Which SQL statement adds a new row into an existing table?
INSERT
CREATE
ALTER
GRANT
To retrieve stored information in a database, what should a user execute?
A schema migration
A sort operation
A backup routine
A request query
What is the term for arranging data items into a specific order?
Clustering
Indexing
Sorting
Hashing
Which device is used for modulation and demodulation of signals?
Repeater
Router
Modem
Switch
Which term represents the use of links among diverse media such as text, graphics, video, and audio?
Teletext
Hyperthread
Hypermedia
Multicast
Which standard code was created by the computer industry to represent characters?
UTF-32
ASCII
EBCDIC
BCD
A sizeable geographical area with communication based on the telephone system is typically called a what?
Wide area network
Campus backbone
Local area network
Personal area network
What do we call a computer that provides services to other networked computers?
Terminal
Peer
Client
Server
Which network type serves users within a confined geographical area?
Network PAN
Network MAN
Network LAN
Network WAN
Which network covers an area the size of a city or suburb?
Personal Area Network
Local Area Network
Metropolitan Area Network
Wide Area Network
Who is often referred to as the grand father of the computer?
Charles Babbage
Alan Turing
John von Neumann
Ada Lovelace
Which is a key component of Von Neumann architecture responsible for calculations?
Floating point coprocessor
Arithmetic logic unit
Control storage unit
Graphical processing unit
Which relationship type is most common in relational databases?
Many-to-many
One-to-one
One-to-many
Recursive-only
Which phrase best defines a data model?
Representation of how data is structured
A compression scheme for tables
A runtime engine for queries
A list of user access rights
In a decision tree, what does the root node represent?
Entire population or sample
Final predicted outcome
Only categorical features
Single training instance
Which statement best describes data mining?
Encrypting data before transport
Visualising dashboards and charts
Discovering hidden patterns in large sets
Backing up transactional databases
What is the purpose of data analysis in decision-making?
Archive raw logs for storage
Extract useful information for decisions
Normalize schemas for performance
Transmit packets across networks
Which is a main characteristic of big data analysis?
Using single-threaded algorithms
Focusing only on small samples
Requiring manual data entry only
Processing large and complex data sets
What is the goal of visual data mining techniques?
Limit exploration to numeric columns
Compress charts for faster rendering
Replace statistical modeling with graphics only
Explore large data by combining mining and visualization
What is the purpose of a relational database management system (RDBMS)?
To render 3D scenes for animation studios
To create, maintain, and manipulate relational databases
To organize spreadsheets for basic arithmetic
To encrypt network traffic for secure browsing
What is the main purpose of network media?
To compress files to reduce storage space
To authenticate users on application servers
To provide the channel for transmitting data from source to destination
To store backups on external hard drives
What is cybersecurity?
A social media policy for online etiquette
A hardware standard for fiber-optic cabling
A set of tools, policies, and technologies to protect systems and data
A programming language for mobile applications
What is a cyber crime?
A certification exam for security analysts
A routine backup of corporate databases
A lawful audit of enterprise information systems
An act dealing with computers and networks to commit illegal activities
What is the main characteristic of 3D graphics?
They only display wireframe models with no shading
They involve the mathematical representation of 3D surfaces using specialized techniques
They rely exclusively on bitmap textures without geometry
They use pixel grids for 2D sprites
Which is an example of linear multimedia?
A slideshow with clickable hyperlinks
A video game with user choices and paths
A movie or video that plays from start to finish
An interactive branching simulation
What type of language is Python considered to be?
Assembly language for microcontrollers
Declarative query language for databases
Object-oriented, interpreted, high-level language
Low-level compiled systems language
Which of the following is NOT an arithmetic operator in Python?
* for multiplication
-= for augmented assignment
+ for addition
/ for true division
What is the purpose of the if statement in Python?
To declare constant variables at runtime
To define immutable tuples for data storage
To conditionally execute a block of code based on a logical expression
To import external libraries into a program
Scenario: A helpdesk receives phishing emails. Which network-layer choice best prevents message retrieval to a client while leaving sending unchanged?
Disable SMTP to stop outgoing mail delivery
Enable POP3 or IMAP to fetch emails from servers
Block POP3 or IMAP to prevent retrieving messages
Replace DNS with FTP for secure name resolution
