WorksheetsICT Questions
Total questions: 101
Worksheet time: 51mins
Which of them provides reliable connection?
TCP
IP
UDP
DNS
A monitor is primarily which kind of device?
An output device
An input device
A memory device
A storage device
Computer output devices include which of the following?
I and II only
I, II, and III
II and III only
I and III only
All of them are examples of hardware except:
CPU
I/O
Memory
Mac OS
All of them are examples of storage devices on the computer except:
CD-ROM
CD-RW
Floppy disk
Scanner
All of them are true about software except:
Software is a set of computer instructions or data.
Software receives input from the user and processes this input through the computer to produce output.
Software is a type of equipment added to computer to enhance its functionality.
Software specifies how to process the user's data.
Operating system software example:
(a)
Of the following types of storage, which provides the fastest access to data?
RAM
CD-ROM
Hard disk
Cache
The microprocessor in a multi-purpose computer is also known as the:
RAM
PCI
VGA
CPU
Computers that operate in essentially the same way are said to be:
Compatible
Compound
User-friendly
Integrated
A computer file is a named collection of data that exists on which of the following?
I, II and III
III only
I only
II and III only
Which of the following can supply input to a computer?
III only
I only
I and II only
I, II, and III
Which of them is not type of the DBMS?
Oracle
Microsoft Access
MySQL
A primary key, also called a primary keyword, is a key in a relational database that is unique for each record.
True
False
A user interface is:
A way for users to interact with a computer or device.
A type of computer virus.
A programming language.
A hardware component that stores data.
Which of them is not true about data files?
Applications must access data directly
Applications must be aware of the file structure
Applications may have to access data that they do not need while searching for some piece of data
Use of access methods that act as index to retrieve the data
Define primary key in table Students?
Id
FirstName
Year
LastName
Which of them is used to translate hostnames into numeric addresses?
TCP
DNS
IP
UDP
An E-Commerce system consists of the following components. Which of these same components must be included in a database?
I. The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc.
II. A database must include a collection of programs that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains.
III. A database must include a collection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc.
vvv
Which of the following is (are) true about computers?
II only
II and III only
I, II and III
I and III only
IP spoofing:
To detect security weaknesses in a remote or local host
Is a technique used to gain unauthorized access to computers, whereby the intruder sends messages to a computer with an IP address indicating that the message is coming from a trusted host
Where an attacker fakes an email header to make it appear as if it came from somewhere or someone other than the actual source
Refers to the action of tricking people into providing information needed to gain access to systems
Which of the following can supply input to a computer?
III only
I, II, and III
I and II only
I only
Computer output devices include which of the following?
I and II only
I, II, and III
II and III only
I and III only
Operating systems can be classified into two categories: server operating system and desktop operating system.
True
False
Computers perform all basic operations except:
Input data
Process data
Protect data
Output data
Define primary key in table Students?
Id
FirstName
Year
LastName
Which of the following deals directly with the signals that control each hardware component?
Basic Input/Output System (BIOS)
User Interface
Kernel
API
Operating system software example:
Microsoft Word
Unix
Chrome
Macromedia Dreamweaver
A software system that enables users to define the data, maintain it and control its access is called?
Database
Database Management System
Table
Primary key
There are two ways to store data: data files, in database.
True
False
The generic term node or host refers to:
Device on a network
Network connection
The speed with which data is moved
Physical wires or cables
Hardware is:
Lowest level of the computer
Most primitive level of software
Used by Operating systems to control a device
Performs functions that are critical to maintaining the operating system
Select the correct statement(s) about a computer virus:
Attaches itself to a file or software application
Is a program that appears to be performing one task while executing a malicious task in the background
Is malicious software that can execute itself on a vulnerable remote machine
Penetrate computer systems more easily because they do not need a user to execute them
Where is a computer's CPU located?
On a hard disk drive
On a floppy disk drive
On an expansion card
On the motherboard
Which of the following components is (are) typically found on the motherboard of a computer?
II only
I and II only
I, II, and III
I and III only
All electronic components in the system unit are connected to motherboard.
True
False
Storage Devices are used to store data permanently even when the computer is turned off.
True
False
All of them are examples of storage devices on the computer except:
CD-ROM
CD-RW
Floppy disk
Scanner
All of them are true about software except:
· Software is a set of computer instructions or data.
· Software receives input from the user and processes this input through the computer to produce output.
Software is a type of equipment added to computer to enhance its functionality.
Software specifies how to process the user's data.
Which of the following is true about API?
Abstraction defined by OS to work with applications
Layer where the routines perform tasks the application is designed to do
A library of routines that are bound to the program during execution
Responsible for the communication between the application and the user
When a computer is turned on, the central processing unit performs instructions specified by the operating system files that searches the disk drive for the main:
CMOS
RAM BIOS
Virtual memory
ROM
Which of the following is the primary function of a CPU?
To determine if a program functions correctly before using it
To execute only the operating system's instructions
To execute only the instructions within a user specified application
To execute any program's instructions stored in RAM
Information technology (IT) is the use of any computers, storage, networking and other physical devices, infrastructure and processes to create, process, store, secure and exchange all forms of electronic data.
True
False
An Arithmetic/Logic Unit typically performs which of the following operations?
II only
I only
None
I and II
Of the following, which best describes what happens when a user opens a document for editing?
A copy of the document is loaded from the disk into cache memory and edited in the cache.
The document image is moved to free space on the disk where the image is directly edited.
The document image is directly edited on the disk where it resides.
Which of the following memory types holds data but requires very little power to retain its contents?
RAM
Virtual memory
RDRAM
CMOS
What is an area in the computer system unit that temporarily holds data before and after it is processed until the computer is turned off?
ROM
Hard disk drive
CMOS
RAM
A computer processes data in a device called the:
Server
CPU
Device driver
URL
Software has two categories: operating system software and application software.
True
False
Operating system software example:
Microsoft Word
Unix
DBMS uses Structured Query Language (SQL) for data manipulation.
True
False
Database is a shared collection of logically related data and a self-describing collection of integrated records.
True
False
All of them example of input devices except?
Keyboard
Mouse
Printer
Using Substitution encryption encrypt following: Plaintext: GAR Encryption key: shift right by two character Select the correct encrypted text.
IST
UDP
FTP
ICT
Hostname is an unique identification that specifies a particular computer on the Internet.
True
False
Network software translates a hostname into its corresponding IP address.
True
False
File server a computer that stores and manages files for multiple users on a network.
True
False
In a denial of service (DoS) attack, the objective of the attacker is to exhaust system resources such as network connectivity and network bandwidth to prevent legitimate traffic from being transmitted and processed.
True
False
A Trojan horse is a program that appears to be performing one task while executing a malicious task in the background.
True
False
Web server a computer dedicated to responding to requests (from the browser client) for web pages.
True
False
Server is:
Any computer on the network that requests services from another computer on the network
Any computer that receives requests from client computers, processes and sends the output
Any page that is hosted on the Internet
The process of creating, modifying web pages
Web Page is:
The process of creating, modifying web pages
Any computer on the network that requests services from another computer on the network
Any computer that receives requests from client computers, processes and sends the output
Any page that is hosted on the Internet
Web Development is:
The process of creating, modifying web pages
Any computer that receives requests from client computers, processes and sends the output
Any computer on the network that requests services from another computer on the network
Any page that is hosted on the Internet
Which of them is not true about WEB server?
Used to host the web sites
Used to retrieve web sites
Used to monitor access
Used to control logging
The web information is stored in the Web pages:
In HTML format
In the Web server file system
In XML format
In HTTP form
Which of the following is not true about HTTP?
Protocol used to access data on the WWW
Uses one TCP connection on well-known port 80
Two types of http messages: Request, Response
Uses one UDP connection on well-known port 25
Client-side scripting:
Is any code that runs within a web browser.
Executes on the server side
Uses request - response methods
Hidden from the users
68. TCP/IP (Transport control Protocol/Internet Protocol):
Carry internet data from an inter-linked communications network.
Is used only for wireless communication.
Is a protocol for sending emails only.
Is a hardware device for network connectivity.
Define the attribute name: align="right";
p
align
"right"
Web browser:
It is a collection of information stored on the networked computers over the world.
Internet service that stores and provides information.
One or more links that point to other web pages which makes it easy to follow a thread of related information.
Request a web page from a web server by typing either URL or a web page
HTTP:
Is a global Internet address of a document on a computer
IP address or the domain name where the resource is located
Uses UDP protocol.
To create a true HTML document, you start with
HTML, META, and BODY
HTML, HEAD, and BODY
HTML, META, and TITLE
HTML, P, and BODY
ICT refers to all methods, tools, concepts related to
recording digital information
storing digital information
All of the above
sending digital information
CSS stands for
Cascading Style System
Cascading Super Sheet
Cascading Style Sheets
Cascading System Sheet
Which is used to read an HTML page and render it?
Web browser
Web network
attributes
sets
What does LAN stand for?
None
Logical Analogue Network
Local Area Network
Local Access Network
A web server is a computer dedicated to responding to requests (from the browser client) for web pages.
True
False
Server is:
Any computer on the network that requests services from another computer on the network
Any computer that receives requests from client computers, processes and sends the output
Any page that is hosted on the Internet
The process of creating, modifying web pages
Web Development is:
The process of creating, modifying web pages
Any computer that receives requests from client computers, processes and sends the output
Any computer on the network that requests services from another computer on the network
Which of the following is not true about Web server?
Used to host web sites
Used to retrieve web sites
Used to monitor access
Used to control logging
The web information is stored in the Web pages:
In HTML format
In the Web server file system
In XML format
In HTTP form
Which of the following is not true about HTTP?
Protocol used to access data on the WWW
Uses one TCP connection on well-known port 80
Two types of HTTP messages: Request, Response
Uses one UDP connection on well-known port 25
Which of the above is true about client-side scripting?
Is any code that runs within a web browser
Executes on the server side
Uses request-response methods
Hidden from the users
The attribute align="right" in HTML does which of the following?
Aligns the content to the right side of the element
Centers the content within the element
Aligns the content to the left side of the element
Justifies the content within the element
What is a web browser?
A device that stores information
A software that requests a web page from a web server by typing either URL or a web page
A protocol for communication
A type of computer network
HTTP is the protocol that allows Web browsers to communicate with Web servers.
True
False
The Internet is a collection of information stored on the _______ computers over the world.
networked
personal
isolated
ancient
Which protocol does HTTP use?
TCP
UDP
FTP
SMTP
Spoofing is
Decrypting passwords
Monitoring network traffic
Impersonating another computer
Accessing an unprotected port
Use of IT by government is
E-Commerce
E-Learning
E-Governance
E-Busines
Data used by a signatory to sign electronically
Cryptographic key
Electronic signature
Telegraph signatures
Faxed signatures
Technology-enhanced learning is
Cloud computing
E-commerce
E-learning
Data centere
Which of the following attributes is used to add link to any element?
newref
href
link
ref
What do you understand by HTML?
HTML consists of a set of elements that helps the browser how to view the content
HTML describes the structure of a webpage
All of the above
HTML is the standard markup language mainly used to create web pages
In URL http://www.iitu.kz, “http” refers to
domain name
language
web server
protocol used
HTTP
is the protocol that allows Web browsers to communicate with Web servers
is a global Internet address of a document on a computer
IP address or the domain name where the resource is located.
uses UDP protocol.
HTML is the standardized markup language that structures and formats content on the web.
True
False
JavaScript is the programming language that brings animation, games, apps, interactivity and other dynamic effects to life.
True
False
The first part of the URL address indicates what protocol to use, and the second part specifies the IP address or the domain name.
True
False
What is a web browser?
Client side UI tools
Tools to implement website logic
Helps find information using keywords
Software to find and view websites
HTML stands for ___
HyperText Machine Language
·
HyperText Marking Language
HyperText Markup Language
HighText Marking Language
