WorksheetsRevision Quiz 2
Total questions: 24
Worksheet time: 18mins
Customers log in to an online application using a username and password to submit a record of their monthly meter reading to a utility company. Which file organization method is used for the file of all the records submitted by customers each month?
Serial
Random
Sequential
Index-sequential
Customers log in to an online application using a username and password to submit a record of their monthly meter reading to a utility company. Usernames and encrypted passwords are used to authenticate customers when logging into their accounts. Which of the following is the MOST efficient file access method?
Direct
Serial
Two step verification
Sequential
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
A system that analyses data and that uses rules and previous information to deliver possible decisions is called
a robot machine
an expert system
a biometric machine
a mainframe computer
Which of the following statements about biometric systems is INCORRECT?
The level of accuracy is very high.
The personal data captured is very intrusive.
A small amount of memory is used to store data.
The user has to be present to use the system.
Which of the following examples describe a denial-of-service (DOS) attack?
I. Sudden excessive increase in amount of junk emails
II. Inability to reach regular websites because of too many requests
III. Decrease in network performance because of a flood of transactions
I and II only
I and III only
II and III only
I, II and III
Which of the following protocols is used to ensure that all web pages and servers communicate with each other?
IP
FTP
VoIP
HTTP
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
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 are NOT categorized as system software?
Utilities
Translators
Productivity tools
Operating systems
The order of connecting the hardware components of a LAN, starting from the ISP’s telecommunication line, to a desktop computer is
modem to router to switch
switch to router to modem
router to modem to switch
modem to switch to router
Before purchasing a computer, James was given a sheet with the following hardware specifications. Intel Pentium IV 64 bit 3.6 GHz 2 GB RAM 160 GB SATA HDD 7200 rpm The CPU speed of the computer is
2 GB RAM
64 bit
7200 rpm
3.6 GHz
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
Which of the following devices is used for manual data entry into a computer system?
Smart card
Barcode reader
Document scanner
Optical mark reader
The link webmaster@myresourzeweb.net is MOST LIKELY linked to which object or location?
a location within the web page
an email address
a user-created file
another web page
Which of the following types of software should be used for applications that involve repetitive numerical calculations?
Database
Presentation
Spreadsheet
Word processing
Which of the following statements about the use of mail merge feature in the preparation of a document is UNTRUE? I. Field names in the primary document are optional. II. Multiple data files may be used for the same merge. III. Both a primary document and a data file is required.
I ONLY
I and II
II ONLY
II and III
Which content control on an online form is MOST SUITABLE for accepting "YES/NO" style data?
check box
command button
drop-down list
text box
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/14/2022 and <= 11/05/2022 The output will show days
after 14 May 2022 only
from 11 to 14 May 2022
before 11 May and after 14 May 2022
between 14 May and 5 November 2022
Spreadsheet formulae use I. values II. ranges III. cell addresses
I and II only
I and III only
II and III only
I, II and III
Integers entered in a cell on a spreadsheet are automatically
right justified with no decimal places
right justified with decimal places
left justified with decimal places
centred with no decimal places
