Computer Applications Technology P2 Multiple Choice Questions
QUESTION 1 June 2019
Various options are given as possible answers to the following questions. Choose the answer
and write only the letter (A–D) next to the question number (2.1–2.10) in the ANSWER
BOOK, for example 2.11 D.
1.1 Which ONE of the following is an example of a data cap?
A 10 GB
B 100 Mbps
C 512 kB
D 2 GHz (1)
1.2 Which ONE of the following is NOT a feature of a database program?
A Filter
B Sort
C Citation
D Grouping (1)
1.3 Which ONE of the following file types can NOT be opened by a spreadsheet
program?
A .xls
B .zip
C .csv
D .txt (1)
1.4 A higher resolution image means that the image …
A is made up of more pixels.
B requires less storage space.
C contains less pixel information.
D is made up of larger pixels. (1)
1.5 The use of virtual reality (VR) technology may benefit the user as it ...
A requires specialised and expensive equipment.
B may possibly protect the user against cybercrime.
C gives more information on a place being visited.
D could be used for safer training in risky situations. (1)
1.6 The main purpose of OCR is to produce a document so that it can be …
A saved in PDF format.
B edited and formatted.
C saved as a picture.
D sent via e-mail or IM. (1)
10
Computer Applications Technology P2 Multiple Choice Questions
1.7 The spreadsheet function NOW will always display the …
A date on which the spreadsheet is opened.
B Excel code for hh mm ss formatted as time.
C current date-time formatted as date and time.
D date and time on which the function was entered. (1)
1.8 Fake news is when …
A you are redirected to a false website without knowing about it.
B false and often sensational information is spread on social media.
C the source of a message is falsified to make it appear legitimate.
D someone tries to obtain your personal and financial information. (1)
1.9 Faulty software contains bugs that …
A damage programs by affecting the way in which a computer works.
B use resources by copying the code repeatedly across the programs.
C hide within a legitimate program and contain destructive instructions.
D are errors in the code that cause problems and make it unworkable. (1)
1.10 A database query to extract the details of teachers and learners who owe more than
R10.00 is shown below.
The query will not return the desired outcome because the …
A criterion of the AmountOwed field should be '<10'.
B 'And' in the Category field should be in uppercase.
C 'Or' operator should be used in the Category field.
D criterion of the AmountOwed field should be '>=10'. (1)
[10]
QUESTION 1 Nov 2019
Various options are provided as possible answers to the following questions. Write down the
question number (1.1–1.10), choose the answer and make a cross (X) over the letter (A–D) of
your choice in the ANSWER BOOK.
1.1 The CPU can easily be changed on a …
A sound card.
B hard drive.
C memory chip.
D motherboard. (1)
11
Computer Applications Technology P2 Multiple Choice Questions
1.2 Which ONE of the following types of software allows you to try out a program before
you buy it?
A Freeware
B Malware
C Shareware
D Adware (1)
1.3 Any document saved on a computer is referred to as a ... copy.
A hard
B soft
C backup
D cloud (1)
1.4 When a user presses a combination of keys on a keyboard to perform an action, it is
called a …
A hyperlink.
B shortcut.
C function.
D paragraph. (1)
1.5 A … is required for viewing a simulated world in 3D.
A VR headset
B webcam
C 3D printer
D GPS device (1)
1.6 A file name ending with the … file extension is a type of file that stores data in text-
only format.
A .exe
B .zip
C .pdf
D .csv (1)
1.7 A trend in technology that allows for household appliances to be connected to the
internet:
A https
B VoIP
C IoT
D IM (1)
12
Computer Applications Technology P2 Multiple Choice Questions
1.8 Which ONE of the following options is NOT essential to allow for collaboration during
M-Learning? Learners …
A can share and get feedback on their work in real time.
B must have the necessary computer skills.
C can access and connect to the internet at all times.
D must have the latest expensive portable technologies. (1)
1.9 A spreadsheet feature or a combination of features used to display values or data
that meet certain criteria is known as ...
A data validation.
B find and select.
C format and edit.
D sort and filter. (1)
1.10 Which ONE of the following options will display the symbol 'A' for a learner mark of
80 found in cell A1 of a spreadsheet?
A = IF (A1=80, "A", "")
B = IF (A1=80, "", "A")
C = IF (A1<80, "A", "")
D = IF (A1>80, "A", "") (1)
[10]
QUESTION 1 Nov 2020
Various options are provided as possible answers to the following questions. Write down the
question number (1.1.1–1.1.10), choose the answer and make a cross (X) over the letter (A–
D) of your choice in the ANSWER BOOK.
1.1 A blinking vertical bar that shows the position of the text being typed in a text editor
is called a …
A highlight.
B border.
C symbol.
D cursor. (1)
1.2 The communication medium commonly used for an ADSL internet connection is …
A copper cable.
B radio waves.
C fibre-optic cable.
D sound waves. (1)
1.3 Which ONE of the following is closely related to biometric security?
A Firewall
B Password
C Fingerprint reader
D Encryption key (1)
13
Computer Applications Technology P2 Multiple Choice Questions
1.4 A … is a possible reason why a program will not install.
A slow download speed
B slow start-up process
C change of regional settings
D restricted user account (1)
1.5 Study the following incomplete nested IF statement:
=IF(A1=1, IF(B1=4, "Yes", "No"
Which ONE of the following options would complete the statement to display either
'Yes' or 'No' depending on the conditions below?
Yes – if the value in cell A1=1 AND the value in cell B1=4, OR
No – if either one of these conditions are not met
A ))
B ), "No")
C ), "No"))
D , "")) (1)
1.6 Which ONE of the following would you use to solve the problem when your computer
randomly hangs after a driver update?
A System Restore
B Disk Cleanup
C System Backup
D Task Scheduler (1)
1.7 One of the possible constraints (limitations) of big data is …
A a loss of revenue.
B a loss of user privacy.
C a malware infection.
D available bandwidth. (1)
1.8 A wireless router could be damaged if it was placed or used next to a microwave
oven because of …
A the heat.
B vibration.
C interference.
D a fire hazard. (1)
1.9 A bookmark is a feature of a word processor that uses …
A hyperlinks.
B styles.
C tables.
D sections. (1)
14
Computer Applications Technology P2 Multiple Choice Questions
1.10 Study the following HTML code carefully:
<font face="Arial" colour="green"> First website </font>
Assume that all the code prior to the line above is correct. Which ONE of the
following font colours will be used when displaying the text 'First website' in a
browser?
A Red
B Black
C Green
D Orange (1)
[10]
QUESTION 1 Jun 2021
Various options are provided as possible answers to the following questions. Write down the
question number (1.1–1.10), choose the answer and make a cross (X) over the letter (A–D) of
your choice in the ANSWER BOOK.
1.1 A file ... specifies the unique location of a file or folder in a file system.
A name
B path
C attribute
D extension (1)
1.2 Which ONE of the following properties does NOT refer to the metadata of a word
processing document?
A Author
B Size
C Format
D Created (1)
1.3 … is an acronym for the term used to describe human errors and its influence on
computer output.
A FOSS
B SOHO
C DIMM
D GIGO (1)
1.4 On older computers the … will slow down the transfer of data when compared to
newer computers.
A file size
B lag/delay
C hardware
D images (1)
15
Computer Applications Technology P2 Multiple Choice Questions
1.5 The … will determine the type of language and graphics used in a presentation
program.
A layout
B conclusion
C audience
D animation (1)
1.6 A touch screen is the most effective input device when a user is required to …
A choose between limited options.
B capture large amounts of text.
C select from a long list of unsorted options.
D enter a large series of numbers. (1)
1.7 A … is an audio file usually delivered over the internet.
A wiki
B portal
C vlog
D podcast (1)
1.8 A … is a malicious program that is used to initiate a DDoS attack.
A virus
B bot
C keylogger
D worm (1)
1.9 Which ONE of the following calculated fields will determine value-added tax of 15%
in a database query correctly?
A VAT:[Price]*0.15
B VAT=(!Price)*0.15
C VAT=["Price"]*0.15
D VAT:(Price)*0.15 (1)
1.10 Faking an e-mail header to hide the actual origin of the e-mail is known as …
A pharming.
B spoofing.
C piracy
D copyright (1)
[10]
16