WorksheetsCSEC IT Multiple Choice Questions 2
Total questions: 60
Worksheet time: 30mins
Executing the statement x = A + B involves performing the computer function(s)
input and output
input only
output only
processing and storage
Once a document is typed into the computer, it may be permanently saved in
backing storage
primary storage
RAM
ROM
In order to execute a program which is stored on the hard drive, the program must first be transferred to
Random Access Memory
Read Only Memory
the Arithmetic Logic Unit
the control unit
The storage capacity of a compact disk is usually measured in
bytes
gigabytes
kilobytes
megabytes
A DVDROM is an example of
ALU
control unit
main memory
secondary storage
All of the following can be classified as input devices EXCEPT
biometric systems
scanners
sensors
speakers
When purchasing a computer printer, the main factor a buyer should consider is
compatibility of the printer and the computer
size of Random Access Memory
speed of the processor
storage capacity of the hard disk
The decimal number 59 represented in hexadecimal is
73
311
3B
3C
The value of the leftmost digit in the octal number 302 is
24
64
192
300
The ability of a computer to execute two or more programs at the same time using the same processor is
multi-media processing
multi-processing
multi-programming
multi-tasking
If the ASCII code for the letter 'F' is 1001010, the ASCII code for the letter 'R' is
1001001
1010100
1010001
1010110
Which one of the following is a fast means of transferring information between digital devices?
Firewire
Hard drive
IDE
Serial ports
Which of the following is NOT an example of specialized software?
Airline Reservation System Software
AutoCad
Microsoft Office
Peachtree
Three modes of processing data are
batch, online, and real time
batch, online, direct
direct, sequential, indexed-sequential
manual, automatic, and semi-automatic
A technology that is frequently used in the food industry and was designed for a limited set of choices to be easily selected is a
command driven interface
graphical user interface
menu
touch screen
A modem in a computer is used to
communicate from the mouse to a scanner
link two or more computers using telephone lines
provide a link from a computer to the user
send information to ROM
The characteristic of a communication channel that defines the speed at which the data transmission occurs is
bandwidth
broadband
protocol
voiceband
A main feature of an intranet is it uses
an extranet
FTP
internet protocols
wireless technologies
The process of sending data to another computer via a communication channel from a user's computer storage is
downloading
uploading
signalling
transferring
Jane wants to set up a discussion forum for a group of her friends. The MOST appropriate tool is a
blog
electronic bulletin
telnet
wiki
One way to secure data that is being transmitted over a network is to
archive the data
encrypt the data
validate the data
verify the data
All of the following can violate the privacy of data EXCEPT
access logs
electronic eavesdropping
industrial espionage
surveillance
Software in which the source code is made freely available over the internet is BEST known as
expert systems
Microsoft office
open source software
proprietary software
The general term given for the use of technology to control computers in the manufacturing process is
CADD
CAE
CAM
Expert system
Information Technology has impacted all of the following EXCEPT
education
law enforcement
movie industry
All of the above
The MOST appropriate person in an IT department to make recommendations for a new computerized system or the upgrade of an existing system is the
database administrator
network administrator
systems analyst
technician
Tracking rainfall measurements during the hurricane season is an example of
automation
commercial data processing
process control
scientific data processing
The type of document that is used to take data and enter it into a computer system is BEST termed as
object
original
source
turnaround
Data Verification is the process whereby
a program has been compiled to ensure that there are not syntax errors
a program has been checked for logical errors
data has been checked by the same person or another person after it has been keyed in to ensure that there are no errors
data has been checked to ensure that it is realistic
The type of error that occurs when errors are made in the spelling of words in a document is BEST termed as
Typographical
Transposition
Syntax
Logical
Which of the following is NOT a function of a word processing package?
Creation of forms
Creation of queries
Creation of reports
Creation of tables
The text at the bottom is termed a(n)
endnote
footer
footnote
page break
The feature in a word processing package that allows a user to place text in a grid format is
Chart
Picture
Shapes
Table
Which of the following word processing formatting features have been applied to the word below? I. bold TEXT II. font size III. italics IV. superscript
I and II only
I and III only
I, II and III only
I, III and IV only
Which of the statements about presentation software is NOT true?
Wizards can be used.
Presentation slides can be controlled by a timing feature.
A sequence of slides can be created in a particular order.
The slide transition applied must be the same for all sides.
The feature in presentation software that allows one slide to replace another is
Slide design
Slide layout
Slide master
Slide transition
The first page that is always downloaded when a user visits a website is a(n)
domain name
hyperlink
index page
thumbnail
Which of the following can be used to jump from one web page to another?
Domains
Hyperlinks
Internet browsers
Protocols
Which application software is Microsoft Excel an example of?
Database Management
Presentation
Spreadsheet
Word Processing
The formula to find the AVERAGE of the contents in the cells A1, A2, A3, A4 and A5 using Microsoft Excel is
AVE (A1; A2; A3; A4; A5)
AVE (A1.A5)
AVERAGE (A1:A5)
AVERAGE (A1-A5)
The Microsoft Excel function "COUNT" can be used to count the number of
alphabetic characters only
numeric values only
both alphabetic and numeric characters but only one type at a time
both alphabetic and numeric characters at the same time
The most efficient way to get the same information text repeated in another cell of a worksheet is to
Copy and paste
Cut and paste
Select all
Type over the text
A set of related files is called a
Database
Field
Record
Worksheet
Which of the following is NOT a characteristic of entities?
Entities can be people, places, things and events.
Entities can represent collection of things.
Entities should have detailed descriptions.
Entities are represented on the entity-relationship diagram by labeled boxes.
A row of data found in a database is a
column
file
record
table
After a problem has been identified, the next step is to
analyse the problem
generate the solution
implement the solution
write the program
All of the following symbols can be used in constructing flowcharts EXCEPT
parallelogram
oval
circle
square
If P is true and Q is false, then POR Q returns
0
False
True
An error
In an algorithm, if x = 3 and y = 5, then the result of x + y/5 is equal to
An error
1.6
3
4
Given the following algorithm, what is the value for S? I. P=3 II. Q=5 III. RP+Q IV. S+R+Q*P
11
22
23
33
Machine language is written using
Basic code
Pascal code
Binary code
Cobol code
A characteristic of a first generation language is that it is
Fastest to execute
Difficult to debug
Machine dependent
All of the above
A program which translates a high level language program into machine code one line at a time is called a/an
assembler
compiler
interpreter
linker
Which of the following is a type of program error? I. Debug II. Execution III. Logic IV. Syntax
IV only
III and IV only
I, III and IV only
II, III and IV only
All of the following are valid variables in a Pascal program EXCEPT
FirstName
Gross pay
Net_pay
Name2
The Pascal statement to place the value of 25 into the array Marks at index 5 is
5:= Marks [25];
Marks (5) := 25;
Marks [5] := 25;
Marks [25] := 5;
Which one of the following is BEST choice for the name of a program to calculate the sum of a set of ten numbers?
10SUM
Calculate sum
program
total
Which of the following is the Pascal code to print the following: 'The sum is' and the value of SUM?
Print ("The sum is', SUM);
Print ("The sum is", SUM);
Writeln ("The sum is,', SUM);
Writeln('The sum is',SUM);
Which of the following can be used for repeating instructions in a program coded in Pascal? I. For...Do II. If...Then...Else III. Repeat...Until IV. While...Do
II only
IV only
III and IV only
I, III and IV only
If the following data is inputted, what will be the result? 15 21 30 40
num1 is set to 15, num2 is set to 16 and num3 is set to 17
num1 is set to 15, num2 is set to 17 and num 3 is set to 16
num1 is set to 15, num2 is set to 21 and num3 is set to 30
num1 is set to 15, num2 is set to 21 and num3 is set to 16
