Question 1

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

A Ring Network Topology is more commonly associated with Local Area Networks (LANs) rather than Wide Area Networks (WANs). WANs typically use different topologies like mesh or star.

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 outcome, allowing for exploration of different scenarios and their potential impacts.

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) acts as an intermediary between the logical view (how users interact with data) and the physical view (how data is actually stored).

Question 4

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 5

All of the following are types of tangible software except:
A) systems software
B) operating software
C) management decision making software
D) application software
E) cyberspace software

Accepted Answer

Cyberspace software is not a recognized category of tangible software; it refers more to the virtual environment of the internet.

Question 6

Which language is the hardest for humans to write and understand
A) machine code (Binary)
B) assembly language
C) COBOL
D) BASIC
E) PASCAL

Accepted Answer

Machine code (Binary) is the hardest for humans to write and understand because it is a low-level language that uses only 0s and 1s to represent instructions.

Question 7

Which of the following has limited facilities for mathematical notation but
has excellent facilities for character data processing and business use?
A) FORTRAN
B) COBOL
C) PASCAL
D) ADA
E) VORGON

Accepted Answer

COBOL is a programming language specifically designed for business use and data processing. It has limited facilities for mathematical notation but excels in character data processing and business applications.

Question 8

What is the essence of object-oriented programming?
A) versatility
B) objectivity
C) inheritance
D) all of the above
E) removing the human from computer programming

Accepted Answer

Object-oriented programming (OOP) is characterized by its versatility, use of objects, and key concepts like inheritance, encapsulation, and polymorphism.

Question 9

The basic data storage hierarchy consists of (in order from the smallest
upwards):
A) byte, bit, record, file, field and database
B) byte, bit, field, record, database, file
C) bit, byte, field, record, file, database
D) bit, byte, field, file, record, database
E) data, information, knowledge, wisdom

Accepted Answer

The correct order of data storage hierarchy from smallest to largest is: bit, byte, field, record, file, database.

Question 10

A file in database terms is:
A) the field which uniquely identifies a record
B) a collection of related records
C) all the files of an organisation
D) a character of information
E) a collection of meaningful information

Accepted Answer

A file in database terms is a collection of related records, which are organized to store data systematically.

Question 11

In file management systems, the duplication of items of data, so that
they appear in two or more data files is known as:
A) data integrity
B) data redundancy
C) data duplication
D) data manipulation
E) data entry

Accepted Answer

Data redundancy refers to the unnecessary duplication of data in multiple places within a database or data management system.

Question 12

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

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

Question 13

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 14

The Hybrid Network is the best network (e.g.: Ethernet) to have for every organisations.

Accepted Answer

The best network for an organization depends on its specific needs, resources, and goals. Hybrid networks may be beneficial for some, but not necessarily the best choice for all.

Question 15

The logical data structure with a one to many relationship is the:
A) tree structure
B) network structure
C) tabular structure
D) none of the above
E) all of the above

Accepted Answer

A tree structure is a hierarchical data structure that represents a one-to-many relationship, where each node can have multiple children but only one parent.

Question 16

Due to its conceptual simplicity and powerful data manipulation
capabilities, the use of this type of database is increasing in popularity.
A) network structure
B) tree structure
C) graphical structure
D) relational structure
E) a big one

Accepted Answer

Relational databases are popular due to their simplicity and powerful data manipulation capabilities, using tables to store data and SQL for querying.

Question 17

The most widely used application on personal computers today is?
A) databases
B) electronic spreadsheets
C) word processing
D) graphics
E) none of the above

Accepted Answer

Word processing applications are the most widely used on personal computers for tasks such as creating documents, reports, and letters.

Question 18

Which one of the following is NOT a 3rd Generation Computing
A) ASSEMBLER
B) FORTRAN
C) COBOL
D) BASIC
E) ADA

Accepted Answer

ADA is a 4th Generation Computing language.

Question 19

Which of the following is an example of a LAN network topology?
A) The Chain
B) The Plug
C) The Ring
D) The Slot
E) The Ring Pull

Accepted Answer

The Ring is a type of LAN network topology where each computer is connected to two other computers, forming a circular data path.

Question 20

Which is the correct definition of the Open Systems Interconnection
A) Data Link Layer, Transport Layer, Physical Layer, Application Layer, Session Layer, Presentation Layer, Network Layer
B) Transport Layer, Network Layer, Data Link Layer, Presentation Layer, Application Layer, Physical Layer, Session Layer
C) Physical Layer, Data Link Layer, Network Layer, Transport Layer, Session Layer, Presentation Layer, Application Layer
D) Presentation Layer, Transport Layer, Physical Layer, Application Layer, Session Layer, Network Layer, Data Link Layer
E) Physical Layer, Data Link Layer, Network Layer, Transport Layer, Presentation Layer, Session Layer, Application Layer

Accepted Answer

The answer of Which is the correct definition of the...

Quiz 1: Computer Networks, Databases, and Programming Languages

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

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?

Who usually writes computer viruses?

All of the following are types of tangible software except:

Which language is the hardest for humans to write and understand

Which of the following has limited facilities for mathematical notation but has excellent facilities for character data processing and business use?

What is the essence of object-oriented programming?

The basic data storage hierarchy consists of (in order from the smallest upwards) :

A file in database terms is:

In file management systems, the duplication of items of data, so that they appear in two or more data files is known as:

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

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

The Hybrid Network is the best network (e.g.: Ethernet) to have for every organisations.

The logical data structure with a one to many relationship is the:

Due to its conceptual simplicity and powerful data manipulation capabilities, the use of this type of database is increasing in popularity.

The most widely used application on personal computers today is?

Which one of the following is NOT a 3rd Generation Computing

Which of the following is an example of a LAN network topology?

Which is the correct definition of the Open Systems Interconnection