WorksheetsСессия Икт
Total questions: 105
Worksheet time: 53mins
A publicly-accessible personal journal posted on the Web. It is often reflect the personality of the author and is typically updated daily:
Blu-ray
BLOB (binary large object)
Blog
Big data
BI (Business Intelligence)
A type of user interface that features on-screen objects, such as menus and icons, manipulated by a mouse
Menu Driven Interface (MDI)
Natural Language Interface (NLI
Command Line Interface (CLI)
Graphical User Interface (GUI)
Basic Input Output System (BIOS)
The term which means the interaction between people and computers:
User interface
UML (Unified Modeling Language)
User software
USB (universal serial bus)
User privileges
A set of application programs or operating system functions that can be utilized by this program
ASI (Address space interface)
ARI (Absolute reference interface)
ATI (Acceptance testing interface)
AUI (Adaptive utilities interface)
API (application program[ming] interface)
> A style of user interface that requires users to type commands, rather than use a mouse to manipulate on-screen controls
Graphic user interface
Application programming interface
Command-line interface
Natural language interface
Menu driven interface
A term meaning the main screen of the graphical user interface that can hold objects such as folders and widgets:
Desktop
My Documents
Basket
My Computer
Templates
A term is used in the context of multimedia that refers to music, movies, television shows, and books
Programming content
Text content
BIOS content
Media content
ASKII content
Techniques is used to reduce the size of files that contain audio data
Audio compression
MP3 player
Media Player
GeForce
PCI Express
Programs that are used to create vector graphics with lines, shapes, and colors:
Device Drivers
Drawing software
Operating system
Antivirus software
Translator software
A bitmap graphics file formats are popularized by CompuServe, for use on the Web
JPG, BMP
JPG, TIFF
PSD, ACD
GIF, PNG
BMP, CDR
The use some colours and special model that can be combined to create the full spectrum of colours
Subtractive model
CMYK color model
HSB color model
RGB colour model
Multiple model
The following programs is used for work with vector graphic:
Adobe PhotoShop
Photo Editor
Adobe Fireworks
Photo Instrument
CorelDraw
The software is used to create three dimensional wireframe objects, then render them into images.
3DMax, Maya
3Dmax, Petya
CorelDraw, 3DMax
Paint, IMovie
Publisher
The diagonal distance between colored dots on a display screen. Measured in millimeters, dot pitch helps to determine the quality of an image displayed on a monitor.
Monitor pitch (mp)
Dote quality (dq)
Diagonal dot (dd)
Dot per inch (dpi)
Dot millimeters (dm)
Software that is used to summarize system requirements, diagram current and proposed information systems, schedule development tasks, prepare documentation, and develop computer programs.
CASE tool (computer-aided software engineering)
Data bus
Chief information officer (CIO)
BSD license (Berkeley Software Distribution license)
Data center
The characteristics of data that can be entered into a field in a data file, include- character, numeric, date, logical, and memo:
Data independence
Data representation
Data transfer rate
Data type
Data dependence
A person who supervises database design, development, testing, and maintenance
Database administrator, Database designer
Database assistant, Database hacker
Database hacker
Database controller, Database tester
Database tester
A relationship in which one record in a particular table can be related to one or more than one record in another tables
One to MEMO
Many to table
One to many
Many to many
Many to one
There are filed types to store character in ACCESS
Numeric,
Currency, Counter
Hyperlink, Date/Time
Text, MEMO
OLE
There are objects in ACCESS which relates with Visual Basic programming language
Macros, Module
Text, Counter
MEMO
Numeric, Hyperlink
OLE, Currency
In database fields it is normally used to relate several tables based on entity
Gold key
> Primary key
MEMO
Macros
OLE
In DBMS, Primary key field has some obligations to create some relation between tables.
1) data have to be unique
2) data have to be a text
3) to be same with foreign key field
4) no empty records
5) to be different from foreign key field
3,4,5
1,2,5
2,3,5
1,3,4
2,4,5
Query language that can be used to direct the computer to create databases, locate information, sort records, and change the data in those records.
Visual basic
Python
SQL Dark
MySQL
SQL Paradox
ACCESS data base management objects: 1) Macros, 2) Foreign key, 3) Module, 4) DataTime, 5) Report
1,3,5
1,2,3
2,3,4
3,4,5
1,4,5
There are database management models
1) Hierarchical
2) Relational
3) Programmable
4) Object oriented
5) Comparative
2,3,4
1,2,5
1,2,4
3,4,5
2,4,5
In Database system this logical operands is used to get specific information:
ElSE IF
XOR, EQV, NOT
> Then Else
AND, OR, NOT
> Mixed, OR, EQV
An SQL keyword that queries for a particular record or group of records from a table. Select operator has own order in request
SELECT AND FROM
<variant> SELECT FROM WHERE
SELECT FROM WHERE
SELECT WHERE FROM
INSERT INTO
CREATE DATABASE
SMART technology develops very fast on some fields.
Internet of things, Big data, Technology Block Chain.
DrWeb, Decision support systems
Decision query, GeForce
Operating system, Linux
Invest manager, Help Desc
Big data technology has some advantage than relational data base systems
Operates with structured data, Operates with unstructured data
Operates just with structured data, Operates just with unstructured data
> Operates just with unstructured data
works with media files
Operates with binary digits
Data mining technology has some methods. 1) Regression trees, factor analysis, 2) Analysis of variance, 3) Middle term equation, 4) Atanasov profit model, 5) Business to business approach
2,5
> 2,3
3,4
1,2
1,4
Short for electronic commerce, it is the business of buying and selling products online.
E- government
E-commerce
E-connection
E- house
E- store
Major B2B «Business-to-business» tools include
Development of microprocessor
Templates online, Money Loan
Development of operating system
Crypto currency marketing
The corporate web-site, internet incubator, Internet marketing
Major B2C «Business-to-customer» tools include
Shop Online, Online trading system (OTS)
Major B2C «Business-to-customer» tools include
Development of operating system
Money Loan, Development of microprocessor
Crypto currency
Major C2C «Customer-to-Customer» tools include
> Internet market trading, Internet auction Trading showcase
Development of microprocessor
Money Loan, Internet auction Trading showcase
Crypto currency
Templates online, Internet market trading
E-learning- learning through the Internet and experts:E-learning- learning through the Internet and experts:
The opportunity at any time and in any place to get modern knowledge
> receiving and sending assignments by email
Online job that allows earning money at any time
Study that requires to be in education place
Online business that allows finding customers at any time
E-government - improving governance and reducing social communications costs for each member of society.
Set of management processes across the district
State electronic books management system
Set of management processes across the city
State electronic document management system
State electronic house management system
Electronic government is the integrated mechanism of interaction between some object and users.
Sport club
State
Entertainment
Clothes
Animals
There are some most common e-commerce business models.
> CJ4C (consumer-just for-consumer)
B3C (business-and three consumer)
BOC (business-or consumer)
B2C (business-to consumer)
B2U (business to user)
There are some most common e-commerce business models.
1) BOC (business-or consumer)
2) B2G (business-to-government)
3) B3C (business-and three consumer)
4) CJ4C (consumer-just for-consumer)
5) C2C (consumer-to-consumer)
6) B2B (business-to-business)
3,4,5
1,2,3
2,4,6
3,5,6
1,4,6
An online course of study made available over the Internet without charge to a very large number of people.
> MOOC
ReHat
Ubuntu
Unity
> Knoppix
Types of Quiz Questions to Use in Your E-Courses
Classic Choice, Unity quiz
Multiple Choice, Yes or No
Ubuntu quiz, Edx quiz
Fill in the Blank, Coursera
Knoppix, Yes or No
A collection of computers and related devices connected in a way that allows them to share data, hardware, and software:
NVidia network
System board network
Computer network
Touch Screen network
Students network
A set of rules that ensures the orderly and accurate transmission and reception of data
Accurate transmission
System board network
Rule ensure
Communications protocol
Transmission of information
> A large database of unique IP addresses that correspond with domain names.
Domain Name System (DNS)
Name Domain System (NDS)
System Domain Names (SDN)
Disk Operating System (DOS)
Domain name server (DNS)
A computer that hosts the Domain Name System database
Domain Name System (DNS)
Name Domain System (NDS)
System Domain Names (SDN)
Domain name server (DNS)
Disk Operating System (DOS)
A popular network technology in which network nodes are connected by coaxial cable or twisted-pair wire.
Ethernet
Ring
Token Ring
Domain
Star-ring
A computer that stores and distributes files to remote client computers
IP server
FTP server
PCI server
FDDI server
ATM server
Software that is designed to manage a large number of records and perform many simultaneous transactions
IP server software
Database server software
PCI server software
> Information server software
Computer server software
A set of rules that allows network client computers to find and use the Internet address that corresponds to a domain name
Dynamic Host Communications protocol
<variant> Dynamic Host Configuration Protocol
Database server software
Domain Name System
Static Host Transmission protocol
Software or hardware is designed to analyze and control incoming and outgoing packets on a network; is used to enhance security by filtering out potential intrusion attempts
DNS
TCP/IP
Telnet
> Firewall
FireWire
Unique identifying numbers assigned to each computer connected to the Internet.
RAM address
DNS address
> FTP address
IP address
FDDI address
A communications protocol used to send e-mail across a network or the Internet
Simple mail transfer protocol (SMTP)
Local mail service protocol (LMSP)
Global mail service protocol (GMSP)
DNS mail address protocol (DMAP)
Regional mail service protocol (RMSP)
Any program or set of program instructions, such as a virus, worm, or Trojan horse, designed to surreptitiously enter a computer and disrupt its normal operations
Application software
System software
Malicious software
Operating system
Firmware system
An encryption key that is used for both encryption and decryption of messages
Complex key encryption
Assymmetric key encryption
Simple key encryption
Symmetric key encryption
Extra key encryption
Main approaches to enter preting the role of ICT:
as a production sector
as a computer facilities
as set of operating systems
as a development tool (ICTD)
as a computer graphics technology
ICT is defined as the study of:
Modeling processes
The technology required for information
Computer interaction
Programming languages
Principles of computer working
All information is erased when you turn off the computer:
in CPU
in ROM
> in RAM
on a floppy disk
on the hard disk
The first program which run on a computer when the computer boots up:
> System software
System operations
Operating system
Database system
Bespoke program
Multiprogramming systems allow to user:
execute only one job
execute each job faster
are easier to develop than single programming systems
are used only one large mainframe computers
execute more jobs in the same time period
Choose from the list below which is not an interface style:
Command line
Windows
Menus
Pointer
> Voice recognition
Multimedia applications that allow users to directly respond to and control all of the media elements:
Image edition programs
Hypermedia
Paint programs
Converter programs
> Interactive multimedia
The smallest component of an image that can be transmitted or received in a video
display system:
Pixel
MP3
MPEG
> Plug in
Graphic file format
A structured collection of data:
System operations
Database system
> Operating system
System software
Bespoke program
Find the correct query to select only the cities with temperatures less than 35:
SELECT * From cities Where temperature<35
SELECT * From cities Where temperature=35 Database system
SELECT * From cities Where temperature!=35
SELECT * From cities
SELECT * From cities Where temperature>35
Technologies that allow sensors, databases and wireless access to collaboratively sense, adapt, and provide for users within the environment:
Internet of thing
> Cloud technology
Smart technology
Plug and Play technology
Internet technology
The URL of the web page is set: http://www.sgzt.com/sgzt/archive/content/2005/03/043. Find the name of the protocol to access this information resource:
FTP
sgzt/archive/content/2005/03/043
> HTTP
IP
TCCP
Encoding algorithm where the decryption key is kept secret:
El-GamalEl-Gamal
RSA
DNS
Asymmetrical
Massey-Omura
The progtam that runs on computer hardware and serveas a platform for others of twaretorunon:
Operating system
Application software
System programs
User interface
MS Office programs
Picture file format which can display more colors:
> TIFF
MP3
GIF
JPEG
MP4
Tools include statistical analysis, pattern-matching techniques, and data segmentation analysis, classification analysis, association rules, and cluster analysis:
Big data
Data mining
Knowledge discovering
Data analysing
Software analysing
SQL clause which is used to restrict the rows returned by a query:
where
> and
or
> not
from
The first end-user Internet of thing(IoT) objects:
Tablets
Smartphones
ATMs
Smart TVs
Office programs
The only operation unavailable on the internet in e-banking:
getting cash
to have full information about their accounts
> to transfer money
to pay bills
to contact with customer service department
The Internet provider is:
the organization provider of Internet services
an organization engaged in the creation of web-sites
a peripheral device that is used to communicate with another computer
set of rules which helps to get information from another address
The first global computer network had a name:
Intranet
BITNet
NSFnet
Arpanet
Mailnet
Use of cryptographic algorithms allows preventing the information leakage by:
digital signature
data integrity support
data confidentiality support
authentication support
cryptography requirements
The phrases 'x86' and '32-bit' are referring to _____ of a computer's architecture:
The name
The fundamental characteristic
The processor
The address lines
Core memory
The microprocessor is known as part of the computer:
Kidney
Heart
Brain
Liver
PCI
The Apply Design Template (Microsoft Power Point) command is used to:
Change the background and fonts of the entire presentation
Change the order of the slides
Change the shape of the slides
Change the shape of the slides
Change the style of presentation
This popular online payment service is owned by eBay:
P2P
Multics
PayPal
> Majordomo
Cache
Protocol which assigns IP address to client connect edin internetis:
IP
DHCP
RPC
HTTP
TCP
Find a cloud platform by Amazon:
> Microsoft commercial cloud
Azure
Cloudera
AWS
IBM
Choose from the following which can be identified as cloud:
Internet
Web applications
Intranet
Hadoop
Softwares
The number of cycles per second, corresponding to a microprocessor speed of 3.33 GHz is measured in
million
thousand
billion
> trillion
ten million
Select correct order of boot process: (1) Power up (2) Check configuration and customization (3) Load operating system (4) Identify peripheral devices (5) Start boot program (6) Power-on self-test
1, 5, 6, 4, 3, 2
1, 5, 6, 2, 3, 4
2, 3, 5, 1, 4, 6
6, 5, 4, 3, 2, 1
1, 2, 3, 6, 5, 4
> Software types helps you carry out tasks such as creating documents, editing graphics, and locating nearby restaurants.
> Business software
Application software
Utility software
Graphics software
Video software
A set of specifications for creating documents that a browser can display as a Web page. They are called a markup language because authors mark up documents by inserting special instructions, called tags:
Web page
Web site
URL
HTML
Web browser
Correctly written formula
A1*B2+192
=Sum(A3/B6)*$A$1
> Sum(A3:B6)*A1=
=A1*B2+192
> D1= A1*B2+192
A decimal number 224 equal 1) 19210; 2) 3008; 3) C016; 4) 111000002; 5) 3408; 6) E016
2,4,5
1,2,4
2,3,6
> 3,4,5
> 4,5,6
Select data that is correctly represented in binary system:
10010011
12345678
> AF
11111121
00000001
A learning system through computer and electronic technologies:
> E- government
E-business
E-learning
Smart technology
Data Disaggregation
The number layers of OSI model:
7
4
5
6
8
The use of electronic communications devices, computers and the Internet to provide public services to citizens:
Blockchain
> Rule
E-learning
E- government
E-business
The following main programming languages are the most popular among modern software developers:
Photoshop
Basic, Python
3D max, Macromedia Flash
> Java, C ++
> CorelDraw
Implementation of trade and delivery activities through the Internet:
e-trade
> e-cash
> e-learning
e-banking
The native bitmap graphic file format of the Microsoft Windows OS.
PNG
TIFF
JPG
BMP
GIF
Types of topology of the network: 1) Moon; 2) Star; 3) Bus; 4) Car 5) Hub; 6) Ring
3,5,6
1,2,3
2,3,6
2,3,5
4,5,6
The operating system is used for iPhones, iPods, and iPads and mobile devices
1) IOS; 2) Windows; 3) MS-DOS; 4) Mac OS; 5) Android; 6) Windows 10
1,5
1,6
2,3
3,4
5,6
The main printed circuit board found in general purpose microcomputers and other expandable systems:
> FTP server
Router
Motherboard
<variant> Driver
Gateway
Hexa decimal number “4A3F” in decimal number is:
19000
45672
> 25667
> 19007
20019
This operating system commands which lists directory contents:
Help
> COPY
RD
DIR
MKDIR
The most popular spreadsheets include products such as:
Microsoft Excel; Lotus Notes; Quattro Pro
Adobe PhotoShop
Corel DRAW
Adobe Reader; Google Chrome
Microsoft Word; Paint
Graphic file formats are:
.bmp, .jpg, .gif, .tif, .psd
.dvd, .cd, .xls
> .txt, .doc, .htm, .xls
.gif, .jpg, .wav, .exe
>.com, .drv, .bat
The query language in the SQL consists of a single operator:
EXIST
UPDATE
WHERE
GROUP BY
SELECT
Choose MS Excel function of calculating the average value:
SUM
ABS
EXP
AVERAGE
> SYM
