Information Technology - Paper 01

Flashcards from Information Technology - Paper 01

Which part of the CPU coordinates the activities of the entire unit?

Control unit

What is the primary function of the Arithmetic Logic Unit (ALU)?

Performs mathematical calculations

Give an exmaple of application software

Microsoft Edge

Which of the following is NOT an example of Cloud Storage?

Data stored and accessible on a LAN

Which of the following is NOT included in cabled transmission media?

Satellite

Which box shows carries out processing in a general-purpose computer system?

Box Z

Which network is most suitable for connecting two campuses in different locations?

WAN

What type of interface requires the user to remember specific instructions and syntax?

Command-driven

What device is used for printing industrial quality architectural drawings?

Plotter

Which device is used to input data into the computer?

Mouse

Which countermeasure can ONLY be implemented as a software measure to mitigate threats to a computer system?

Intrusion detection system

What is unauthorized, real-time interception of a private communication on a computer network?

Electronic eavesdropping

What is the process of double-entry data verification?

The same data being entered once and then re-entered by another person

What is an extranet?

Part of a private network using Internet technology that can be accessed by business partners.

What type of data check is used to ensure that data captured matches the source data?

Visual

What function is performed by a modem?

Modulates analog and digital signals

What is a characteristic of an intranet?

Allows access to employees

What is Transferring data from your computer to a remote computer?

Uploading

What technology is commonly used by banks to read data on cheques?

MICR

What file organization method should be used for filing records submitted online in an online application?

Index-sequential

What is the most efficient method to authenticate customers when they log into their accounts?

Direct

What is the first step in order to use a program stored on a secondary storage device?

into RAM

How are Records on a magnetic tape stored?

Sequentially

What is the job of a web developer?

Is responsible for the company's website

Which is the LEAST reliable way to keep online passwords secure?

Keep a copy of all passwords on your computer.

Describe a denial-of-service (DOS) attack

Inability to reach regular websites because of too many requests; Decrease in network performance because of a flood of transactions

What protocol ensures all web pages and servers communicate with each other?

HTTP

Accessing files sequentially?

Starts with the first record

Which machine-readable document is NOT a turnaround document?

Multiple choice sheets used in examinations

What is the most likely reason for a computer suddenly losing Internet access on a LAN while other devices still have access?

The network cable is loose or needs replacing.

Which of the following are NOT categorized as system software?

Productivity tools

What is the correct order of connecting hardware components of a LAN, starting from the ISP's telecommunication line, to a desktop computer?

modem to router to switch

The CPU speed of the computer

3.6 GHz

The speed of the hard drive in the computer

7200 rpm

Which of the following is an example of a correctly formatted e-mail address?

[e-mail]

Which of the following symbols MUST be placed in front of the column letter and row number to create an absolute reference?

• * !

Selecting or highlighting a paragraph creates a

block

In the URL http://www.shoes.com, 'shoes.com' represents the

domain name

What would be the resulting formula if the initial formula was copied to the position located immediately to the right?

C3+ C4+ $B$5

When creating a query, a student entered the following criteria for the date field, what days will the output show?

from 11 to 14 May 2022

HTML code is executed by?

Browser

Real numbers entered in a cell on a spreadsheet are automatically

right justified with decimal places

What type of cell addressing must be used to keep the cell address in a formula the same, when the cell address is copied to another cell?

Absolute

Which of the following features would be LEAST efficient when using the Find and Replace dialogue box to replace all occurrences of the word hen with the word duck?

Having the text in parts of words replaced

Which of the following formulas will display the exercise name Zumba.

=VLOOKUP (G5, A18: C22, 2, FALSE)

Which of the following formulas will count the number of customers whose gender is equal to M.

=COUNTIF(D2: D10, "M")

Which of the following features allows the user to insert individual names in a primary document?

Mail merge

When creating a database for a supermarket, the MOST appropriate data type to use for the price of an item is

currency

The field that uniquely identifies a record in a database is called the

primary key

Which of the following characteristics must two database tables have in order for them to be linked?

At least one common attribute name

Which of the following tasks does the algorithm perform?

Reads two numbers and prints the first number if it is larger than the second number

Which FOR statement below has the correct high-level language syntax to accomplish the task?

FOR count = 1 to 12 DO…ENDFOR

When implementing a program, which of the following steps comes after executing?

Maintaining

The MOST appropriate data type for storing the amount of interest earned on a sum of money is

real

Which of the following terms is an invalid variable name?

2count

Which of the following statements should be placed at Step 3?

Set average ← (n1+n2+ n3)/3

The decision box of a program flow chart shows the

test to be carried out

Which data type should he specify when declaring this variable?

Real

Which of the following is an example of a conditional construct?

IF… THEN … ELSE

When testing an algorithm for correctness, which of the following manual testing methods is MOST effective in verifying the results?

Trace table