Font size
Worksheetsict test
Total questions: 102
Worksheet time: 51mins
Which of the following languages is used to create macros?
Java
C++
Visual Basic
c
Assembler
What is a macro?
special program written in Java programming language
An additional tool in MS Excel to perform complex calculations and data analysis
An additional tool in MS Word to perform complex formatting for large texts
A piece of computer code that can be used for repetitive tasks in Microsoft Office applications
A piece of computer code that we need to run every time we want to perform any operation in MS Excel
Which of the following applies to ICT?
Cars
Buildings
Phones
toys
Furniture
)Which of the following expressions more fully defines ICT?
ICT are information handling tools
ICT are information retrieving tools
ICT are information storing tools
ICT are information transmission tools
ICT are information processing tools
According to the taxonomy of ICT which of the following does not apply to ICT components?
Software
Hardware
Production
Content
Services
The extended version of the ASCII character set is not enough for international use
Unicode
Barcode
EBCDI
Binary code
The minimum unit of information is
bytes
bit
kilobytes
megabytes
pixel
)Which of the following cannot be used as a persistent data store?
hard disk drive
solid-state drive
random access memory
compact disc
flash drive
)What acts as the traffic cop controlling the flow of data and coordinating interactions among components in the system?
Chipset
Microprocessor
Main memory
Storage device
An examples of output devices are ______
projectors, speakers
central processor units
mouse, keyboard
touch screens, scanners
solid-state drives, hard disk drives
What does provide sockets for microprocessor and memory chips, slots for circuit boards, and the circuitry that enable electrical signals to travel from component to component?
Motherboard
Power supply
Microprocessor
Chipset
Eight-bit chunks are called ______
byte
bit
flops
kilobit
kilobyte
What is the main component that executes instructions stored in the main memory?
Microprocessor
Main memory
Storage device
Peripheral
)What was the first computer prototype used vacuum tubes?
ENIAC
Analytical Engine
Abacus
Hollerith Tabulating Machine
What does provide electrical power to the computer system?
Motherboard
Power supply
Microprocessor
Chipset
What DOS command is used to remove an existing empty directory?
rd
cd
md
ren
)Database files created in MS Access, have the extension?
accdb
type
edit
insert
Basic Input Output System - a program?
program shell
is loaded by the loader
o perform a soft processor
located in the computer's read-only memory (ROM), that is built
designed to perform maintenance service of character
Which software refers to system software?
Microsoft word
excel
c++
c
What DOS command is used to rename a file within a directory?
md
rad
rd
ren
Catalog - a special place on the disk, in which
stored file names, information about their type, size and timelast update, signs of their location on the disk andsubdirectories
What does provide sockets for microprocessor and memory chips, slots for circuit boards, and the
What was the first computer prototype used vacuum
Documents created in MS Word, have the extension?
txt
html
docx
md
Which software refers to application software?
nternet Explorer
Microsoft Windows
Unix
Mac O
What DOS command is used to change the working directory?
rd
md
ren
cd
What DOS command is used to make a new directory?
md
rd
ren
cd
Full name of the file looks like:
[drive:] [path \] file_name. [file extension]
[drive:] [path \] ffile_name
file_name
The system should always work so that users are informed of what is happening with appropriate feedback in a reasonable amount of time - this is a usability heuristic for user interface design is called?
Match between system and the real world
User control and freedom* H
Help and documentation
Help users recognize, diagnose, and recover from errors
Visibility of system status
) Speed up interaction for the advanced user, and the system can serve both inexperienced and advanced users. Allow Users to Customize Frequent Actions - this is a usability heuristic for user interface design is called?
Consistency and standards
Error prevention
Recognition rather than recall
Flexibility and efficiency of use
Aesthetic and minimalist design
The system should speak the user's language with words, phrases, and concepts that are familiar to the user, not system-specific expressions - this is a usability heuristic for user interface design is called?
Match between system and the real world
User control and freedom
User control and freedom
Help users recognize, diagnose, and recover from errors
Visibility of system status
)Users often choose system functions by default and will need a carefully selected "Emergency Exit" to exit the unwanted world without any further communication - this is a usability heuristic for user interface design is called?
Match between system and the real world
User control and freedom
Help and documentation
Help users recognize, diagnose, and recover from errors
Visibility of system status
While it is best to use a system without documentation, support and documentation may be required. Finding such information should be easy, there should be a list of specific steps to follow - this is a usability heuristic for user interface design is called?
Match between system and the real world
User control and freedom
Help and documentation
Help users recognize, diagnose, and recover from errors
Visibility of system status
Bug reports should be written in plain language, clarifying clear questions, and providing constructive responses. - this is a usability heuristic for user interface design is called?
Match between system and the real world
User control and freedom
Help and documentation
Help users recognize, diagnose, and recover from errors
Visibility of system status
Discussions should not contain unnecessary or scarce information. Each additional information in the discussion competes with the corresponding new thread and reduces visibility - this is a usability heuristic for user interface design is called?
Consistency and standards
Error prevention
Recognition rather than recall
Flexibility and efficiency of use
Aesthetic and minimalist design
Users should not be wondered if different words, situations or actions have the same meaning. Follow the platform rules - this is a usability heuristic for user interface design is called?
Consistency and standards
Error prevention
Recognition rather than recall
Flexibility and efficiency of use
Aesthetic and minimalist design
Even better than good error messages is a careful design which prevents a problem from occurring in the first place. Either eliminate error-prone conditions or check for them and present users with a confirmation option before they commit to the action - this is a usability heuristic for user interface design is called
Consistency and standards
Error prevention
Recognition rather than recall
Flexibility and efficiency of use
Aesthetic and minimalist design
Reduce user memory usage by making objects, actions, and options available. The instructions for use of the system must be visible or easily accessible if necessary - this is a usability heuristic for user interface design is called?
Consistency and standards
Error prevention
Recognition rather than recal
Flexibility and efficiency of use
Aesthetic and minimalist design
Structured Query Language
Structurd Queryu Language
Structured Query Language
Which of the following database design stages do(es) not depend on the chosen DBMS at all?
physical
logical
physical
Which of the following database design stages depend(s) on the chosen DBMS?
Conceptual,
Conceptual, logical, physical
Which of the following languages is a standard to work with relational databases?
Conceptual
logical,
SQL
Which of the following is not a DBMS function?
Data storage
SQL
Conceptual database desig
During the logical stage of database design ________ are considered
Normal forms
Views
Relations
During the conceptual stage of database design ________ are considered
Relations
Views
Normal forms
During the physical stage of database design ________ are createdNormal forms
Normal forms
Views
Relations
What networks are useful in environments where wiring is difficult to install?
Twisted pair
Coaxial
Wirefree
Wireless
WAN is
global network
local network
structured cable network
corporate network
the term is not a network
Which of the following are commonly used network topologies? I.Star II. Ring III.Modems
I and II only
III only
II and III only
I and III only
This means that each layer needs only a limited amount of knowledge to do its job
Encapsulation
Abstraction
Deduction
E-learning
An IP address is a set of four numbers between 0 and __?
128
24
16
255
512
What kind of waves provides wireless transmission for mobile communications, such as cellular telephones, and for stationary communications where it is difficult or impossible to install cabling, such as in remote, geographically rugged regions?
UTP
Line-of-sight
Infrared
Radio
IP-address is
Link computers
Cable that connects computers
the name of the program
the type of wireless communication
PC communication protocol
LAN is:
Wide Area Network
Structured cable network
The corporate network
Local animation network
local area network
Choose the end device:
router
switch
hubs
wireless access point
web server
A computer connected to the Internet, be sure to have?
IP - address
Web - server
homepage web - page
the domain name
starting web - page
)Encrypt plaintext using the Caesar algorithm. Plain text – cube. Key – 3
fxeh
gyfi
fity
dyti
fube
Choose Front-end Web Technologies example
HTML, CSS, Java Script
HTML, CSS, C++
Python, PHP, C++
HTML, PHP, C
Java Script, XML, C
Java is an example o
Database Technologies
Back-end Web Technologie
Database Technologies
Which of these is not a major type of cloud computing usage
Hardware as a service
Platform as a service
Software as a service
Infrastructure as a service
What exactly is cloud computing
Computing resources that can be accessed on demand, like electricity from a utilit
A way to organize desktop computers
Lightweight software that takes up little space on a hard drive
The World Wide Web
Which one of these is not a cloud computing pricing model
High requirements for your equipment
Pay Per Use
Subscription
Perpetual License
What is the use of a range of modern information and technologies by government to improve efficiency, service etc. i.e. Internet,mobile,local area network?
E-Governance
E-Commerce
E-Learning
E-Bussiness
What is referring to data in electronic form, which is logically associated with other data in electronic form and which is used by the signatory to sign?
Electronic signature
Cryptographic key
Telegraph signatures
Faxed signatures
How we call the process, when each user has a single view of the available resources, independently of how they are arranged in terms of physical devices?
Virtualization
Scalability
Elasticity
Lower Infrastructure Costs
Which of the following cloud deployment models allows systems and services to be accessible within an organization?
Private Cloud
Public Cloud
Community Cloud
What provides access to fundamental resources such as physical machines, virtual machines, virtual storage?
IaaS
PaaS
What provides the runtime environment for applications, development & deployment tools?
PaaS
Iaas
The web development hierarchy is
Client-side coding, Server-side coding, Database technology
Client-side coding, Server-side coding
Client-side coding, Server-side coding
Server-side coding, Database technology
Server-side coding, Database technology
Which model allows using software applications as a service to end users?
SaaS
PaaS
IaaS
C2C - a model of the interaction?
Business –to-Government
Consumer-to- Business
Business-to-Consumer
Consumer—to-Government
Consumer-to-consume
In which type of graphics an image is made up of simple geometric forms?
Vector
Raster
Fractal
In which type of graphics an image is made up of small dots (pixels)
Vector
Raster
Fractal
In which type of graphics an image is based on formulas and their coefficients?
Vector
Fractal
Raster
Tag - this is
enclosed in angle brackets entry of HTML code that controls hypertext mark up document
When the image is enlarged the quality is lost
What is used in HTML to tell a browser how to display any text?
Tags
src
HTML>
Which of the following tags is used to insert a picture into an HTML document?
src
mp3
<IMG>
Which attribute of the tag is used to provide an image file name?
src
href
Sensors
"www" is
World Wide Web
saacac
)Which attribute of the tag is used to provide the file name for the hyperlink
href
src
src
Which of the following tags is used to separate every row in a table in an HTML document?
<TR> </TR>
<P> </P>
<BR>
)Which of the following tags is used to make a line break in an HTML document?
<TR> </TR>
<BR>
<P> </P>
Which of the following generations of mobile technology is closely associated with the wide use of the Internet via mobile phones?
5G
3G
2G
4G
All visual transformations in 3D-graphics are controlled by the matrix:
Sensors
IoT
rotation, shift, scaling
All visual transformations in 3D-graphics are controlled by the matrix
When the image is enlarged the quality is lost
When the image is enlarged the quality is lost
The main disadvantage of raster graphics?
When the image is enlarged the quality is lost
rotation, shift, scaling
_________________are designed to collect information about the state of the environment
Hub
IoT
Sensors
________ - serve to control some real physical objects and devices or change the state of the environment in any way
IoT
Hub
Sensors
A network in which not users, but devices communicate with each other
IoT
Hub
Sensors
Which code executes in a web browser and determines what your customers or clients will see when they land on your website?
Database technology
Server-side scripting
Client-side scripting
Subjects of e-business
financial organizations, enterprises, individuals
goods, manufactured products, currencies, services
computer networks
B2B, B2C, C2.
Objects of e-business -
financial organizations, enterprises, individuals
goods, manufactured products, currencies, services
computer networks
The basic models of interaction between the subjects of e-business are: (choose 3 answers)
B2B B2C
C2C
G2G
B2S
What e-business model are online stores?
B2B
B2C
C2C
G2G
B2S
Which e-business model does Electronic Trading Platforms belong to?
B2B
B2C
C2C
G2G
B2S
What e-business model do online auctions belong to?
B2B
B2C
C2C
G2G
B2S
What e-business model are online stores?
B2B
B2C
B2C C2C
G2G
B2S
At the heart of the _______________________________ lies a model which describes the activities of the state and local authorities in terms of the functions performed and the processes of fulfilling these functions in e-government system
activities architecture
system architecture
technical architecture
technical architecture
performance architecture
._____________________________ reflects the main connections of services, which are offered by the state and local authorities with applied architecture components to support these services with ICT application layers in e-government system
activities architecture
system architecture
technical architecture
technical architecture
technical architecture
.___________________________________ reflects the possibilities of basic ICT as a means of interaction between applied components of the system architecture, as well as with the data sources and with users of information systems in e-government system
activities architecture
technical architecture
architecture of continuity and security
performance architecture
Audio File Formats
WAV, MP3, WMA, M4A, DSS
AVI, MPEG-4, МОВ
AVI, MPEG-4, МОВ
GIF, TIF, .PSD
Video File Format
AVI, MPEG-4, МОB
ВМР, JPG
ВМР, JPG GIF, TIF, .PSD
Choose Back-end Web Technologies example
c++
c
Python, PHP, C
Choose Database Technologies example
Oracle
c++
HTML
