Авторизация:
E-Mail: Пароль:
Закрыть
RU | EN

Информатика

Опубликовано: 2018-06-13 18:01:05
Этот текст доступен по адресу: http://ontext.info/101335
Network specialist/administrator -
plans, installs, and maintains one or more local area networks.
What are examples .sys, .doc, and .jpg of ?
File extensions
In Microsoft Excel worksheet is formed from:
Cells
SQL. INSERT -
add a record
TCP (Transmission Control Protocol)-
Creates connections and exchanges packets of data
Information and communication technologies (ICT)
in the discipline are regarded as modern methods and means of communication of people in a normal and professional activities with the help of information technologies for the search, collection, storage, processing and dissemination of information.
File specification books are created primarily for the use of
programmers
The primary advantage of key-to-tape data-entry systems is:
The tape is reusable
Each model of a computer has a unique
Which is considered a direct entry input device?
All of the above
What is the Linux?
It is the version of Unix Operating System
Printer is:
output device
What are the major components of a CPU?
Control Unit. Register Set. Arithmetic Logic Unit
The bulk of the binary information in a digital computer is stored in memory, but all computations are done in
Processor Registers
The processor, ---------- and I/O Devices are interconnected by means of a common bus.
Cache Memory.
A small picture that represents a folder, program or other things
icon
Part of a computer that allows a user to put information into the computer
Input Device
This part stores programs and other information on 2 or more disks that are located inside the computer
Another name for computer programs
Software.RAM
A program that controls a computer's basic functions
Operating System
What is the name of well known example of a macro virus from 1999?
Melissa Virus
What is a computer?
A computer is an electronic machine that makes mathematical calculations and logical comparisons quickly and without any mistakes.
In order to replicate itself, viruses must be permitted to execute code and write to memory. What they do for this reason?
viruses attach themselves to executable files that may be part of legitimate programs.
What is the smallest unit of information that a computer can understand?
Bit
Which parts do computers consist?
Hardware, software
How many main periods in the history of computers exist?
5
Information systems can be described as:
Organizational And Management Solutions to problems posed by the environment,
A computer-based information system relies on computer hardware and software for:
Processing And Disseminating information.
How does temporary storage (computer’s memory) call?
RAM
What is the name of first electronic computer?
ENIAC
____________ is a(n) organized collection of information in computerized format.
Database
What represents a 1 or 0 digit in a binary numeral, or a true or false logical condition?
Bit
How many bytes is one megabyte?
1024
What is an operating system?
Systems software that coordinates the hardware and software components of a computer system,
What does PC mean?
Personal computer
What is a central computer that contains collections of data and programs?
server
What is a computer network?
Two or more computers connected together to exchange data and programs,
Which unit network engineers describe network speeds?
bits per second
How many bits is one byte?
8
How many bytes is sixteen bite?
2
How many bits is seven byte?
56
What is a bit?
A single on/off value.;
How errors in computer programs are called?
Bugs
What is a method of storing and organizing computer files and the data they contain to make it easy to find and access them?
file system
Which one of the following statements is FALSE?
a bit is always implemented as something electrical;
What is a name assigned to a file in order to secure storage location in the computer memory?
a file name
Which numbers are the core of all computer operations?
Binary
What is a group of 8 bits usually called?
A byte
Which number does binary only use?
Numbers between 0 and 1
What is the name of this process? The number is divided by two, and the remainder is the least-significant bit. The (integer) result is again divided by two, its remainder is the next most significant bit. This process repeats until the result of further division becomes zero.
Conversion to binary system and from decimal system
How much memory is in one megabyte?
About one million bytes
Binary may be converted to and from hexadecimal somewhat more easily. How many digits of binary it takes to represent one digit of hexadecimal?
Four
Binary may be converted to and from hexadecimal somewhat more easily. How many digits of binary it takes to represent one digit of octal?
Three
Which one is the binary representation of decimal number (27)?
(11011)
Which one is the binary representation of decimal number (66)?
(1000010)
Which one is the binary representation of decimal number (70)?
(1000110)
Which one is the octal representation of decimal number (54)?
(66)
Which one is the octal representation of decimal number (73)?
(111)
What is a file?
A file is a collection of information that has been given a name and is stored in secondary memory
Which one is the hexadecimal representation of decimal number (159)?
9F
Which one is the binary representation of octal number (67)?
(1000011)
_______________ erases all the data on a disk and arranges the magnetic particles on the disk surface so the disk can store the data.
Formatting
Which one is the binary representation of hexadecimal number (C1)?
(11000001)
Which one is the octal representation of binary number (111111)?
(77)
A(n) _____ is a collection of data that has a name and is stored on a disk or other storage medium.
File
Which one is the hexadecimal representation of binary number (11111111)?
(FF)
The physical parts of a computer called:
Hardware
In the filename student.exe, .exe is a(n) ____________________?
extension
Which device is used to point to things and select things on the screen?
Mouse
What is Chassis?
The metal and plastic box that contains the system unit.
If you delete the icon for a file, what happens to the file?
It is deleted logically from the disk but may sometimes be restored
The second name of diskettes?
Floppy Disk
Which device connects your computer to the telephone system?
Modem
The main directory of a disk is referred to as the ________________ directory.
Root
In Microsoft Excel what is the fastest way of getting to cell A1 in a spreadsheet?
Ctrl Home
In Microsoft Excel to select all cells in a worksheet you press:
Ctrl A
In Microsoft Excel what is the fastest way of getting to cell A1 in a spreadsheet?
Ctrl Home
In Microsoft Excel to select all cells in a worksheet you press:
Ctrl A
When was created Rambler search engine?
In 1991
Who is founder of Bing search engine?
Steve Ballmer
When was created Bing search engine?
May 28, 2009
Why Use-Case modeling is useful?
it is a common language between people in the project team and also other stakeholders.
You can add a row using SQL in a database with which of the following?
INSERT
Which of the following do you need to consider when you make a table in SQL?
All of the above.
By means of television, tape recorder, video tapes, electronic mail, mass media and Internet skills to independently search, analyze and select required information, organize, transform, save and transfer it are formed in student.
Informational competencies
When was MS DOS operating system invented?
1981
First generation of computer systems.
1940-1956
Eckert and Mauchly build the UNIVAC, which could calculate at the rate of ____ addition per seconds.
10,000
Fourth generation of computer systems.
1971- present
In 1971 Intel created _______
First microprocessor
List of input devices
Keyboard, touch screen, scanner
What detail has been used in ENIAC (Electronic Numerical Integrator and Computer) instead of mechanical switches
Vacuum tube
What is a different between first and second generation of computer systems?
The creation of transistor spark
Signal of the beginning of the third generation computers is
integrated circuit
Functional units of a computer
I/O, memory, processor
List of output devices
Printer, monitor, sounds
_________ reads instructions and reads/writes data from/to the memory during the execution of a program
Processor
Operations are executed in the
Arithmetic and Logic Unit
What is a Linux?
Operating system
Roles of Linus
Desktop, server, firewall
______ is the system by which people (users) interact with the computer.
User interface
Graphical User interfaces rely much more heavily on the
Mouse
Text-based user interface relies primarily on the
Keyboard
What are main SQL queries?
CREATE. SELECT. INSERT. UPDATE. DELETE
Which SQL statement is used to extract data from a database?
select
Which SQL statement is used to update data in a database?
Update
How many relations may exist between tables in databases?
3
What is the maximum length a text field can be?
255
Which of the following query would display all the students whose first name starts with the character ‘A’?
select first_name from students where first_name like ‘A%’
What is a computer?
A computer is an electronic machine that makes mathematical calculations and logical comparisons quickly and without any mistakes
In order to replicate itself, viruses must be permitted to execute code and write to memory. What they do for this reason?
viruses attach themselves to executable files that may be part of legitimate programs.
What is the smallest unit of information that a computer can understand?
bit
Which parts do computers consist?
Hardware, software
How many main periods in the history of computers exist?
5
Information systems can be described as:
organizational and management solutions to problems posed by the environment,
A computer-based information system relies on computer hardware and software for:
processing and disseminating information.
How does temporary storage (computer’s memory) call?
RAM
What is the name of first electronic computer?
ENIAC
____________ is a(n) organized collection of information in computerized format.
Database
What represents a 1 or 0 digit in a binary numeral, or a true or false logical condition?
bit
How many bytes is one kilobyte?
1024
What is an operating system?
Systems software that coordinates the hardware and software components of a computer system
What does PC mean?
Personal Computer
What is a central computer that contains collections of data and programs?
Server
What is a computer network?
Two or more computers connected together to exchange data and programs;
Which unit network engineers describe network speeds?
bits per second
How many bits is one byte?
8
Which numbers are the core of all computer operations?
Binary
What is a group of 8 bits usually called?
A byte
Which number does binary only use?
Numbers between 0 and 1
What is the name of this process? The number is divided by two, and the remainder is the least-significant bit. The (integer) result is again divided by two, its remainder is the next most significant bit. This process repeats until the result of further division becomes zero
Conversion to binary system and from decimal system.
Binary may be converted to and from hexadecimal somewhat more easily. How many digits of binary it takes to represent one digit of hexadecimal?
four
Which one is the binary representation of decimal number (25)?
(11001)
Which one is the binary representation of decimal number (32)?
(100000)
Which one is the binary representation of decimal number (34)?
(100010)
Which of the following statements is FALSE.
Each memory location can store any number of bits.
What are the two fundamental things the processor can do to a byte of main memory?
It can write 8 bits to a byte in memory, and it can read 8 bits from a byte in memory;
Which one is the octal representation of decimal number (25)?
(31)
Which one is the octal representation of decimal number (39)?
(47)
What is a file?
A file is a collection of information that has been given a name and is stored in secondary memory.
Which one is the hexadecimal representation of decimal number (170)?
AA
Which one is the binary representation of octal number (36)?
(11110)
_______________ erases all the data on a disk and arranges the magnetic particles on the disk surface so the disk can store the data.
Formatting
Which one is the binary representation of hexadecimal number (C1)?
(11000001)
Which one is the octal representation of binary number (111111)?
(77)
A(n) _____ is a collection of data that has a name and is stored on a disk or other storage medium.
File
Which one is the hexadecimal representation of binary number (111111)?
(3F)
The physical parts of a computer called:
Hardware
In the filename student.exe, .exe is a(n) ____________________?
Extension
Which device is used to point to things and select things on the screen?
Mouse
If you delete the icon for a file, what happens to the file?
it is deleted logically from the disk but may sometimes be restored
The second name of diskettes?
Floppy Disk
Which device connects your computer to the telephone system?
Modem
The main directory of a disk is referred to as the ________________ directory.
Root
Which type of storage devices can be used in computers?
I. Floppy disks II. Hard disks III. Compact discs (CD-ROMs) IV. Removable disks
I. II. III. IV
Where CPU is situated?
mainboard
CPU like a … of computer.
Brain
Raster is:
a horizontal Line of Pixels
What does RAM stands for?
Random Access Memory
What part of the Hard Disk is called virtual memory?
RAM
Vector image is:
a collection of geometrical object’s coordinates and parameters
The biggest board inside System Unit?
Mainboard
What does DVD stands for?
Digital Video Disk
Which of the following is one byte of information:
00110101
Where all the main components of a computer are grouped together?
System Unit
How the devices are attached to the mainboard?
Via cables
Two files with same names can be located:
in two Different directories
Which device allows computer to communicate with each other though cables?
the Network Interface Card
Output device that gives you a copy of your work?
Printer
Which of the following is output device?
Plotter
The smallest unit of information is:
Bit
Which of the following is input device?
Mouse
Output device which is similar to printer?
Plotter
One byte consists of:
8 bits
Output device which displays images generated by video card?
Monitor
Standard keyboards have…
104--105 keys
Which of the following input devices is used to point to things and select things on the screen?
Mouse
Which of the following input devices is used to point to things and select things on the screen?
Mouse
Which of the following input devices converts sound waves into electric signals that can be understood by your computer`s sound card?
Microphone
Which of the following devices can recognize the location of a touch on its surface?
Touch Screen
1011 AND 1101 =?
1001
Which of the following input devices used to select items and choose commands on the screen by pointing the pen at the screen ?
Light pen
Which of the following is a type of camera that stores photographed images electronically?
Digital Camera
10011 ? 10001 = 01100. What logical operation should be instead of “?” ?
NOR
Which of the following devices used to exchange sound and video across the Internet in real time?
Webcam
Which of the following devices uses special light sensors to capture (or photograph) an image and make a digital copy?
Webcam
(100110 AND 100011) OR 011000=?
111010
Which of the following is a relative pointing input device because of no limits to its movement?
Mouse
Which buttons are used to navigate through locations you've already visited?
Back and Next
Simplify the expression ((A AND B’)’ OR B’) AND B
B
Which charater can NOT be used to name a file?
/
How do you rename a shortcut?
Right-click the selected item and select Rename.
Simplify the expression (A OR (A AND B’)’ AND
AORC
What are examples .EXE, .DOC, and .JPG of ?
File extensions
Which menu of Windows Explorer includes commands like Cut, Copy, Paste, Undo, etc…?
Edit
How do you delete a file permanently from your computer (without sending to Recycle Bin)?
Shift Delete
How do you set the 'Read-only' property of a file?
Right-click the file; and then click Properties; Read-only
The expression (A AND’ is equivalent to
A’ OR B’
In order to select more than one file, use
Ctrl Click
What do you do to go to the previous level when you're browsing the contents of your computer?
Click the Back button on the toolbar.
How do you sort the files according to their file size?
View, Icons size
Which one represent all jpeg photo files whose names start first with the letter 'a'?
a* .jpg
What is the difference between hardware and software?
Hardware is tangible, but software is intangible
Which is not an option in Views in Windows Explorer?
View
What is shortcut?
Pointer to file
Which toolbar is used to start programs by clicking?
Quick Launch
What hardware components (of a typical desktop computer) are usually found inside of the system’s unit?
The processor, main memory, and secondary memory,
MS – DOS is
Command line interface operating system
What is the Linux?
It is the version of Unix Operating System
Which component is the "brains" of a computer system?
The processor chip
What is the function of shell in operating systems?
Provides direct communication between user and the kernel
What is the word processor?
Application program for creating and manipulating text documents
What is the operating system?
Software that controls how hardware resources are used
Which type of memory is most closely connected to the processor?
Main memory
What is the main purpose of computer software?
Gives instructions that make hardware work
What is the GUI (graphical user interface)?
It is the program to visualize pictures and photos
What is the spreadsheet software?
Program that helps to organize text and numeric data and performs calculations
Where are programs and data kept while the processor is using them?
Main memory
What is the presentation software?
Program that helps to create sequence of words, music, video to create presentation
Which of the following is related with multimedia?
Video
There is only one low-level language, called …
Assembler
How are bytes written onto a hard disk?
Bits are magnetically recorded on the disk;
There is only one low-level language, called …
Assembler
After which step, can you not cancel installation?
Dynamic Update
Plotter is:
device
How many process(es) can run at the same time in Windows XP?
more than 10
Which toolbar contains the open and save buttons?
Standard toolbar
To open a document:
From the Menu bar, choose File, Open..
Which of the following is data storage device:
Hard disks and floppies
The _________ view is how your document would appear in a web browser.
Web Layout
If you want to Copy a text and Paste it to another place, which shortcut keys should you use?
Ctrl Z and Ctrl X
Which device is used as long-term data storage:
Monitor
To select a word, you must do ____ on the word.
Double click
The most efficient way of creating a list is to use
Format - Tabs menu
How can you end numbering in a list?
Press enter twice at the end of the list.
Which of the following can be considered as Output device?
Printer;
The orientation of a page can be changed from
Page Setup
How many margins are on a page?
Four (top, bottom, right, left)
The Internet was created for the U.S Department of Defense for military communications purposes in …
1969
Another name for the Internet?
WWW
Translates domain names to their IP addresses and vise versa.
Domain Name Server
What is a computer virus?
Malicious program, which harms the computer
What type of virus can exploit security vulnerabilities to spread itself automatically to other computers through networks?
worm
Which type of viruses are written in the scripting languages for Microsoft programs such as Word and Excel and spread throughout Microsoft Office by infecting documents and spreadsheets?
macro viruses
What do users install to eliminate known viruses after the computer downloads or runs the executable?
Anti-virus software
What is a type of malware that is installed on computers and collects little bits information at a time about users without their knowledge?
Spyware E
Which of the following computer language is used for artificial intelligence?
Prolog
Which part interprets program instructions and initiate control operations.
Control unit
Which type of system puts the user into direct conversation with the computer through a keyboard?
Interactive computer
A single packet on a data link is known as
Frame
The process of communicating with a file from a terminal is
Interrogation
The examination and changing of single bits or small groups of his within a word is called
Bit manipulation
Which computer has been designed to be as compact as possible?
Micro computer
Which method is used to connect a remote computer?
Dialup
The average time necessary for the correct sector of a disk to arrive at the read write head is _____
rotational delay
A number that is used to control the form of another number is known as
mask
A general purpose single-user microcomputer designed to be operated by one person at a time is
PC
Which device of computer operation dispenses with the use of the keyboard?
Mouse
A hashing scheme is used with
direct file organization
When was the IBM XT microcomputer released in the market?
1987
Which of the following is not used for storage purposes with mainframe computers.
diskettes
Which is true for the digital computer?
It represents the decimal numbers through a string of binary digits
What is the main advantage of magnetic core memory over semiconductor RAM memory?
non volatile
The function of CPU is
To read, interpret and process the information and instruction
The central processor of a modern digital computer consists of
Control Unit And Primary Memory
In negative logic, the logic state 1 corresponds to
lower voltage level
From what location are the 1st computer instructions available on boot up?


ROM BIOS
With respect to a network interface card, the term 10/100 refers to
megabits per seconds
Which of the following is the 1's complement of 10?
01
The binary system uses powers of
2
The term referring to evacuating the content of some part of the machine is known as
Dump
The list of coded instructions is called
Computer program
The arranging of data in a logical sequence is called:
sorting
Which of the following is usually a special one-time operation that must be completed over a limited time period?
Project
A device or system not directly connected to the CPU is
Off-line
The microprocessor of a computer cannot operate on any information if that information is not in its.
main storage
A device which converts human readable data into machine language is
Character reader
What digits are representative of all binary numbers?
Both (a) and (b)
What is the name of the chip which has more than once processor on it?
Transputer
Which of the following is a set of general purpose internal registers?
scratch pad
A family of polynomial block codes designed to correct burst errors is known as
Fire codes
To produce high-quality graphics (hardcopy) in color, you would want to use a(n)
plotter
The computer code for the interchange of information between terminals is
ASCII
Which of the following is required when more than one person uses a central computer at the same time?
terminal
Which is not necessary when using bar codes in supermarkets?
Price on the shelf
The basic components of a modern digital computer are :
All of the above
What does that acronym EGA stand for?
Enhanced Graphics Array
A beam of light used to record and retrieve data on optical disks is known as
laser
Punched-card equipment was first introduced in Britain in 1904 by a small company. What was the name of that company?
the Tabulator Ltd.
The computer translates the condition of each switch to a number. What number is represented by the ON state?
1
A disk with usable recording surfaces on each side is known as
Double-sided disk
What is a portion of memory that serves as a temporary repository for data as it waits for a given action?
Cache
In serial, asynchronous transmissions, the ____ bit is used to signal the end of the character within the data frame
stop
Which is the acronym for Algol extended for design.
AED
Which of the following are often used to ensure that data has been accurately input to the computer?
input controls
An input device that converts data punched into paper lape into a binary format is
Paper tape reader
A computer will function only if it
has a program in its memory
Which of the following languages is more suited to a structured program?
A computer assisted method for the recording and analyzing of existing or hypothetical systems is
Data flow
The brain of any computer system is
CPU
A report generator is used to
print files on paper
Which of the following is not a logical data-base structure?
chain
Which of the following is a database administrator's function?
all of the above
Primitive operations common to all record management systems include
Look-up
Each of data files has a _____ that describe the way the data is stored in the file
File structure
After you _____ a record, many data management the environments require you to issue a command to save the changes you made.
Update
Data item characteristics that are important in data management include
width
In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
COMMIT
Periodically adding, changing and deleting file records is called file
updating
In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
Hierarchical database
When using a database management system, the first thing that you must do is to
load the software into your microcomputer
Which of the following is not a relational database?
Reflex
Which command is used to remove a table from the database in SQL?
DROP TABLE
Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
ALTER TABLE
In SQL, which of the following is not a data Manipulation Language Commands?
CREATE
In SQL, which command(s) is(are) used to redefine an index's future storage allocation
ALTER INDEX
Which of the following is a serious problem of file management systems?
All of the above
The data-base environment has all of the following components except:
Separate files
What is a user interface that provides an alternative appearance and customized functionality for software such as Windows Media Player?
skin
What do you need to record something with speakers, sound card?
microphone
What is the role of the operating system in managing files?
The operating system is not involved with files; it just keeps the hardware running
What is the Media Player software?
Program that plays music, video
What is the presentation software?
Program that helps to create sequence of words, music, video to create presentation
Which of the following is related with multimedia?
Video
Which of the following is a digital audio recording and processing program?
Sound Forge
Which one of the followings is not an Operating System?
Microsoft Office
How can you can use Windows Movie Maker?
To record audio and video source materials and import source files, which you can then edit and arrange to create videos
What is short for compressor-decompressor that can compress and uncompress audio or video content?
codec
What is a general term that refers to audio and video media, images, text, and any other information that is seen or heard as part of a media presentation?
content
How do many online radio stations make their signal available over?
the internet
Where OS UNIX was developed?
AT&T., Bell Labs;
What numbering system is used for data transfer through the network?
Binary
What is the binary equivalent of decimal 7?
111
What of the following devices cannot be shared in a network?
File
What is the decimal equivalent of binary 11111000?
248
Which types of OS are used to control machinery, scientific instruments and industrial systems?
Real-time operating system (RTOS)
Which one is not an important criterion to choose a media type?
Color
Which of the following devices is used for connecting to the network?
Network card
Which of the following ip-adresses is localhost?
127.0.0.1
What is the maximum value of each of the four numbers of ip-adress?
255
Which type of OS allows many different users to take advantage of the computer's resources simultaneously?
Multi-user
What of the following devices connects computers to one network?
Switch
If the Subnet Mask is 255.255.255.0, what is the number of the usable IP addresses for the hosts?
254
If five hosts are connected to a hub, how many IP addresses are required for those six devices?
5
How is called World global network?
Internet
In which way does asymmetric OS work?
Asymmetric operating systems use one CPU for their own needs and divide application processes among the remaining CPUs
How is the bandwidth described?
Bits per second
How is the set of rules called to make communications between the devices in a network?
protocol
Which LAN topology connects all the workstations to a central point, using a hub or switch?
Star
What protocol is used for transferring web pages from server?
HTTP
NTFS4 New Technology File System used with win NT 4 provides support for hard disks, up to?
2 terabytes
It is the Internet tool using one computer to control a second computer.
Telnet
Software that provides a way to look at and interact with all the information on the World Wide Web.
Web Browser
Which one is language for making web pages?
PHP
Which of extension below does web pages have?
.html
What file contains all the hardware configuration, Plug and Play settings, and application settings and is located in c:\windows as a hidden file ?
system.dat
Why do we use CSS?
To define how to display HTML elements on web page
Why do we use JavaScript?
To add interactivity to web pages
Why do we use DOM HTML?
To define a standard way for accessing and manipulating HTML documents
Why do we use SQL?
it allows you to access a database
The World Wide Web allows text, pictures, sound and movies to be displayed on the Internet user's screen, via a software called …
web Browsers
WINDOWS: A directory can contain:
Files and subdirectories
When WWW is began?
1980
Which program that infects computer files by copying itself into files as they are loaded into memory?
virus
Which of the program is not antivirus software?
operating system
The WWW is also called?
World Wide Web




















Зарегистрируйтесь на ontext.info для получения дополнительных возможностей по работе с сервисом.