NEW
Font size
WorksheetsIT JUNE 2020 P1
Total questions: 60
Worksheet time: 30mins
Which of the following items are considered computer hardware?
Data
Programs
Output devices
Operating systems
Data that can be processes and has meaning is termed
information
database
storage
output
Which of the following can be termed "application software"?
DOS
Linux
Mac OS
Internet explorer
Which of the following activities would NOT be considered as cloud storage?
Data stored on remote servers
Data stored and accessible on a LAN
Data back-up and storage devices on the internet
Data managed by storage providers or hosting companies
Which of the following could NOT be classified as a cloud-based application?
Gmail
Drop Box
Google Drive
Windows OS
The lights in a room turn on as soon as a person enters. Which input device MOST likely controls the lighting in the room?
Sensor
Remote
Scanner
Keyboard
Which of the following devices is used to input data into the computer?
Mouse
Monitor
USB flash drive
External hard drive
For which of the following interface types is the user required to remember specific instructions and syntax?
Menu driven
Graphical user
Computer screen
Command driven
Item 9 refers to the following model of a globe. The MOST suitable printer for creating the model of the globe is
a 3-D printer
a laser printer
an ink-jet printer
a thermal printer
The RP Secondary School wants the administrative staff to have access to all student and teacher data. Which of the following networks would be MOST suitable to enable such access?
WLAN
WAN
MAN
LAN
This question refers to the symbol shown. The symbol represents
LAN
Wi-Fi
Hotspot
Bluetooth
Unauthorized, real time interception of a private communication on a computer network is referred to as
propaganda
identity theft
industrial espionage
electronic eavesdropping
Double entry data verification involves
different data entered at once
The data entered being copied to another device
different data entered once by two different persons
the same data entered once then re-entered by another person
Part of a private network using internet technology and public telecommunications that can be accessed by business suppliers, vendors, customers and partners is called an
Internet
Intranet
Extranet
Ethernet
Which of the following shows an increase in computer memory capacity?
Terabyte -> Gigabyte-> Megabyte
Gigabyte -> Kilobyte -> Megabyte
Megabybte-> Terabyte-> Gigabyte
Megabyte-> Gigabyte-> Terabyte
Which of the following functions is performed by a modem?
Analog to digital
Digital to download
Analog to download
Download to upload
In the URL http://www.shoes.com, "shoes.com" stands for
extension
domain name
company name
internet company
Transferring data from a remote computer to your computer is referred to as
browsing
uploading
data mining
downloading
Which of the following types of technologies is commonly used by banks to read data on cheques?
POS
OCR
OMR
MICR
Which of the following operations is considered a feature of a biometric system?
Matching fingerprints
Detecting irregular heartbeat
Diagnosing medical symptoms
Helping to lubricate skeletal joints
Telecommuting can be BEST described as
using the computer while commuting
using the telephone while commuting
working from home by connecting home and office
working from the office after establishing a connection at home
In order to use a program stored on a flash drive, the program must be transferred into
ROM
RAM
PROM
EPROM
Which of the following is NOT a hardware component of a computer system?
Data file
Main memory
Peripheral device
Central processing unit
Which of the following checks is NOT a validation technique?
Range
Inconsistency
Double entry
Reasonableness
The process of scrambling messages at the sending end and unscrambling them at the receiving end is called
coding
encryption
espionage
eavesdropping
There are many software restrictions used by computers to protect data and maintain data integrity. Which of the following entities are software restriction media?
I. Viruses
II. Passwords
III. Encryptions
I and II only
I and III only
II and III only
I, II and III
Which of the following devices can be used for both input and output?
Touchscreen
Barcode reader
Flatbed scanner
Document reader
Which of the following is true of accessing files sequentially?
Occurs in any order
Starts with the first record
Starts with the largest data field
Starts with the smallest data field
Which of the following is a hardware user interface?
GUI
Icon
Sensor
Touchscreen
An official of Company X sells confidential information about his company to Company Y. What is the term used forr this type of information misuse?
Identity theft
Computer fraud
Industrial espionage
Electronic eavesdropping
Which of the following are NOT categorized as system software?
Productivity tools
Operating systems
Translators
Utilities
Which part of the central processing unit (CPU) coordinates its activities?
Register
Control unit
Main memory
Arithmetic logic unit
Before purchasing a computer, James was given a sheet with the following hardware specifications:
Intel Pentium IV 64bit
3.6 GHz 2GB 533MHz
50 RAM 160GB SATA
HDD 7200rpm
The word use of the computer is
2GB
64 bit
7200 rpm
533 MHz
Which type of interface allows the user to communicate with the computer system by keying in instructions?
Menu driven
Graphical user
Touch sensitive
Command driven
A Webmaster is important to the company because he/she
is responsible for the company's website
assigns web addresses to all users in a company
backs up files and stores the disks at another location
monitors the shutting down of competitor's websites
Which of the following is an example of a correctly formatted email address?
lana.happy@net
@lana.happy.net
lana@happy.net
lana@happy@net
Which of the following types of software should be used for applications that involve repetitive numerical calculations?
Database
Presentation
Spreadsheet
Word processing
Selecting or highlighting a paragraph creates a
file
block
merge
document
The following formula is located in position B6 of a spreadsheet.
=B3 + B4 +$B$5
What would be the resulting formula if the initial formula was copied to the position located immediately on the left?
C3 + C4 + C5
A3 + A4 + A5
A3 + A4 + $B$5
C3 + C4 + $B$5
In creating a query, a student entered the following criteria for the date field.
>=05/11/2017 and <=05/14/2017
The output will show days
after 14 May 2017 only
from 11 to 14 May 2017
before 11 May and after 14 May 2017
between 14 May and 5 November 2017
Spreadsheet formulae use
values or labels
labels or cell addresses
values, ranges or cell addresses
values, labels or cell addresses
Which of the following buttons can be used to fully justify text?
The following table contains data from 3 countries A, B and C for 2018 and 2019.
Country 2018 2019
A 300 600
B 500 800
C 500 600
Which of the following types of charts is NOT suitable for representing the data above?
Pie
Bar
Line
Column
The field that uniquely identifies a record in a database is called the
foreign key
primary key
alternate key
secondary key
Which of the following sequences of steps is correct for deleting a field in a database table?
Choose the delete row option. Select row to be deleted and right click. Open table in design view. Choose yes to confirm deletion.
Open table in design view. Select row to be deleted and right click. Choose the delete row option. Choose yes to confirm deletion.
Select row to be deleted and right click. Open table in design view. Choose the delete row option. Choose yes to confirm deletion.
Select row to be deleted and right click. Choose the delete row option. Open table in design view. Choose yes to confirm deletion.
Look at the following database table
Item No. Item Desc. Quantity
H050 Hammer 20
H040 Hammer 40
FK030 Fork 35
FK020 Fork 40
FK015 Fork 45
The database table above shows records sorted by
Quantity in ascending order
Quantity in descending order
Item No. in ascending order
Item No. in descending order
Which of the following clearly identifies a hyperlink on an HTML document?
I. A link to an email address.
II. A link to another webpage.
III. A link to another location within the webpage.
I and II only
I and III only
II and III only
I, II and III
Which of the following is used for executing HTML code?
A parser
A browser
An assembler
An interpreter
Which security feature offers the LEAST protection to a Word document?
Restricting editing
Adding a digital signature
Encrypting with a password
Saving as compatible with the appropriate software version
Cell B8 contains the formula
=sum(B2:B6)
If the formula is copied to the cell C8 then the formula in cell C8 will be
=sum(B2:B6)
=sum(B3:B7)
=sum(C2:C6)
=sum(C3:C7)
Look at the following algorithm
Read (A, B)
If A < B Then
Print (A)
Which of the following tasks does the following algorithm perform?
Reads two numbers and prints the first number
Reads two numbers and prints the smaller number
Reads two numbers and prints the first number if it is larger than the second number
Reads two numbers and prints the first number if it is smaller than the second number
Which of the following is an example of a conditional construct?
IF...THEN...ELSE
FOR....ENDWHILE
WHILE ....ENDWHILE
REPEAT...UNTIL
When implementing a program, which of the following steps comes after executing?
Linking
Compiling
Maintaining
Interpreting
Which of the following is NOT a high-level programming language?
C
Java
Pascal
Assembly
Which of the following terms is an invalid variable name?
Sum
2count
Vat15
Count
The decision box of a program flow chart shows the
link to another page
test to be carried out
calculation to be done
input and output operations
A computer programmer is coding an algorithm which calculates the class average for a given exam. He creates a variable called class_avg. Which data type should he specify when declaring this variable?
Real
Integer
Boolean
Character
Look at the following algorithm:
I. Ask users for length and width
II. length, width
III. area <- length * width
IV. "Area of rectangle is", area
Which of the following options, in the correct order, can be used to replace I, II and III in the algorithm?
Read, write, prompt
Write, Read, prompt
Prompt, read, write
Read, prompt, write
What is the name given to an identifier that always holds the same value?
Constant
Location
Variable
Storage
Look at the following algorithm:
Write("Enter price: " (1)
Read (price) (2)
Vat:=price * 15% (3)
Write vat (4)
Which line contains a processing statement?
1
2
3
4
