Question 1

If we were to add these two numbers together 5 + 9 we would get 14.
How would a computer show the number 14 in binary code?
A) 101
B) 111
C) 1100
D) 1110
E) 0101

Accepted Answer

In binary code, the number 14 is represented as 1110.

Question 2

Which of the following is a characteristic of a Local Area Network
A) Computers are geographically dispersed
B) Usually connected together by satellite link
C) Allows the sharing of data with other organisations
D) Must confirm to industry standards
E) Does not have to confirm to industry standards

Accepted Answer

A Local Area Network (LAN) must conform to industry standards to ensure compatibility and interoperability between devices and systems within the network.

Question 3

Which of the following is not an advantage of the database approach?
A) elimination of data redundancy
B) ability to associate related data
C) increased security
D) program data independence
E) all of the above are advantages

Accepted Answer

All the options listed are advantages of the database approach, including elimination of data redundancy, ability to associate related data, increased security, and program data independence.

Question 4

Which is NOT normally associated with being one of the main functions
A) cash flow forecasting
B) What if analysis
C) Goal Seeking
D) Storing price lists of information
E) Sensitivity analysis

Accepted Answer

Storing price lists of information is not typically considered a main function in financial analysis or decision-making processes, unlike the other options which are analytical techniques.

Question 5

-Which of the following statements relating to the print-out extract is
correct?
A) Duncan is a field entry
B) The extract from the print out is a single record
C) Banquo is a character
D) The extract from the print-out is a field
E) None of the above

Accepted Answer

The answer of 
-Which of the following statements relating to...

Question 6

-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 7

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 8

The development of Computer Programming Languages aim to
1. move programming to the 'end user'
2. automate the process of programming as much as possible
3. be reliable
4. be easy maintained
5. be portable
6. be transferable with other computers
A) 1, 2, 3, 5, and 6
B) 2, 3, 4, 5, and 6
C) 1, 2, 4, 5, and 6
D) 3, 4, and 5
E) 1, 2, 3, 4, 5, and 6

Accepted Answer

The answer of The development of Computer Programming Languages aim...

Question 9

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 10

Read the following statements, and select the most appropriate outcome.
A. Value-added networks provide additional value by offering services other than the simple transmission of a communication.
B. Local Area Networks and Wide Area Networks are usually connected by gateways.
A) Only A is true
B) Only B is true
C) Both A and B are true
D) Both A and B are false
E) Don't Know

Accepted Answer

Value-added networks do offer additional services beyond simple transmission, and gateways are commonly used to connect Local Area Networks (LANs) and Wide Area Networks (WANs).

Question 11

In computing terms what is 'Half-Duplex' transmitting?
A) The sending and receiving of messages in both directions
B) The sending and receiving of messages in one direction
C) The sending of a message which never gets to its destination
D) The receiving of a message which is distorted
E) The receiving of a message which is not appropriate to the user

Accepted Answer

The answer of In computing terms what is 'Half-Duplex' transmitting?
A)...

Question 12

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 the host computer.

Question 13

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 indeed be classified under various risk categories based on the source and intention behind the risk. 
A) Intentional caused by insiders usually in the course of business: This refers to situations where individuals within the organization deliberately manipulate or misuse information for personal gain or to harm the organization. This could include activities like fraud, data theft, or sabotage.
B) Unintentional caused by insiders: This refers to situations where individuals within the organization accidentally cause harm to the information. This could be due to lack of knowledge, carelessness, or mistakes. Examples include accidental deletion of data, sharing confidential information unknowingly, or falling for phishing scams.
C) Intentional, caused by outsiders usually external to the normal routine of business operations (e.g.: industrial espionage): This refers to deliberate attempts by individuals or groups outside the organization to gain unauthorized access to information. This could be for purposes like industrial espionage, hacking, or cyber-terrorism.
D) Unintentional, caused by natural disasters (fire, flood etc.): This refers to situations where information is lost or damaged due to natural disasters like fire, flood, earthquake etc. These are uncontrollable events that can cause significant harm to physical and digital information assets.
E) Nothing to worry about and it is all hyped up by the press: This statement is incorrect. Information risks are a serious concern for organizations. They can lead to significant financial losses, damage to reputation, and legal issues. Therefore, it is important for organizations to have robust information risk management strategies in place.

Question 14

A database is an organised collection of data

Accepted Answer

A database is specifically designed to store, manage, and retrieve structured data efficiently, making it an organized collection of data.

Question 15

A Database Management System has the following characteristics?
A) Aids the user to create, store, change, sort and retrieve data
B) Aids the user to protect data only
C) Aids the user when trying to determine what databases to buy
D) Aids the user to store, change and retrieve data only
E) Aids the user to retrieve and manipulate data only

Accepted Answer

A DBMS aids the user to create, store, change, sort and retrieve data.

Question 16

The link between the logical view and the physical view of data is the:
A) application program
B) DBMS
C) database
D) programming
E) Data Flow Diagrams

Accepted Answer

The DBMS (Database Management System) acts as an intermediary between the logical view (how data is conceptually organized) and the physical view (how data is actually stored on hardware).

Question 17

Which database structure arranges data in some natural hierarchy?
A) tree
B) tabular
C) relational
D) network
E) sorted

Accepted Answer

A tree database structure arranges data in a hierarchical manner, with a single root and various levels of nodes, resembling a natural hierarchy.

Question 18

A spreadsheet is particularly suitable for accounting use because it
 automatically provides an audit trail

Accepted Answer

A spreadsheet does not automatically provide an audit trail. An audit trail requires tracking and recording of each transaction or operation, which is not a default feature of spreadsheets. While it is possible to design a spreadsheet to include some form of an audit trail, it would require additional setup and does not happen automatically.

Question 19

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 20

The standardisation of computer programming languages contributes
greatly to
A) compilation
B) portability
C) modularity
D) simplicity
E) none of the above

Accepted Answer

Standardisation of programming languages ensures that code can be run on different systems without modification, enhancing portability.

Quiz 1: Computer Networks, Databases, and Programming Languages

If we were to add these two numbers together 5 + 9 we would get 14. How would a computer show the number 14 in binary code?

Which of the following is a characteristic of a Local Area Network

Which of the following is not an advantage of the database approach?

Which is NOT normally associated with being one of the main functions

-Which of the following statements relating to the print-out extract is correct?

-Which field will be the key field in the records?

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

The development of Computer Programming Languages aim to 1. move programming to the 'end user' 2. automate the process of programming as much as possible 3. be reliable 4. be easy maintained 5. be portable 6. be transferable with other computers

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

Read the following statements, and select the most appropriate outcome. A. Value-added networks provide additional value by offering services other than the simple transmission of a communication. B. Local Area Networks and Wide Area Networks are usually connected by gateways.

In computing terms what is 'Half-Duplex' transmitting?

A Trojan Horse in computing terms can be defined as:

Information can be classified under the following risk categories.

A database is an organised collection of data

A Database Management System has the following characteristics?

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

Which database structure arranges data in some natural hierarchy?

A spreadsheet is particularly suitable for accounting use because it automatically provides an audit trail

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

The standardisation of computer programming languages contributes greatly to