Font size
WorksheetsICT practica ENU
Total questions: 101
Worksheet time: 34mins
What is an example of linear multimedia?
A video game with multiple story paths
A movie or video that plays from start to finish
A website with interactive forms
An online encyclopedia with hyperlinked content
What is the main characteristic of 3D graphics?
They involve the mathematical representation of 3D surfaces using specialized software
They cannot include animations or dynamic elements
They involve the mathematical representation of 3D surfaces using specialized software
They cannot include animations or dynamic elements
What is a cyber crime?
Any criminal act deWhat is a cyber crime? aling with computers and networks
A type of network configuration
A new encryption method
A computer game
What is cybersecurity?
A type of computer virus
A type of computer hardware
A social media platform
Cybersecurity is a set of tools, policies, and technologies to protect the cyber environment
What is the main purpose of network media?
To control network devices
To block unauthorized access
To provide the channel for transmitting data from source to destination
To store data in a database
What is the purpose of a relational database management system (RDBMS)?
To create, maintain, and manipulate relational databases
To store files on a computer
To organize web pages
To design hardware components
What is the main role of a database administrator?
To create database backups
To manage and maintain the database server
To design user interfaces
To create new software applications
What is the purpose of visual data mining?
To display images of data
To create presentations using data
To explore large data sets by combining traditional mining methods and visualization techniques
To store visual data like pictures and videos
What is the main characteristic of big data analysis?
A manual data processing technique
A processing of large and complex data sets
A small set of data
A simple spreadsheet analysis
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
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
What is the root node in a decision tree?
It represents the entire population or sample
A command used in SQL
The final outcome of a decision
The point where data is stored
What is a decision tree?
A programming language
A type of computer virus
A method of organizing files on a computer
A decision support tool using a tree-like model of decisions and consequences
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
What is the primary key in a database?
A type of database security
A field that uniquely identifies a record
A method of sorting records
A description of table columns
Which type of relationship is the most common in relational databases?
Many-to-many
One-to-one
One-to-many
Multiple-to-single
Which device sends data from a computer over a network?
Network Interface Card (NIC)
Keyboard
Mouse
Printer
What is a key component of Von Neumann architecture?
Arithmetic logic unit
Touchscreen display
Ink printer
Solar panel
A central computer surrounded by one or more satellite computers is called a
ring network
bus network
star network
parallel network
Who is called the "grand father" of the computer?
Joseph Jacquard
Blaise Pascal
Charles Babbage
Dr. Herman Hollerith
Covers a wide geographical area, such as a state or a country
Metropolitan Area Network (MAN)
Local Area Network (LAN)
Interface
Wide Area Network (WAN)
Based on a ring topology; but can use a star topology
TCP/IP
Token Ring
Ethernet
Interface
Covers a geographic area the size of a city or suburb
Wide Area Network (WAN)
Metropolitan Area Network (MAN)
Local Area Network (LAN)
WAN
Serves users within a confined geographical area
Local Area Network (LAN)
Metropolitan Area Network (MAN)
Wide Area Network (WAN)
WAD
A computer that provides services to other networked computers
Client
All of these
Server
CPU
A computer in a client/server relationship, e.g., a Web browser
Client
Ethernet
Server
All of these
Condensing output data to exhibit specific information is
Recording
Summarising
Merging
Designing
A sizeable geographical area with communication-based on the telephone system is though as
Modulator-Demodulator
Wide area network
Local area network
Advanced area
What is the standard code the computer industry created to represent characters?
ASSH
BASCII
ASCII
DASI
What is the term which represents the use of links between information of all sorts whether text, graphics, video, or audio-based?
Hypermedia
HyperCard
Hypertext
Wildcard
Which of the following is used for modulation and demodulation?
gateway
multiplexer
modem
bug
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
Arranging data in a specific order is called
Merging
Sorting
Classification
Verification
What should the user do to select the information stored in the database?
The user shall execute a request (query)
The user must sort the data
The user must select the one from the list
The user must update the information
What is a system software for creating and managing databases?
database management system
design of databases
data systems
data integrity
What data query in SQL means to add a line to the table?
INSERT
DELETE
SELECT
UPDATE
What data query in SQL means to choose lines from tables?
UPDATE
DELETE
SELECT
INSERT
A group of 8 bits taken as a single unit
Word
Byte
Bit
Megabyte
What language is used to communicate with a database?
Structured Query Language
Pascal
Data Manipulation Language
Data Definition Language
What concepts don't relate to database?
Folder
Table
File
Record
Give an example of Database Management System
Delphi
Pascal
Oracle
Cardreader
What is a collection of files storing related data?
database
data model
database management system
data integrity
Short for electronic commerce, it is the business of buying and selling products online.
E- store
E-commerce
E- government
E- house
What is an advantage of the peer-to-peer network model?
ralized administration
Scalability
Ease of setup
Centralized administration
What is the purpose of an IP address?
It identifies a return address for replying to email messages
It identifies the source and destination of data packets on a network
It identifies a location in memory from which a program runs
It identifies the physical location of a data center
Which option describes malicious code running on user devices?
Denial of Service (DoS)
Virtual Private Network (VPN)
Firewall
Virus, worm, or Trojan horse
Which attack slows down or crashes equipment and programs?
Zero-day or Zero-hour
Denial of Service (DoS)
Firewall
Virtual Private Network (VPN)
What is hardware and/or software that protects computers from intruders?
Firewall
Backup
Router
Anti‐virus
How do fiber-optic cables transmit data?
Via AC electric current
Via radio waves
Via pulsating beams of light
Via copper wire
Which of these best describes the regular telephone line that is used in most homes today?
Coaxial cable
Twisted-pair wire
Modem cable
LAN
Which of these is NOT a type of server?
Mail server
RAM server
Disk server
Print server
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?
Peer to peer
Domain
MAN
Client-server
What format of cells does not exist?
Foreign exchange
Monetary
Financial
Numerical
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)"?
8
4
1
6
The basic data structure of the relational model is ...
Report
Output
Table
Row
What type of user interface does use windows, icons, menus and pointers?
Command Line Interface
Graphical User Interface
System Interface
Menu Driven Interface
The decimal equivalent of the binary number 101011 is
41
43
39
44
To write a formula into cell, we select it and press the button ....
"*"
"="
"!"
"$"
What is the meaning of "$" in the program Excel
In the process of copying, not to change the cell address
Changing only cell's format
It is impossible to change the meaning of cell
returns currency meaning
With which documents we work in Excel?
Tables
Pages
Books
Files
Characteristics of Primary key in DBMS
required to fill in the fields
identify a row uniquely in a table
needed to create requests
The basic data structure of the relational model
Choose antiVirus programs
McAfee
MS Access
Adobe Photoshop
FindReader
Choose Operating system
McAfee
Java
Linux
HTML
What application has Command Line Interface?
Natural Language
System administration
Web browser
Off-the-shelf software
The basic data structure of the relational model is …
table
record
report
form
What is a big C/C++ program written by someone else that allows us to manage efficiently a large database
data systems
data integrity
design of databases
database management system
What type of user interface where the user has a list of items to choose from, and can make selections by highlighting one?
Natural Language Interface
Menu Driven Interface
Command Line Interface
System Interface
Find Database Management Systems
MS Power Point
Windows NT
SQL Server
Photoshop
A type of online fraud, the purpose of which is to gain access to confidential user data - logins and passwords
phishing
cookies
worm
spaming
Which are disadvantages of Cloud Computing
Internet Dependent
Disaster Recovery
No worries about running out of storage
Increased collaboration
How is called "a new class of network based computing that takes place over the Internet"?
Data center
Cloud computing
Local network
Cloud
Add octal numbers 7415+5624
16244
15220
12038
15241
Transfer a binary number 10110101111 to hexdecimal system
6FA
FA7
5AF
71510
System Bus consists of
address bus, network bus, summary bus
data bus, address bus, control bus
function bus, data bus, address bus
summary bus, control bus
Fast memory is ….
ROM
DRAME
RAM
Cache memory
Choose Database Management Systems
MS Power Point
MySQL
Windows NT
Photoshop
Transfer a binary number 110101111 to octal system
657
756
775
566
Transfer an octal number 112 to decimal system
77
75
74
76
Transfer a decimal number 173.3 to hexdecimal system
10C,4(12)
1013,412
AD,4(C)
DC,412
Multiply binary numbers: 1011*1111
10100101
11000101
11100101
10101011
What type of user interface has the following disadvantages: “Hidden” features
Graphical User Interface
Menu Driven Interface
Command Line Interface
Natural Language Interface
What type of user interface does can range from simple command systems to voice activated
text processing
Natural Language Interface
Graphical User Interface
Menu Driven Interface
Command Line Interface
What type of user interface does print a command on the keyboard and execute the command?
Graphical User Interface
Command Line Interface
Menu Driven Interface
Natural Language Interface
An element contains all the contents of an HTML document
body
html
title
head
A standard communication protocol used for the transfer of computer files from a server to a client on a computer network.
FTP
HTTP
SMTP
TCP/IP
Which one is storage?
Scanner
Hard drive
Monitor
Keyboard
A computer input device that uses a light beam to transfer text, or graphic images from paper sourse directly into a computer
Scanner
Printer
Monitor
Keyboard
When was built the first computer and how is called?
In the 1950, ANIAC
In the 1940, ENIAC
In the 1930, ANIAC
In the 1960, ENIAC
A non-volatile data storage device that used either as the primary or secondary storage device in a computer
RAM
Hard disk
ROM
DRAM
What is Utility?
is system software designed to help analyze, configure, optimize or maintain a computer.
is a programm that contains a command or a group of MS-DOS commands
is the ability of the CPU and the operating system software to use the hard disk drive
is the operating system program stored in the computer's read-only memory
What is Random Access Memory (RAM)?
a printed circuit board that is the foundation of a computer
a volatile memory and requires power to keep the data accessible
a non-volatile memory hardware device that permanently stores and retrieves information
the brain of the computer system
What is BIOS
a set of programs that provide planning efficient use of its resources and the tasks for user tasks
The ability of the CPU and the operating system software to use the hard disk drive
(basic input/output system) -the operating system program stored in the computer's read-only memory
a program that contains a command or a group of MS-DOS commands
What is a teleconference?
a continuously evolving group of methods and materials, from techniques for generating energy to non-toxic cleaning products
the communication or exchange of information between two or more individuals who are in different locations
an electronic device, connected to other devices or networks via different wireless protocols
an area of computer science that emphasizes the creation of intelligent machines that work and react like humans
What is a non-volatile type of memory that keeps data in chips even when the computer is shut off
ROM
RAM
SRAM
DRAM
What is a device, device or part designed to connect devices that do not have a direct connection method
printer
modem
adapter
monitor
What language is used to communicate with a database?
Extensible Markup Language
Structured Query Language
Data Manipulation Language
Data Definition Language
Technology takes into account the long- and short-term impact something has on the environment
Big data
Smart Managing
Green technologies
Artificial Intelligence
External Memory Characteristic
Used for long-term storage of programs and data
Nothing permanent is kept in main memory
Very closely connected to the CPU
Contents are quickly and easily changed.
Example of Timesharing Operating Systems
Unix
OC EC
RT/11
Microsoft Excel
Example of Multiuser Operating Systems
MS DOS
Windows NT
Windows XP
Microsoft Excel
Device is used to convert electric current from a source to the correct voltage, current, and frequency to power the load
Power supply
Network adapter
Monitor
Motherboard
