WorksheetsIKT-1
Total questions: 112
Worksheet time: 56mins
Which of the following is (are) true about computers?
II only
II and III only
I, II and III
I and III only
A computer processes data in a device called the
server
CPU
device driver
URL
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
Computers that operate in essentially the same way are said to be
compatible
compound
user-friendly
integrated
Which of the following can supply input to a computer?
III only
I, II, and III
I and II only
I only
Software has two categories: operating system software and application software.
True
False
Operating system software example:
Microsoft Word
Unix
Chrome
Macromedia Dreamweaver
Computers perform all basic operations except:
Input data
Process data
Protect data
Output data
Which of the following can supply input to a computer?
III only
I only
I and II only
I, II, and III
The ASCII code for the character ‘a’ is 97. How can the character ‘a’ be represented in binary using ASCII codes?
00000001
01000001
None of the above
01100001
Which of the following represents the decimal number sequence 0, 1, 2, 3 in binary?
0000, 0001, 0010, 0100
0001, 0010, 0011, 0100
None of the above
0000, 0001, 0010, 0011
Which of the following is the binary representation of decimal number 16?
1100
1111
1110
None of the above
How many hexadecimal digits are needed to represent the decimal number 32?
1
4
8
2
Which of the following is the binary representation of decimal number 23?
11000
11110
10111
None of the above
All of them example of input devices except?
keyboard
mouse
printer
All of them example of output devices except?
CPU
Monitor
Printer
Speakers
Digital computer breaks all types of information into tiny units and use numbers to represent those pieces of information
True
False
An analog computer recognizes data as a continuous measurement of a physical property.
True
False
Information is a collection of raw facts and figures. It may consist of numbers, characters, symbols or pictures etc.
True
False
All of them are examples of hardware except:
CPU
I/O
Memory
Mac OS
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
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
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
Which of the following memory types holds data but requires very little power to retain its contents?
RAM
Virtual memory
RDRAM
CMOS
The list of instructions that a CPU can execute is known as its
op codes
operands
glossary
instruction set
CPU performance is influenced by which of the following?
I and III only
II only
I and II only
I, II, and III
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
When a computer is turned on, the central processing unit performs instructions specified by the _____ that searches the disk drive for the main operating system files.
CMOS
RAM BIOS
virtual memory
ROM
Which of the following explains Latency?
is the maximum number of bits or bytes that can be stored in RAM.
is typically measured in megabytes (MB).
this delay is also referred to as access time.
is a virtual memory.
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
Where is a computer's CPU located?
On a hard disk drive
On a floppy disk drive
On an expansion card
On the motherboard
A computer clock with a speed of 100 MHz cycles how many times per second?
100,000
1,000
100
100,000,000
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
Consider Computer A, which uses a 1.2-GHz CPU, and Computer B, which uses a 1-GHz CPU. For any given program P, which of the following is true?
Program P runs faster on Computer A than it does on computer B.
Program P runs faster on Computer B than it does on computer A.
It takes the same amount of time for program P to run on computer A as it does on computer B.
Which of the following can be an advantage of buying a computer that contains a widely-used CPU or its equivalent clone?
I and II only
I, II, and III
I and III only
II and III only
Which of the following kinds of projects typically requires a special type of CPU that would not be found in a desktop or mainframe computer?
Processing requests to send and receive email
Performing business calculations for a financial report
Looking up and storing information on customer accounts
Monitoring the operation of an automobile engine
Which of the following is (are) true of modern microprocessors?
Microprocessor chips are typically the size of a deck of cards.
Microprocessors typically contain millions of transistors.
I only
None
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
Components of the CPU typically include which of the following?
I. The control unit
II. The Level 1 cache memory
III. The Arithmetic/Logic Unit
I, II, and III
An Arithmetic/Logic Unit typically performs which of the following operations?
I. Retrieval of instructions from RAM
II. Performance of greater-than and less-than comparisons
II only
I only
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.
A copy of the document is loaded from the disk into RAM and edited in RAM.
Which of the following is (are) true of ROM?
I. ROM stores data until computer is turned off.
II. The instructions needed to boot a computer are typically stored in ROM.
II only
None
Which of the following types of memory typically holds computer configuration settings and is powered by a small battery?
ROM
Cache
Flash
CMOS
Of the following types of memory, which is least expensive and is not located on the microprocessor?
L1 Cache
L2 Cache
Register
DRAM
Which of the following is (are) true of a bus on the motherboard?
I. A bus is not critical to the overall performance of a computer system.
II. A bus is used to transport data between components on the motherboard.
III. The CPU and other components use a bus to read and write data into RAM.
II and III only
Which of the following are important considerations when purchasing a monitor?
I. The number of resolution modes supported
II. The different levels of color depth supported
III. The size of the viewing area that can be projected
I, II, and III
Which of the following are true of Universal Serial Bus (USB)?
I. Many devices can potentially be interconnected using the USB.
II. It is used with many types of devices for transferring large amounts of data.
III. It supports existing serial- and parallel-port devices.
I and III only
The speed of a computer bus is measured in _____, whereas the transfer rate is measured in _____.
hertz, Bps
Bps, hertz
bits, channels
channels, bits
Input devices for a computer include which of the following?
I.Digital cameras
II.Scanners
III.Speakers
I and II only
Computer output devices include which of the following?
I.Projector
II.Microphone
III.Printer
I and III only
Which of the following correctly represents the layers of software in a computer system (from lowest level to highest level of abstraction)?
BIOS, Operating System, Application, Runtime Library, User Interface, Application Program Interface
Operating System, BIOS, Runtime Library, Application Program Interface, User Interface
BIOS, Operating System, Application Program Interface, Runtime Library, Application, User Interface
BIOS, User Interface, Operating System, Application, Runtime Library, Application Program Interface
Which of the following statements is true?
RAM is slower than ROM.
CMOS stores configurations.
Initially, when the computer is turned on, only the operating system can be found in the RAM.
Private files are protected by the BIOS.
Which of the following best describes preemptive multitasking?
A real-time clock generates interrupts during which other processes may be executed.
Multiple CPUs concurrently execute processes in parallel.
As soon as a process has completed execution, the execution of another process begins.
The CPU switches between processes after executing each instruction.
Which of the following operations cause(s) a fault to occur?
I. The hardware is asked to do something it cannot do.
II. The memory's error correction circuitry detects an uncorrectable error.
III. The program attempts to execute an illegal machine instruction.
Encapsulation is:
Organizing software into layers that are relatively dependent
when each layer needs only a limited amount of knowledge to do its job
when all layers should be connected
about how software layers communicate
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
Application Program Interface (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
User interface:
Manages storage for programs and data
Typically, it is a GUI, composed of buttons and pull-down menus
Maintain security of the system
Sets standards for all the application software used in a computer system
Which of the following deals directly with the signals that control each hardware component?
Basic Input/Output System (BIOS)
User Interface
Kernel
API
Operating systems can be classified into two categories: server operating system and desktop operating system.
True
False
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.
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
In a given database define primary key in table Students?
Id
FirstName
TeacherId
LastName
Define the foreign key in table Students?
TeacherId
Id
DateOfBirth
LastName
An E-Commerce system consists of the following components. Which of the same components must be included in a database management system?
I. The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc.
II.A collection of programs must be included that control the data, such as programs to create, maintain, and manipulate the data.
III.A collection of programs that operate on the data, but are specific to the E-commerce system.
An E-Commerce system consists of the following components. Which of these same components will constitute a database system?
I. The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc.
II.A collection of programs that control the data, such as programs to create, maintain, and manipulate the data constitutes a database system.
III.A collection of programs that operate on the data, but are specific to the E-commerce system.
The foreign key in a table T1_____ the same _____ as the corresponding primary key in table T2.
must have, name
need to have, name
must have, id number
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
Which of them is not component of the database system?
An application specific database
A DBMS that maintains this database
Application Software that manipulates the database
Application programmers
Which of them is not type of the DBMS?
Oracle
Microsoft Access
MySQL
Web Application
The standard data model for modern databases is the relational in the table form.
True
False
A primary key, also called a primary keyword, is a key in a relational database that is unique for each record.
True
False
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
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
Which of them is used to translate hostnames into numeric IP addresses
TCP
DNS
IP
UDP
Which of them provides reliable connection?
TCP
IP
UDP
DNS
Data confidentiality is
data is not altered unintentionally
data access is restricted to authorized personnel
services that enable data access are operational
malicious programs disabling the system
Brute force:
matching every word in the dictionary against the password
trying all different alphanumeric combinations
captures data packets as they are transmitted through the network
refers to the action of tricking people into providing information needed to gain access to systems
Social engineering:
trying all different alphanumeric combinations
matching every word in the dictionary against the password
refers to the action of tricking people into providing information needed to gain access to systems
captures data packets as they are transmitted through the network
Packet sniffing:
captures data packets as they are transmitted through the network
trying all different alphanumeric combinations
matching every word in the dictionary against the password
refers to the action of tricking people into providing information needed to gain access to systems
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
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
pen
Which of them is not true about Firewalls
A firewall is a software that can be loaded on to a network that can serve as a barrier that keeps destructive forces away from a network of computers
Packets of data are analyzed against a set of criteria or standards called filters.
Filters block certain designated IP addresses.
Provides other companies or individuals with access to the Internet
Which of the following services use TCP?
a. DHCP
b. SMTP
c. HTTP
d. TFTP
e. FTP
Using Substitution encryption encrypt following: plaintext: GAR encryption key: shift right by two character
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 For example: 205.39.145.18
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
To improve the efficiency of transferring information over a shared communication line, messages are divided into fixed-sized, numbered packets
True
False
Which of them is the server-side language?
HTML
Java
Javascript
CSS
Which of them is the client-side language?
Java
PHP
Javascript
ASP.NET
Define the attribute name: align= “right”;
p
align
"right"
Web browser
Request a web page from a web server by typing either URL or a web page
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.
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.
Client is
The process of creating, modifying web pages.
Any page that is hosted on the Internet.
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.
HTML is the standardized markup language that structures and formats content on the web. Page elements like the titles, headings, text and links are included.
True
False
CSS allows a programmer to define the look and format of multiple webpages at once; elements like color, layout and fonts are specified in one file that’s kept separate from the core code of the webpage.
True
False
JavaScript is the programming language that brings animation, games, apps, interactivity and other dynamic effects to life.
True
False
Client-side scripting simply refers to any code that facilitates the transfer of data from that web server to a browser. It also refers to any code used to build a database or manage data on the web server itself.
True
False
Server-side scripts run on the web server, which has the power and resources to run programs that are too resource intensive to be run by a web browser.
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 where the resource is located.
True
False
The Internet is a collection of documents that are interconnected by hyper-links.
True
False
The Web is a collection of computers or networking devices connected together.
True
False
Which of the following correctly represents the layers of software in a computer system (from lowest level to highest level of abstraction)?
BIOS, Operating System, Application, Runtime Library, User Interface, Application Program Interface
Operating System, BIOS, Runtime Library, Application Program Interface, User Interface
BIOS, Operating System, Application Program
BIOS, Operating System, Application Program Interface, Runtime Library, Application, User Interface
