NEW
Font size
WorksheetsCSEC IT- Past Paper MCQ- 2020
Total questions: 60
Worksheet time: 3600secs
Which of the following items are considered computer hardware?
Data
Programs
Output Devices
Operating Systems
Data that has been processed 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
Dropbox
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 flashdrive
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
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
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 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
Megabyte->Terabyte->Gigabyte
Megabyte->Gigabyte->Terabyte
Which of the following functions is performed by a modem?
Analog and Digital
Digital and upload
Analog and download
Download and upload
In the URL http://www.shoes.com, 'shoes.com' stands for the
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 heartbeats
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 officer 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 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 scanner
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 for 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. The word use of the computer is
2 GB
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 competitors' websites
Which of the following is an example of a correctly formatted e-mail 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 + A5 + $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?
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 deleted and right click.
Open table in design row option.
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.
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 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
If the formula in Cell B8 is copied to the shaded cell, C8, then, the formula in Cell C8 would be
=sum(B2:B6)
=sum(B3:B7)
=sum(C2:C6)
=sum(C3:C7)
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
calculations 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
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
Which line contains a processing statement?
1
2
3
4
