Question 1

Which field will be the key field in the records?
A) address
B) balance owing
C) name
D) account no
E) Duncan

Accepted Answer

The account number is typically used as a key field because it uniquely identifies each record in a database.

Question 2

One of the uses of a spreadsheet model is to ask 'what if' questions and carry out analysis. Which of the following is a correct description of a
'what if' analysis?
A) All the cells in a spreadsheet will be updated whenever an entry is changed
B) Numerical cells in a spreadsheet can be formatted in a variety of ways
C) The model can be emptied of data when circumstances require it to be changed
D) Changes in data input will cause the model to recalculate giving an indication of the possible results of the change
E) A management technique which is just a management fad

Accepted Answer

'What if' analysis involves changing data inputs in a model to see how those changes affect the outcomes, allowing for exploration of different scenarios.

Question 3

The link between the logical view and the physical view of data is the?
A) application program
B) the database management system
C) the database
D) programming
E) the data dictionary

Accepted Answer

The database management system (DBMS) serves as the intermediary between the logical view and the physical view of data, managing how data is stored, retrieved, and manipulated.

Question 4

In database management systems the structure is a ______________
representation of the data.
A) physical
B) logical
C) relational
D) tabular
E) hierarchical

Accepted Answer

Logical representation of data is the structure in database management systems.

Question 5

Which of the following is not a logical database structure?
A) Tree
B) relational
C) network
D) chain
E) all of the above are logical structures

Accepted Answer

The "chain" is not a recognized logical database structure. The tree, relational, and network are established logical database structures.

Question 6

What provides the capability of writing, assembling, designing, and
printing high quality documents?
A) word processing
B) desktop publishing
C) data processing
D) office automation
E) databases

Accepted Answer

Desktop publishing provides the tools and capabilities for designing, assembling, and printing high-quality documents, often with advanced layout and graphic design features.

Question 7

Computers use the binary system to represent data. Which of the
following statements is true?
A) Binary codes cannot be used by computers to represent text
B) Numbers must be processed into ASCII code in order to be processed by a computer
C) Binary code is used because computers recognise only two states
D) The English alphabet is the only thing a computer understands
E) Arithmetical operations are the only things that computers understand

Accepted Answer

Computers use binary code because they operate using two states, often represented as 0 and 1, which correspond to the off and on states of a computer's transistors.

Question 8

Which of the following is not usually associated with computer networks?
A) Local Area Network
B) Value Added Network
C) Multi-purpose Network
D) Metropolitan Network
E) Wide Area Network

Accepted Answer

Multi-purpose Network is not a standard term associated with computer networks, unlike the other options which are recognized types of networks.

Question 9

A __________________ is a set of rules governing information flow in a
communication system.
A) message envelope
B) standard
C) communication protocol
D) transmission mode
E) modem

Accepted Answer

A communication protocol is a set of rules governing information flow in a communication system.

Question 10

A Trojan Horse in computing terms can be defined as:
A) Badware which when run will perform some malicious function when some pre-defined set of conditions arise, i.e., date, time, the millionth action, etc.
B) A program inside which a virus and or logic bomb can hide during either its transmission phase between machines or its running phase on a host computer
C) Don't Know

Accepted Answer

A Trojan Horse is a type of malicious software that disguises itself as a legitimate program to trick users into installing it, allowing viruses or other malicious components to hide and execute on a host computer.

Question 11

Information can be classified under the following risk categories.
A) Intentional caused by insiders usually in the course of business
B) Unintentional caused by insiders
C) Intentional, caused by outsiders usually external to the normal routine of business operations (e.g.: industrial espionage)
D) Unintentional, caused by natural disasters (fire, flood etc.)
E) Nothing to worry about and it is all hyped up by the press

Accepted Answer

Information can be classified under the following risk categories:
A) Intentional caused by insiders usually in the course of business: This refers to situations where individuals within an organization deliberately misuse or manipulate data or information systems for personal gain or to harm the organization. This could include activities such as fraud, theft of sensitive data, or sabotage of systems or networks.
B) Unintentional caused by insiders: This refers to situations where individuals within an organization inadvertently cause harm to data or information systems. This could occur through simple human error, such as accidentally deleting important files, or through negligence, such as failing to follow proper security protocols.
C) Intentional, caused by outsiders usually external to the normal routine of business operations (e.g.: industrial espionage): This refers to deliberate attacks on an organization's data or information systems by individuals or groups outside the organization. This could include activities such as hacking, phishing, or industrial espionage.
D) Unintentional, caused by natural disasters (fire, flood etc.): This refers to damage or loss of data or information systems due to natural disasters such as fires, floods, earthquakes, or storms. These events can cause significant disruption to business operations and can be difficult to predict or prevent.
E) Nothing to worry about and it is all hyped up by the press: This is a dismissive attitude towards information risk, suggesting that the threats and dangers are exaggerated or sensationalized by the media. However, this viewpoint is generally considered to be misguided, as the risks associated with information security are very real and can have serious consequences for businesses and individuals alike.

Question 12

Which of the following are types of computer crime? 1. Breaking in
2. Theft of computer time
3. Altering programs
4. Altering Data
5. Theft of Programs
6. Espionage
7. Terrorism
8. Accidental Loss of Data
A) 1,2,3,4,5,6 and 7
B) 1,2,3,4,5,6,7 and 8
C) 2,4,6 and 8
D) None of the above
E) 2,4,5,6,7 and 8

Accepted Answer

Computer crimes include unauthorized access (breaking in), theft of resources (computer time), altering programs or data, theft of programs, espionage, and terrorism. Accidental loss of data is not a crime.

Question 13

Listed below are methods which can be used to secure information
systems. Which one of the following is the odd one out?
A) Procedural controls
B) Technical controls
C) Management controls
D) Legal enforcement
E) Allowing professional hackers to enter your computing systems without any resistance

Accepted Answer

Allowing professional hackers to enter your computing systems without any resistance is not a method to secure information systems; it is a security risk.

Question 14

Who usually writes computer viruses?
A) Disgruntled workers
B) Terrorists
C) Hackers
D) Academic Experience
E) All of the above

Accepted Answer

The answer of Who usually writes computer viruses?
A) Disgruntled workers
B)...

Question 15

Which of the following is not usually associated with a Wide Area Network
A) The computers are geographically dispersed
B) The organisation can be connected permanently or not to the WAN
C) The shape usually represents a Ring Network Topology
D) WAN's are usually controlled by a specialised company such as BT or PTT
E) Wide Area Networks can provide access to VAN's.

Accepted Answer

Wide Area Networks (WANs) are not typically associated with a Ring Network Topology, which is more common in Local Area Networks (LANs). WANs often use more complex topologies like mesh or star.

Quiz 1: Computer Networks, Databases, and Programming Languages

Which field will be the key field in the records?

One of the uses of a spreadsheet model is to ask 'what if' questions and carry out analysis. Which of the following is a correct description of a 'what if' analysis?

The link between the logical view and the physical view of data is the?

In database management systems the structure is a ______________ representation of the data.

Which of the following is not a logical database structure?

What provides the capability of writing, assembling, designing, and printing high quality documents?

Computers use the binary system to represent data. Which of the following statements is true?

Which of the following is not usually associated with computer networks?

A __________________ is a set of rules governing information flow in a communication system.

A Trojan Horse in computing terms can be defined as:

Information can be classified under the following risk categories.

Which of the following are types of computer crime? 1. Breaking in 2. Theft of computer time 3. Altering programs 4. Altering Data 5. Theft of Programs 6. Espionage 7. Terrorism 8. Accidental Loss of Data

Listed below are methods which can be used to secure information systems. Which one of the following is the odd one out?

Who usually writes computer viruses?

Which of the following is not usually associated with a Wide Area Network