Font size
WorksheetsICT 1
Total questions: 146
Worksheet time: 1hrs 13mins
Specify the main directions of ICT:
Virtual world
Cellphones
Human resource
Case-tasks
Applications
Standards in the field of ICT:
Industry Standard
International standard
National standard
Case standard
Applications
Information can be divided into types according to the form of presentation:
text
paper
book
Case-tasks
electronic
Information can be divided into types according to the way of perception:
tactile
Cloud
book
electronic
video
Information can be divided into types according to the value of:
relevant
Case-tasks
Cloud
electronic
sound
CPU used to do…
Execute complex calculations
Generate images
Storing programs and data
Record and playback sounds
Provide electricity
Computers can store and process … number system:
Hexadecimal
Decimal
Binary
Octal
None
Type of computer components that are tangible:
Basket
Office
Keyboard
Windows
Word
Part of computer component that makes logical decisions, complex calculations:
Processor
RAM
Motherboard
Hard Drive
Power Supply
Physical parts of computer system:
Hardware
Software
Binary
Windows
None
Intangible set of instructions that tell the computer what to do:
Processing
Software
Input
Hardware
Keyboard
Component of computer that uses to store programs and data:
Hard drive
RAM
Video Card
CPU
Monitor
Computer programs cannot run on its own without:
System Software
Application Software
Utility
None
CPU
Classification of system software:
Operating System, Device drivers, Utility Software
Utility Software, Application Software, System Software
Operating System, Application Software, System Software
Device drivers, Application Software, Operating System
Command line, Device drivers, Operating system
Web browsers are used to:
access the internet
artwork
create slide shows
produce posters
edit text
Output device:
Monitor
Webcam
Joystick
Modem
Mouse
Operating system for PCs:
Windows
Mac
Android
iOS
Java
Objects can be selected and manipulated on the screen by this device:
Mouse
Monitor
Printer
Speakers
Camera
Applied software is:
Basic software;
Operating system;
Service software;
Archivers;
Multimedia;
The reason for having a drive on each device is…
Well-known brands released later than the operating system were not included
For saving all files
Drivers are shipped with device manufacturers
To transfer information to the computer
To save audio
The functions available in the operating system of most devices and software modules are…
An applet;
All files;
A Control Pannel;
A hard drive;
An internet browser;
Computer hardware is defined in the following options…
The Internet;
Tower;
Oregon Trail;
Word Munchers;
RAM;
In modern computers, floppy disks are almost never used. One of the following options is used instead…
CD;
Files;
Ctrl/F8;
RAM
USB;
What operating systems are used more often?
Microsoft Windows;
Linux;
Apple OS X;
HTSP;
Android;
Known ... main functions in BIOS
3
4
6
2
5
Straight roads are…
Alternative string to this file;
Karen's combination;
Folder;s
Сreated anywhere, no copy will be made;
Icon view mode;
The system which is responsible for storing information about the programs that use part of the memory at any time
Application Program Interface;
Kernel system;
Operating system;
BIOS system;
File system;
The name of the tool for working with a huge amount of legal information received by a continuous stream is:
AP of legal reference systems
AP of global computer networks
AP of individual subject areas
AP of social computer networks
AP of regional computer networks
A fixed number of byte in sectors is…
512
256
1048
128
64
A set of commands that controls the computer operations:
Software
Motherboard
Hardware
Drivers
Multimedia
Software includes the following programming components:
Language translators
Floppy disk
Hard disk
Calculator
Peripheralequipment
The first generation of operating systems:
Vacuum tubes
Transistors
PC
Batch systems
ICs
The date of invention of Windows 1 is:
1985
1995
1992
1987
1993
An optional file identifier:
File extension
Simply file
USB flash drive
DVD
CDdisk
The interface, which hasgraphics:
windows
command
Expansion of a name of the file document.
input device
output device
The term multimedia mean:
it is the field concerned with the computer-controlled integration of text, graphics, drawings, still and moving images (Video), animation, audio, and any other media where every type of information can be represented, stored, transmitted and processed digitally.
visual images or designs on some surface, such as a wall, canvas, screen, paper, or stone to inform, illustrate, or entertain.
This is a method in which pictures are manipulated to appear as moving images.
interactive electronic gadgets that understand simple commands sent by users and help in daily activities.
All of the above
Choose a program for creating multimedia presentations
Microsoft PowerPoint
OpenOffice.org Impress
Microsoft Paint
OpenOffice.org Writer
Microsoft Word
Specify the elements of multimedia presentations:
Video/audio
Web site
Browsers
Internet
optimization
The advantages of multimedia technology is
interactivity
playing games
multitasking
optimization
all of the mentioned
A database is…
An organized body of related information
A software that allows you to use a computer to create a database
A process of finding out clients in professional and civic organizations
A software package designed to define, manipulate, retrieve and manage data in a database
A system for managing data that allows the user to store, retrieve information
A database management system is…
A software package designed to define, manipulate, retrieve and manage data in a database
A global network connecting millions of computers, making it possible to exchange information
A process of finding out about potential clients from business in professional and civic organizations
A collection of data organized in a manner that allows access, retrieval, and use of that data
Adisplay consisting of a device that takes signals from a computer and displays them on a CRT screen
Complete the sentence "Database system" refers collectively to the database model, …
Database management system, and database
Metadata
Reports and Indexes
Database application
Database utilization system
Choose the functions of database managing system.
Create
Deletes
Utilities
Data administraion
Data application
Choose the components of database managing system
Hardware
Methods
Application
Principles
Integrity
Choose the main component of DBMS, the program that controls everything.
Software
Hardware
Data
Principles
Procedures
Database Access Language is…?
Is a simple language designed to write commands to access, insert, update and delete data stored in any database.
Is a language of new technologies.
Is a simple language created to speak and communicate.
Is not a language designed to write commands to access.
Is not a language at all, the collection of data.
Network Databases organize data into a …. in which object types are nodes and relationship types are arcs.
Graph structure
Sections
Columns
Datas
System structure
The database management system can be divided into … major components.
5
3
2
6
4
Database Systems are categorized into … types based upon the underlying structure used to store data.
4
3
9
5
6
Data Management, Integrity, Transaction and Concurrency are …
DBMS functions
DBMS types
DBMS programs
DBMS structures
DBMS application
Modern DBMSs typically rely on …
Standard operating system
Rules
Instructions
Database application
Nonstandard operating system
Data mining is …
a process of performing automated extraction and generating predictive information from large data banks
a group of computers and users with a central authenticating domain-controller
a process of converting encrypted data into readable one
a facility used to house computer systems and associated components
a system for the collection, organization, storage of data
Data mining is …
a tree shaped structure which represents a predictive model
a group of computers and users with a central authenticating domain-controller
a process of converting encrypted data into readable one
a facility used to house computer systems and associated components
a system for the collection, organization, storage of data
Data Mining models
Prediction
Time series analysis
Regression, classifications
Readings
Representation
E-government:
Form of organization of activities of public authorities.
A training system using information and electronic technologies.
Exchange of services between enterprises and individuals using information technology.
Name of highly specialized tablet computer devices designed to display text.
A process of converting encrypted data into readable one
Electronic technology is …:
science based on the use of electron and ion fluxes in electric and magnetic fields for processing and transformation of material.
the science of methods and processes of collection, storage, processing, transmission, analysis and evaluation of information.
the science of human activity, aimed at the development and systematization of objective knowledge about reality.
the science of quantitative relations and spatial forms of the real world.
a science that studies phenomena that are important for the creation and development of technology.
Electronic technologies include:
Internet
Diodes
Electrons
Neurons
single information space.
E-learning ...:
training system using information and electronic technologies.
common name for remote banking technologies.
single mechanism of interaction between the state and citizens
single information space.
science based on the use of electron beams.
Internet banking services include:
Statements of accounts
Distance learning
artificial
Digitalization of sounds
Text recognition
Static methods used in data mining…
Point Estimation, Testing a hypothesis
Clustering, descriptive model
artificial
Gaussian,
Analytical,
Interactions Government-to-Citizen provides the following opportunities to the public:
Realization of opportunities and rights of citizens abroad.
Allows you to reduce time costs.
To increase the degree of business participation in public administration.
The electronic public procurement system has created transparency in bidding.
Single mechanism of interaction between the state and citizens.
e-Security is ...:
A software package to ensure the security of client interaction with the application server.
common name for remote banking technologies.
single mechanism of interaction between the state and citizens.
а training system using information and electronic technologies.
training system using information and electronic technologies.
The objectives of e-government are:
optimization of the provision of government services to the public and business;
distribution of products between citizens that can be distributed electronically;
implementation of business processes jointly managed by the company and its trading partners
common name for remote banking technologies.
doing business of citizens, in which part is carried out using information technology.
Machine Learning is …
the process of creating computer systems
search algorithm
Intersection
time series model
Analytical model
Work in e-Banking is carried out using:
personal computers.
electronic textbook.
e-government.
e-learning.
search algorithm
ewtent of the e-banking web resource simultaneously perform such basic functions as:
optimization.
authentication.
integrated.
systematized.
Analytical
Types of e-banking threats:
incorrect user authentication;
correct user authorization;
authorized user access from one network to another;
intentional change of data;
Clustering, descriptive model
Electronic-banking classes:
Internet - trading;
Internet – security;
Internet – management;
Internet – authentication;
Internet – insurance;
Types of physical topology are
bus
physical
global
logical
square
The device of networks, connection of computers of a local area network to a wide area network
Router
Bridges
Switches
Network wire
Network cable
WAN is
Wide area network
Wireless local area network
Wirenet local area network
Wireless little area network
Wirenet personal area network
According to the types of resources used in the web, servers are divided into:
print server
portalserver
Wirenet personal
university server
company server
WPAN in other words is ….
Bluethooth
Internet
School networks
International networks
World wide web
LAN are:
links computers placed in room or building with cables
links computers placed in room or building with WI-FI
links computers placed in room or building without cable
links computers placed in room or building with wireless internet
Network servers that used for as a kind of security device between client computers and the internet
Types of the server computers
Application servers that allow computers on the network to run and use application software that are stored within the server
Wireless big area network
links computers placed in room or building without cable
links computers placed in room or building with wireless internet
File servers that gives network users a place to save and load their data and files
WLAN is
Wireless local area network
Wireless land area network
Wirenet local area network
Wireless little area network
Wirenet personal area network
The network types are
cable television networks
Wirenet local area network
Wireless little area network
computer facilities
network devices
Cryptographyis ..
a science that teaches you to keep the contents of messages confidential
representing data by assigning acode
science of methods and processes for the collection, storage, processing, transmission,analysis and evaluation of information using computer technology
it is a method of converting human readable data into a form that a person cannot read
the encryption system and / or electronicsignatures
Information security is ..
state of information security ofentities
representing data by assigning acode
conscious information about the world that is the object of storage, transformation, transmission anduse.
method of coding human speech with specialcharacters
the encryption system and / or electronicsignatures
Protected communication protocol in the "Client-Server" system over the Internet:
SSL
DSS
PCT
SET
RSA
The customer confirms the identification by introducing unrecognizable information to other consumers, it is ..
authentication
identification
symmetric crypto algorithm
network encoders
SSLspecification
The main objects of information security:
Computer networks, databases
Information systems, psychological state ofusers
Business-oriented, commercial systems
Network encoders
SSL, TLS,HTTPS
Extensible scheme of an asymmetric cryptosystem working with a public key, how many keys are used in a cryptographic system
3
5
2
6
4
The identifier of information objects is...
a number, a string or analgorithm
a computer system
a computer network
basic definitions and concepts
legitimate system
Block encryption isused …
by information systems
by inverse encryptionsystems
by different versions of integration system
not available on anysystems
by subjective system
Representing data by assigning a code to it for classification or identification is known as
Coding
SSL
Encryption
SQL
TLS
Symmetric encryption is the oldest method of encryption that ...
requires both the sender and recipient to possess the secret encryption and decryptionkey
a special type of algorithm which defines the set of rules to follow to encrypt a message
overcomes the problem of symmetric encryption keys being intercepted by using a pair ofkeys
required by a recipient, the computer will request the digital certificate from the sender
Secure SocketsLayer
...... is the encryption standard used for secure web pages
HTTPS
Hard disk
Validation
GUI
Asymmetric encryption isused for ...
SecureSocketsLayer
SSL
Hypertext Transfer Protocol Secure(HTTPS)
Wi-Fi network
Universal Serial Bus (US<variant>)
Storing data in a specific format is:
Encoding
SSL
Encryption
Coding
TLS
Scrambling data so it cannot be understood without a decryption key to make it unreadable if intercepted, it is:
Encryption
SSL
Encoding
Coding
TLS
The protection measures in the Internet:
Do not open emails from unknown suspicious senders
Encoding
Visit sites of questionable, inappropriate content
Use passwords, which consist only numbers
Install unnecessary services
Client-server technology is divided into following categories:
Servers
HTML
Proxies
Applications
Computer games
Basic types of sites:
Informative sites
Computer games
Wiki
Mail sites
Open sites
The functions of Web-servers are:
The authentication of users
Client-server application
threating all web-pages
Interruption of connection with user
Destruction of dynamic page generation
An utility -
is the packaging of the computing resources, such as computation and storage, as a metered service similar to a traditional public utility
is the combination of cloud computing
is defined as the software that is programmed to be accessed over the internet by various portable computing devices.
A smart-phone has a recognizable OS
the electronic device
A _______________ is a group of linked computers, working together closely so that in many respects they form a single computer
computer cluster
cloud computing
grid computing
utility computing
utility cluster
Find the working models of the cloud computing:
deployment and service models,
private and service models
public and service
service and hybrid models
deployment and public model
A hybrid cloud –
is the mixture private and public cloud
systems and services to be accessible by group of organization
systems and services to be accessible within an organization
systems and services to be easily accessible to the general public
systems and services to be accessible without an organization
PaaSmeans:
Platform as a Service
Software as a Service
Service Model
Platform as a Software
Infrastructure as a Service
Features of the Cloud computing:
Quality of Service
Private
Stored data can be lost
Requires a constant Internet connection
Everywhere availability
All users can access to cloud services
Public
Private
community
hybrid
hybridandcommunity
Cloud services are accessible for special group of users
Private
Public
community
hybrid
public and community
The cloud computing model can be considered as combination of _____delivery models and _______ deployment models
3,4
2,4
3,5
3,5
2,3
When it comes to cloud computing trends, what is the single biggest challenge cited by IT decision-makers in operating a hybrid cloud computing environment:
Managing more systems
Security/compliance
Migration
Training
Migration/ Training
Which of the following statements could be used to describe a private cloud deployment
Both #A and #A
A private environment within a third-party or public cloud provider's architecture
A cloud service inaccessible to anyone but the cultural elite
A cloud environment maintained without an enterprise's own data center
A cloud environment maintained within an enterprise's own data center
Amazon Elastic Compute Cloud (EC2) is primarily considered which type of cloud computing model
Infrastructure as a service (IaaS)
Platform as a service (PaaS
Software as a service (SaaS)
Network operators
None of the above
Which of these options is not a PaaS offering?
IBM App Mix
AWS Elastic Beanstalk
Google App Engine
Azure App Service
MozillaFirefox
According to what's known as the shared responsibility modelin public cloud, which of the following components are cloud customers -- not providers -- responsible for?
The security of users' data
The physical security of cloud data centers
The security and maintenance of underlying hardware, such as servers
The provider is responsible for all components above.
The security and maintenance of underlying software, such as servers
The services of the Internet:
FTP (file Transfer Protocol)
MS Access
CSS
SSS
MSWord
Specify HTML Tags for the drawing table:
<table><tr><td>
<img><height>
<ahref>
body><html>
<type><html>
Specify programming languages for creating web pages:
CSS
SQL
MS Office
Paint
Adobe Premiere
A classification of types of sites
HTML
SQL
MS Office
Paint
Adobe Premiere
Define the client -server technology
Client-server is a computer model that separates client and server, and usually interlinked using a computer network
The security and maintenance of underlying hardware, such as servers
The provider is responsible for all components above.
The security and maintenance of underlying software, such as servers
The security and maintenance of underlying software, such as servers
The main services of the Internet:
WWW (World Wide Web)
AAI
CSS
MS Access
MS Word
IaaS consists of three main components:
Operating Systems and System Software
Hypertext transfer protocol
hyperlinks
File transfer protocol
Coding
Disadvantages and problems of cloud computing
Permanent network connection
Quality of Service
User-Centric Interface
All users can access
Scalability and On-Demand Services
Types of Cloud Computing Deployment Models
Public
Platform as a Service
Software as a Service
Client
Web service
Service Layers of Cloud Computing
PaaS
Public
Web page
Client
Hybrid
Key- for deleting the symbol to the left of the cursor
Backspace
Shift
CapsLock
Delete
Space bar
What program works with databases
MS Access
MS PowerPoint
MS Word V
MS Explorer
MS Excel
What programs are anti-virus
Kaspersky, Doctor Web, Aidtest
MS Word, MS Excel, MS Access
ARJ, ZIP, RAR
MS PowerPoint
Microsoft Internet Explorer, Netscape Navigator
Select the file name anketa with expansion txt
Anketa. txt
Anketa, txt
Anketa / txt
Anketa..txt
Anketa..txt
program MS Excel is
Spreadsheet
Database
Text editor
Graphics editor
Dictionary
What maximum number has a name of file or folder in Windows
255
10
8
23
256
E-mail is
Electronic mail
Work with text
Database
A game
Testing tool
How many columns in Excel 2007 spreadsheet
16385
255
289
5
65536
Tip archiver
WinRar, WinZip
WinZip, MS DOS
UNIX, MS DOS
Aidtest, Doctor, Web
Aidtest, UNIX
Translate the decimal system to hexadecimal: 555
22B
45B
20B
A4
145
What program designes to work in the Internet
Internet Explorer
Microsoft Word
Microsoft Excel
Outlook Express
Microsoft Access
What is the Windows program for viewing Web- pages
Internet Explorer
Microsoft Word
Microsoft Access
Microsoft Excel
Outlook Express
Add numbers 101 + 101
1010
1110
1111
1001
1001
Calculate 1011-111 in the binary system
100
110
98
101
210
Translate number from decimal system to octal:658
1222
157
799
1333
1204
Translate number from hexadecimal to octal system: F53
7523
1222
7965
1452
7785
Storage Device
HDD
Power Supply
Mouse
Monitor
Monitor
What does it mean = SUM (A2: A5) in MS Excel
The summation contents of cells A2, A3, A4, A5
Select cells from A2 to A5
Dividing the value of the cell A2 to A5 cell value
Summation A2 and A5 cell contents
Highlight cells A2 and A5 block
Which of these programs is a graphical editor
CorelDraw
WinZip
Microsoft Word
AVP, Kaspersky
DoctorWeb
Enter the correct form of the address Internet site
http://www.mail.ru
htp: //www.mail.ru
http: //www.mail-ru
http / www.mail .-- ru
http: //www.mail
Which of the following Boolean operations recordes correctly
1 "and" 1 = 1
0 "or" 1 = 0
0 "and" 0 = 1
0 "and" 1 = 1
1 "and" 0 = 1
How calls document in Excel spreadsheet
book
leaf
page
presentations
package
The formula means = A2 + B5
Adds contents of cells B5 and A2
Specify a range of cells B5 and A2
Subtract the contents of cells B5 and A2
Subtract the contents of cell A2 B5 cell content
Highlights cells A2 and B5
Selection E8
column E line 8
A column of row 1
line in column 8
column E row 4
line 8
the object that allows you to make a selection in MS Access
Inquiry
Table
The form
Module
Macro
Windows. How can you copy active window as a graphic element
<Alt + Print Screen>
<Ctrl + C>
<Ctrl + V>
<Shift + F12>
<Ctrl + X>
Formulu. How writes summation of cells from D2 to D7 in MS Excel
Sum (D2:D7)
Sum (D2 \ D7)
Sum (D2-D7)
Sum (D2, D3, D7)
Sum (D2, D7)
