NEW
Font size
WorksheetsИКТ 165-228
Total questions: 64
Worksheet time: 32mins
165.What type of user interface does use windows, icons, menus and pointers?
Command Line Interface
Graphical User Interface
System Interface
Menu Driven Interface
166.The basic data structure of the relational model is ...
Record
Output
Report
Table
167.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
8
1
6
168,What format of cells does not exist?
Monetary
Financial
Foreign exchange
Numerical
169,Which is the type of local area network in which all microcomputers in the network communicate directly with one another without relying on a server?
Client-server
MAN
Domain
Peer to peer
170.Which of these is NOT a type of server?
RAM server
Disk server
Print server
File server
171.Which of these best describes the regular telephone line that is used in most homes today?
Coaxial cable
Modem cable
Twisted-pair wire
LAN
172.How do fiber-optic cables transmit data?
Via infrared
Via radio waves
Via AC electric current
Via pulsating beams of light
173.What is hardware and/or software that protects computers from intruders?
Backup
Firewall
Router
Anti‐virus
174.Which attack slows down or crashes equipment and programs?
Denial of Service (DoS)
Zero-day or Zero-hour
Firewall
Virtual Private Network (VPN)
175.Which option describes malicious code running on user devices?
Firewall
Denial of Service (DoS)
Virus, worm, or Trojan horse
Virtual Private Network (VPN)
176.What is the purpose of an IP address?
It identifies the physical location of a data center
It identifies a location in memory from which a program runs
It identifies a return address for replying to email messages
It identifies the source and destination of data packets on a network
177.What is an advantage of the peer-to-peer network model?
Scalability
ralized administration
Ease of setup
High level of security
178.Short for electronic commerce, it is the business of buying and selling products online.
E-commerce
E- store
E-connection
E- government
179.What is a collection of files storing related data?
database
data model
database management system
data integrity
180.Give an example of Database Management System
Delphi
Oracle
Pasca
Cardreader
181.What concepts don't relate to database?
Folder
Table
File
Record
182.What language is used to communicate with a database?
Data Definition Language
Data Manipulation Language
Pascal
Structured Query Language
183.A group of 8 bits taken as a single unit
Bit
Word
Bot
Byte
184.What data query in SQL means to choose lines from tables?
UPDATE
DELETE
SELECT
CREATE
185.What data query in SQL means to add a line to the table?
DELETE
SELECT
INSERT
UPDATE
186.What is a system software for creating and managing databases?
database management system
data systems
design of databases
data integrity
187.What should the user do to select the information stored in the database?
The user must sort the data
The user shall execute a request (query)
The user must select the one from the list
The user must update the information
188.The user must update the information
Verification
Classification
Merging
Sorting
189.Which selection below best describes the term data processing?
The manipulation of information or data
The distribution of information or data
The collection of information or data
The storage of information or data
190.Which of the following is used for modulation and demodulation?
modem
gateway
multiplexer
protocols
191.What is the term which represents the use of links between information of all sorts whether text, graphics, video, or audio-based?
Hypertext
Hyper Card
Hypermedia
Wildcard
192.What is the standard code the computer industry created to represent characters?
DASI
BASCII
ASSH
ASCII
193.A sizeable geographical area with communication-based on the telephone system is though as
Local area network
Wide area network
Modulator-Demodulator
All of these
194.Condensing output data to exhibit specific information is
Recording
Summarising
Merging
Calculating
195.A computer in a client/server relationship, e.g., a Web browser
Ethernet
Server
Client
All of these
196.A computer that provides services to other networked computers
Server
Client
All of these
WAP
197.Serves users within a confined geographical area
Local Area Network (LAN)
Metropolitan Area Network (MAN)
Wide Area Network (WAN)
WAD
198.Covers a geographic area the size of a city or suburb
Local Area Network (LAN)
Metropolitan Area Network (MAN)
Wide Area Network (WAN)
WAN
199.How can a star topology be implemented while maintaining the principles of a ring topology?
TCP/IP
Token Ring
Ethernet
Inetrface
200.Covers a wide geographical area, such as a state or a country
Wide Area Network (WAN)
Metropolitan Area Network (MAN)
Local Area Network (LAN)
Inetrface
201.Who is called the "grand father" of the computer?
Dr. Herman Hollerith
Blaise Pascal
Joseph Jacquard
Charles Babbage
202.A central computer surrounded by one or more satellite computers is called a
ring network
bus network
star network
hybrid network
203.What is a key component of Von Neumann architecture?
Arithmetic logic unit
Touchscreen display
Ink printer
Solar panel
204.Which device sends data from a computer over a network?
Keyboard
Network Interface Card (NIC)
Mouse
Printer
205.Which type of relationship is the most common in relational databases?
One-to-many
Many-to-many
One-to-one
Circular
206.What is the primary key in a database?
A method of sorting records
A type of database security
A field that uniquely identifies a record
A tool used to design databases
207.What is a data model?
A specific type of computer hardware
A representation of how data is structured in a database
A method to display data on a screen
A formula used for data encryption
208.What is a decision tree?
A graphical user interface
A type of computer virus
A programming language
A decision support tool using a tree-like model of decisions and consequences
209.What is the root node in a decision tree?
A command used in SQL
It represents the entire population or sample
The final outcome of a decision
The point where data is stored
210.What is data mining?
A process of discovering hidden patterns in large data sets
A method of reducing data size
A physical storage of data
A process of encrypting sensitive information
211.What is the purpose of data analysis?
To extract useful information from data for decision-making
To automate system processes
To destroy unwanted data
To increase data storage capacity
212.What is the main characteristic of big data analysis?
A small set of data
A manual data processing technique
A processing of large and complex data sets
A simple spreadsheet analysis
213.What is the purpose of visual data mining?
To display images of data
To explore large data sets by combining traditional mining methods and visualization techniques
To store visual data like pictures and videos
To convert text data into graphical
214.What is the main role of a database administrator?
To input data into tables
To design user interfaces
To create database backups
To manage and maintain the database server
215.What is the purpose of a relational database management system (RDBMS)?
To design hardware components
To organize web pages
To store files on a computer
To create, maintain, and manipulate relational databases
216.What is the main purpose of network media?
To display information to users
To control network devices
To store data in a database
To provide the channel for transmitting data from source to destination
217.What is cybersecurity?
Cybersecurity is a set of tools, policies, and technologies to protect the cyber environment
A type of computer virus
A program for hacking
A type of computer hardware
218.What is a cyber crime?
A new encryption method
A type of network configuration
Any criminal act dealing with computers and networks
A computer game
219.What is the main characteristic of 3D graphics?
They are based solely on raster graphics technology
They involve the mathematical representation of 3D surfaces using specialized software
They cannot include animations or dynamic elements
They are exclusively used in the gaming industry
220.What is an example of linear multimedia?
A video game with multiple story paths
A movie or video that plays from start to finish
An online encyclopedia with hyperlinked content
A slideshow controlled by the user
221.Which protocol is responsible for receiving e-mail from the server?
UDP
Proxy Server
IMAP or POP3
SNMP
222.What type of language is Python considered to be?
Low-level, compiled, non-portable language
Object-oriented, interpreted, ultra-high-level language
Functional, compiled, platform-dependent language
Assembly-based, low-level, non-interpreted language
223.Which Python command is used to read user input as a string by default?
raw()
read()
scan()
input()
224.Which of the following is NOT an arithmetic operator in Python?
":="
"+"
"-"
"**"
225.What does the expression a // b compute in Python?
Exponentiation
Integer (floor) division
Floating-point division
Remainder of the division
226.What is the purpose of the if statement in Python?
To conditionally execute a block of code based on a logical expression
To repeat a block of code multiple times
To define a new function
To handle exceptions and errors
227.Which of the following best describes Artificial Intelligence (AI)?
A database management system for storing large datasets
Any program written in Python
A simple calculator performing fixed arithmetic operations
A technology that mimics human intelligence to perform tasks requiring human involvement
228.What is GPT (Generative Pre-trained Transformer) mainly used for?
Generating plausible human-like text
Rendering 3D graphics
Compiling Python programs
Managing operating systems
