Worksheetsİnformasiya Texnologiyaları İmtahanı
Total questions: 159
Worksheet time: 1hrs 27mins
After executing the algorithm, what value will the variable z take?
27
20
10
34
35
What is the lowest level of the OSI reference model called?
Channel level
Application level
Session level
Physical level
Network level
How many types of development directions are there for operating systems?
5
9
7
3
2
Which key or combination of keys is used to open the Start menu (Windows 10)?
Enter
Win or Ctrl+Esc
Alt+Tab
Ctrl+Alt+Del
Tab
In which year was the MS DOS family of operating systems created?
1988
1981
2001
2020
1990
Which of the following distributes power among the computer's components?
Processor
Power supply
Adapter
Monitor
System unit
Which of the following is not an input device?
Microphone
Monitor
Mouse
Scanner
Keyboard
What is the purpose of the Enter key?
Deletes the character to the right of the cursor
Is a confirmation key
Opens a data window
Repeats the last command
Cancels the last command
How much information does the Digital word in the Unicode encoding system contain?
16 bits
16 bytes
32 bits
10 bits
8 bits
How many types of number systems are there?
4
2
10
12
8
Show the base of the BINARY number system.
102
0,1
144
16
103
How many types of internal memory does a computer have?
4
2
3
5
6
Which memory does the computer use to temporarily store data?
EEPROM
RAM
ROM
EROM
EPROM
What is ROM?
Cache memory
Permanent memory
External memory
Operational memory
Virtual memory
The degree of conformity of information to the real objective situation is called what?
certainty
adequacy
completeness
relevance
possibility
Information that is not dependent on someone's personal opinion is called:
Current
Objective
Certain
Adequate
Complete
Which option correctly lists the levels of the OSI model?
Object-oriented, relational, channel, concentrator
Physical, application, transport, session
Beginning, ethernet, gateway, demonstration
Single-channel, multi-channel, network, star
Application, hierarchical, network, gateway, session
Which operating system has a command-line interface?
UNIX
MS DOS
WINDOWS
OS/2
LINUX
What are the types of operating systems based on the number of users working simultaneously?
single-tasking and multi-tasking
single-user and multi-user
command-line and object-oriented
packet email, time-sharing, real-time scalable
single-processor and multi-processor
What is the quality measure of a monitor?
Inches
Number of pixels displayed on the screen
Byte
Bod
Bit
What is RAM?
external memory
operational memory
hard memory
CD
permanent memory
In Unicode encoding, how many bytes does one character equal?
5
2
10
12
70
Which memory is temporary?
external memory
operational memory
virtual memory
cache memory
internal memory
Which memory is used for short-term storage of data going to or coming from the processor?
VGA
Cache
FDD
DVD
Hard Disk
What is the information that reflects the financial and economic situation of the organization and is processed with quality through standardized procedures called?
external information
internal information
derived information
intermediate information
initial information
The completeness of the content of the information delivered for decision-making expresses which property of the information?
representativeness
completeness
clarity
relevance
accuracy
The statement 'An algorithm should be described in such a way that everyone can use it' is determined by which property?
Discreteness
Massiveness
Effectiveness
Determinacy
Certainty
Which of the following is not a property of algorithms?
effectiveness
recurrence
discreteness
certainty
massiveness
How is an algorithm executed on a computer?
with a flowchart
with a program
with sounds
with video descriptions
with natural language
What does the term cryptography mean?
transformation
secret writing
encoding
open writing
secure writing
Which of the following is a browser?
POP3
OPERA
WINDOWS
ISP
Word
What symbol must an email address contain?
*
&
#
@
$
What type of network is the Internet?
regional network
WWW service
international network
global network
local network
The Internet...
is a corporate network
is a local network
is a regional network
is a global network
is a computer network
What forms the basis of system software?
What is the basis of system software?
Programming language
Publishing system
Driver
Operating system
Antivirus
From the perspective of informatics, the degree of relevance of information to the current moment determines which property of information?
Objectivity
Adequacy
Relevance
Possibility
Certainty
What are the types of algorithms?
Iterative loop, loop-while, loop-until
Simple conditional, complex conditional branching and parametric loop
Calculator, selection, summation
Selection, branching, parametric loop
Linear, branching and loop
Which of the following is an output device?
Keyboard, mouse
Modem, mouse
Mouse, monitor
Monitor, printer
Scanner, modem
Which of the following is true?
Algorithm is a programming language
Algorithm is a sequence of sentences and programs
Algorithm is a sequence of sentences
Algorithm is a sequence of finite commands
Algorithm is a mathematical formula
How can an algorithm be described?
With operators, problem and formula
With operators, problem and formula
In any way
With words, flowcharts, algorithmic languages
With pictures, examples, programming languages
What are the devices used for inputting or outputting data to and from a computer called?
Print device
Output devices
Input devices
Peripheral devices
External memory devices
Which of the following is not an input or output device?
Printer
Scanner
Plotter
Processor
Monitor
What parameter characterizes the processor?
Rotation speed
Physical dimensions
Processor capacity
Type of cooler and manufacturing technology
Clock frequency
What is the largest natural number that can be encoded with 16 bits?
10024
65535
256
16
255
What types (structures) of algorithms are there?
Linear, tree-like, branching, cyclic, conditional
2, 3
1, 2
2, 3, 4
1, 3, 4
What is an algorithm?
A directed graph showing the execution sequence of a set of commands
A set of commands for the computer
The protocol of the computer network
A clear and precise sequence of instructions that guides the executor to achieve the set goal
The method of performing a specific instruction
In which topology are all computers connected to a central node?
Tree-like
Mixed
Star
Ring
Bus
Which of the following does not represent a byte in binary form?
1111100
1111
1001101
0 00112000
11111111
To work with a telephone connection line in a network, the computer must be connected to:
Server
Adapter
Switch
Modem
Controller
Which operating system has a command-line interface?
WINDOWS
OS/2
UNIX
LINUX
MS DOS
How is the computer's memory divided?
Permanent and internal
Internal and cache
Operational and external
Internal and permanent
Internal and external
How much space does each character take in Unicode encoding?
12 bits
8 bits
1 byte
2 bytes
166 bits
Which of the following is not a peripheral device of the computer?
Printer
Digitizer
Speaker
Motherboard
Scanner
What is the information amount of the word UNEC accumulated in the UNICODE system?
4 BYTES
10 BITS
4 BITS
12 BYTES
8 BYTES
How many criteria are there for the classification of operating systems?
3
7
5
16
8
Which of the following is an output device?
Modem, mouse
Mouse, monitor
Keyboard, mouse
Scanner, modem
Monitor, printer
What is the main tool that manages the operation of the computer?
Text editor
Main menu
Utility
Operating system
Electronic spreadsheet
What is the domain name system called?
NSD
SDN
URL
NDS
DNS
Which of the following expresses a local network?
ROM
RAM
None
WAN
LAN
What is meant by protocol?
Information transmission scheme
Standard rules consisting of a strict formal sequence of actions
Formal standard language between computers
Standard rules for information exchange in the network
Information transmission program
What program is Internet Explorer?
Antivirus
Translation
Archiving
Browser
Service
Which of the following is a file transfer protocol?
SMTP
IP
http
FTP
TCP
What function does the DHCP protocol perform?
It is a protocol that provides IP addresses to hosts (users).
It is a protocol that ensures the sending of e-mails.
It is a protocol that ensures the receipt of e-mails.
It collects information from devices in the network from a management station at fixed or random intervals.
How many bits is IPv4?
16
24
8
32
128
What is the main disadvantage of bus topology?
There is no disadvantage to bus topology
NIC failure creates a loop in the network
The failure of a switch device disrupts the network
The failure of any computer disrupts the network
The failure of the cable, load, or connector disrupts the entire network
What is a Bridge?
Devices that ensure the connection of a computer to telephone lines.
Network devices that update electrical data from one ethernet segment and transmit it to another segment.
Devices that provide wireless access to a wired network.
Network devices used to connect two or more independent networks using the same protocol.
A device that ensures a computer connects to a network.
What modes does the fiber optic cable type have?
Single Mode
Multi Mode
Secondary Mode
Main Mode
Which of the following is a DNS address?
Yandex/az
kerim@unec.edu.az
Domain name system
google.com
Which of the following is an A class IP address?
224.17.07.92
169.254.0.17
122.16.23.29
172.19.21.11
193.255.20.222
Which of the following is a Data-link layer device?
Switch
Cat5e
Router
Modem
HUB
How many levels does the OSI model have?
4
8
6
7
5
What does the term topology refer to?
Topology refers to the architecture of the network.
The term topology refers to how computers are connected via cables.
The term topology refers to how printers are connected via cables.
The term topology refers to how computers and other devices are connected via cables.
The term topology refers to the type of cable.
Which of the following is not a network device?
Access point
Repeater
Router
Switch
MAC
Which of the following is the header for cat5e cables?
RJ-11
RJ-48
RJ-55
RJ-45
RJ-8
What is the collection of devices such as monitor, keyboard, processor, etc. that allows for processing and delivery?
Software
Procedures
Network
Technical support
Database
What is the order of data measurement units in ascending order?
Byte, Megabyte, Gigabyte, Kilobyte, Petabyte
Megabyte, Byte, Gigabyte, Terabyte
Byte, Megabyte, Gigabyte, Terabyte, Kilobyte
Byte, Kilobyte, Megabyte, Gigabyte, Terabyte
Kilobyte, Megabyte, Gigabyte, Terabyte, Petabyte, Byte
What is UNIX?
It is a graphic editor.
It is a graphic interface.
It is an archiver, driver.
It is an operating system.
It is a text editor.
What is a computer that transfers its resources to another computer during collaborative work called?
Server
Modem
Switch
Workstation
Adapter
In the client-server architecture, what is a client?
A computer that manages network resources.
A program that requests network resources.
A program that regulates network resources.
A program that plans network resources.
A computer that uses network resources.
What is a network that connects computers in a specific area called?
Local
Corporate
Global
Regional
Which of the following is not an internet service type?
FTP
World Wide Web
Token ring
Telnet
What is the function of the TCP (Transmission Control Protocol) in the internet network?
It ensures the functionality of hypertext between web pages on the internet.
It receives data sent over the internet network.
It controls the functionality of the email service.
It divides information into packets on the internet.
It ensures the transfer of files.
What is essential for creating a computer network?
None of the above is correct.
Essential and auxiliary hardware.
Network operating system and application software.
Network equipment and network software.
Supercomputers and personal computers.
Which topology does the Token Ring exchange method belong to?
Which topology does the Token Ring exchange method belong to?
ARPANET
ring
bus
star
Arcnet
What is a server?
a computer that serves files
a computer with a large hard disk capacity
a computer that serves programs
a computer connected to the network
a computer that serves users
What is meant by protocol?
a program that transmits information
a scheme for transmitting information
standard rules for information exchange in a network
a formal standard language between computers
standard rules consisting of a strict formal sequence of operations
Which of the following expresses a local network?
none
RAM
ROM
LAN
WAN
The use of email services is based on which of the following protocols?
POP3 and HTTP
SMTP3
HTTP and HTML
POP
SMTP and POP3
What is meant by a local computer network?
a computer network based on regular telephone communication
a network that connects computers located in one enterprise
a network that connects computers located 1-2 km apart
a computer network located in a limited space with access to other networks
a computer network with specific management
What is the main advantage of the 'client-server' architecture?
there are no problems related to network traffic in this architecture
the database is organized in a distributed manner in this architecture
there are no conflict problems related to network traffic in this architecture
it allows both collective and individual work
it allows easier use of network resources in this architecture
The device intended for connecting a computer to communication lines is called:
adapter
modem
processor
network card
gateway
What is a gateway in a network?
a computer server
a level of OSI
the communication language of network computers
a tool that connects different networks
a program that manages peripheral devices
What is a website?
a network of documents linked by hypertext
a separate file with the extension .htm or .html
a collection of interrelated pages belonging to a specific person or organization
the computer where the WWW server program runs
a program for browsing the web
The processing, searching, and delivery of a document to the requester is the purpose of which protocol?
IP
HTML
TCP
HTTP
WWW
What is a web page?
a graphic file with a .gif or .jpg extension
an email service
a text file with a .txt or .doc extension
a binary file with a .com or .exe extension
a text file with a .htm or .html extension
What is a browser?
an Internet Explorer program
an application software package
an OPERA program
a program for viewing web pages
a program for accessing the Internet
What is the name of Azerbaijan's top-level domain?
.gov
.com
.ru
.az
.tr
What characteristics generally define data?
aggregation, merging
logical, physical
table
calculative, logical
name, value, type, and structure
Data redundancy:
When an operation is performed on a table, other tables related to this table are also processed.
It reduces the risk of data deletion and loss.
Data cannot be changed by everyone, only authorized persons can change it.
The database management system deals with the structure and management of data, not the user.
Data redundancy is eliminated or minimized.
Select the relational algebra operations: 1) addition 2) report 3) table 4) merge, subtract
1,4
2,3,4
1,2,3
1,4,5
1,3,4
Which functions are not performed by the database administrator?
Ensuring productivity and responding to changing demands
Preparing the internal schema.
Preparing the conceptual schema
Data incompleteness
Backup and recovery procedures
What is DBMS?
a structured collection of data that is stored and retrieved when needed.
individual information that characterizes objects, processes, and events relevant to the subject area.
a complex of software tools that allows creating a database and performing various operations such as searching, sorting, updating, querying, etc. on the data of the database.
the external memory of the computer
a program for managing data
Which of the following is not a benefit of databases?
Errors are corrected and incorrect data entry is prevented.
Data sharing is ensured. The same data can be used by other users with ease.
Information standardization is ensured. If there are certain standards, they must be followed.
It is not possible to use standard query language.
You can share the data you want at any time.
Match the following: 1) data expressed in numbers 2)data expressed in words (characters) 3)data expressed in logical quantity ('false', 'true') 4)data used in programming with memory addresses.
text type
numeric type
logical type
pointer type
Select the components of the database:
table
value
query
report
What is a Database?
An information unit to be entered into the database.
A set of program tools for creating a database for storing, searching, and processing information.
Describes the concepts of the subject area, their interrelations, and the constraints imposed on the data.
A collection of files located in the external memory of the computer and linked in a certain way.
What is the Telnet service?
It is a connection between the user computer and the server.
It is a method of control in terminal mode.
None of the above is correct.
It is an Internet dialogue service.
It is a method of obtaining information from a distance.
What is a Hyperlink in web pages?
A means of obtaining information.
Passive elements of web pages.
A mode for filling out forms.
Text or images that provide access to new web pages.
Active elements of web pages.
Which of the following is a formula written in MS Excel?
=A3*C5
4A+5
G15/J25
A2+D12
A2*2-B3
How many worksheets are there in Excel 2010 by default?
1
256
255
3
2
Which of the following tabs is not a main tab in Word 2010?
Mailings
Page Layout
Home
Design
View
What is the operation that updates or modifies the data structure?
Merging
Searching
Updation
Selection
Sorting
Which of the following is not a drawback of the waterfall model in software development life cycle?
Low agility in project management.
Complexity in clearly formulating requirements.
Stability of requirements throughout the development cycle.
Inability to flexibly model unique systems.
Unusable intermediate product.
Which of the following is not a phase of the waterfall model in software development life cycle?
Requirements analysis
Integration
Testing and tuning
Coding (programming)
Design
Which of the following is not related to the relational model?
Tuple
Relation
Domain
Designation tree
Attribute
Which of the following are not database models?
Relational
Network
Hierarchical
Logical
Object-oriented
What are the database management systems?
Microsoft Word, Word Perfect, Ami Pro
Paint, Adobe Photoshop, Corel Draw
Aldus Page Maker, Corel Ventura, QuarkXpress
Microsoft Access, FoxBase, FoxPro
Microsoft Excel, Quattro Pro, Lotus 1-2-3
What are tables in a database for?
To automatically execute a group of commands.
To prevent repetitions in the database.
To select the data in the database.
To store the data in the database.
For entering data into the database, defining user interface, and viewing data.
What is meant by the redundancy of data?
What is meant by the redundancy of data?
Integrity of the database is not violated
Dependencies between attributes of the relation
Updating poorly designed databases
Data duplication in the database
Data not being duplicated in the database
What does a tuple represent in the relational model?
Information object
Column header
Table column
Table row
Name of the relation
Which of the following is not a database model?
Network
Object-oriented
Relational
Grounded
Hierarchical
Which of the following is not related to the data that should be stored in a database of a group?
Library - Book Information, Information about Staff
University - Student Affairs Information System (Student's Personal Information and Course, Grade Information)
Bank - Customer, Deposit, Credit Card, Credit Information
Hospital - Student's Personal Information, exam results, Sales, Payment
Company - Customer, Product, Sales, Payment, Delivery Information
Which of the following is not a benefit of databases?
Does not waste memory space
Allows the use of standard query language
Prevents violation of data integrity
Does not allow data exchange, sharing the database with other users
Eliminates or minimizes data duplication
What are the column headers of a table called in a relational database?
Key
Entry
Attribute
Content
Field
What type should the 'total scores' field be in the database that stores information about students in a school?
Any
Character
Logical
Numeric
Time type
What types of information are there according to the level of the management system?
Information about the external environment, information of the controlling subsystem, information of the controlled subsystem, information about the targeted subsystem
Initial information, derivative information, intermediate information
Internal and external information
Scientific, methodological, commercial, statistical, educational information
Information of specific individuals, information of enterprises and organizations, information of ministries and institutions, information at the state level
What is knowledge?
Information about persons, objects, facts, events, and processes regardless of the form of description
Information that must be stored, transmitted, and transformed about the environment
Description of facts and ideas structured in a way that is convenient for transmission and processing in any information process
Systematized information that allows decision-making
New information that carries uncertainty
What types of information are there according to the query?
Text, graphic, audio
Relevant, appropriate
Verbal, non-verbal
Daily, weekly, quarterly, monthly, quarterly
Scientific, methodological, commercial, statistical, educational
What types of information are there in machine processing according to their purpose?
Scientific, methodological, commercial, statistical, educational
Conditional-fixed, variable
Internal, external
Input, output
Text, graphic, audio
What property indicates that information is independent of anyone's opinion and judgment?
Completeness
Clarity
Relevance
Content
Objectivity
Which of the following is not a function of MS Word (for working with tables)?
Add a new row or column to the table
Change the size of the table
Delete a row or column of the table
Automatically fill the table
Create a table
What is the 'Digital/Digital' change in the text?
Writing to memory
Making a copy
Formatting
Cutting and moving elsewhere
Editing
What sequence of commands is followed to replace a word with another word in the text in Word?
Home/Font/Replace
Insert/Replace
View/Replace
Home/Editing/Replace
Page Layout/Editing
Which command is used to save text under a different name in the Word 2010 text processor?
Cut
Save as
Save
Open
Close
What command is used to save text under a different name in Word 2010?
Cut
Save as
Save
Open
Close
What are objects in vector graphics made of?
Figures
Squares
Pixels
Dots
Lines
Which line shows vector editors?
Photoshop, Corel Photo-Paint, Corel Painter
Macromedia Freehand, PhotoDraw, Imaging
Paint, CorelDraw, Adobe Illustrator
Adobe Illustrator, CorelDraw, Macromedia Freehand
Paint, Photoshop, Adobe Illustrator
What is a database management system (DBMS)?
A person with technical knowledge
A user of a program created by a programmer
A set of tools for creating a database for storing, searching, and processing information
An application programmer who ensures data entry, modification, and deletion
Those who write the programs used by users
What is the menu that appears by right-clicking on an object?
System menu
Submenu
Main menu
Primary menu
Context menu
What are the operating modes of operating systems?
Batch processing, direct access, batch multiprogramming, and time-sharing
Multiprogramming, sequential access, direct access
Real-time, sequential access, direct access
Interpretation, translation, compilation
Batch processing, multiprogramming, time-sharing, and real-time
Which of the following is related to file structure operations?
Creating a folder
Renaming files and folders
Changing the location of files and folders
All of the above
Moving files and folders
What symbol is written at the beginning of a path calculated from the main directory?
"
..
/
\
;
What is the program interface?
Interaction between the microprocessor and memory
Interaction between peripheral devices
Interaction between software and hardware
Program connection for the user
Interaction of the operating system program
Which formula contains an error?
No error
H5*1.509 / S 4
C8*2
5A1+1
4/(1-F3*2+F5/2)
How does Excel interpret the entry in cell A1+B1?
As an error
As a number
As text
As a formula
As a letter
If the formula =B1*C2 is entered in cell D3, what will be the content of D7?
B4*C6
B4*C5
D5*D6
B6*C7
B5*C6
Which of the following cannot be deleted in an electronic spreadsheet?
Content of the cell
Worksheet
Column
Row
Address of the cell
Which key is used to move the cursor to the last row in Excel?
Ctrl+ ↓
Shift+ End
Shift+ ↓
Ctrl+End
Ctrl+ →
What is a relative address in Excel?
Active address
Address consisting of numbers
Unique address
An address that can change during calculations
An address that contains fixed data
What should be written in the formula bar to find the largest number in cells B1, B2, B3, B4, B10?
=Max(B1,B4,B10)
=Max(B1;B4:B10)
=Max(B1:B4,B10)
=Max(B1:B4;B10)
=Max(B1;B4;B10)
If the formula =$C2+D3 is entered in cell E4, what will be the formula in cell G4 when it is moved?
=$C3+E3
=C3+$F3
=$C2+F3
=$C2+E3
=$C2+D3
Which software product is related to vector graphics?
Adobe PhotoShop
Paint
Microsoft Photo Editor
Corel Draw
GIMP
What is the main function of a graphic editor?
Working with tables and performing operations on data
Performing calculations and printing
Preparing texts and documents
Creating and editing images in various formats
Entering diagrams and printing
What is necessary for converting data into information?
Having a computer
Having an algorithm
Having a program
Creating a structure for the data
Having a coding system
What does the relevance of information indicate?
Not depending on any offer
Suitability of form and capacity
None of the above is correct
Possibility of use by the user
Being important at the present time
What are the tools of graphic editors?
Line, circle, rectangle
None
Color palette
Pencil, brush, eraser
Selection, copying, placement
