Question 1

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, resembling a tree with nodes representing data points and branches representing relationships.

Question 2

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 3

The database administrator is, in effect, the co-ordinator between the
_________________ and the ________________________
A) DBMS; database
B) application programs, users
C) database; users
D) application programs; database
E) none of the above

Accepted Answer

The answer of The database administrator is, in effect, the...

Question 4

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 organize data and SQL for querying.

Question 5

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, as they are essential for creating, editing, and formatting text documents.

Question 6

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 development of computer programming languages aims to achieve all these goals: making programming accessible to end users, automating programming processes, ensuring reliability, ease of maintenance, portability, and compatibility across different systems.

Question 7

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 8

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

Accepted Answer

In binary code, the number 12 is represented as 1100.

Question 9

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

Accepted Answer

A ring topology is a network topology in which each node is connected to two other nodes, forming a ring. Data is passed from node to node around the ring, and each node has the opportunity to process the data before passing it on to the next node.

Question 10

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

Question 11

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 12

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

Accepted Answer

The statement is not necessarily true as the "best" network for an organization depends on various factors such as the size of the organization, the nature of its operations, its budget, and its specific needs and requirements. While a hybrid network, which combines different types of networks (like Ethernet, wireless, etc.), can offer flexibility and scalability, it may not always be the most cost-effective or efficient solution for every organization. Some organizations might benefit more from a simple Ethernet network, while others might require a more complex network setup. Therefore, it's important for each organization to assess its own needs and circumstances before deciding on the most suitable network.

Question 13

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 14

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 Database Management System (DBMS) is a software that helps users create, store, change, sort, and retrieve data.

Question 15

What is not a function of a Database administer
A) resolution of any interdepartmental conflict
B) design of the logical models (ERD's & DFD's)
C) makes on his own the decision to purchase database software
D) preparation and revision of appropriate documentation
E) setting up and monitoring of data security procedures

Accepted Answer

The resolution of interdepartmental conflict is not typically a function of a Database Administrator. Their primary responsibilities include database design, documentation, software decisions, and data security.

Question 16

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 listed options are advantages of the database approach, including elimination of data redundancy, ability to associate related data, increased security, and program data independence.

Question 17

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 18

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 is the duplication of items of data, so that they appear in two or more data files.

Question 19

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 most spreadsheet programs. While it is possible to create an audit trail using certain functions or add-ons, it requires additional setup and is not automatically provided.

Question 20

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

Quiz 1: Computer Networks, Databases, and Programming Languages

Which database structure arranges data in some natural hierarchy?

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

The database administrator is, in effect, the co-ordinator between the _ and 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?

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

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

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

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

Which is the correct definition of the Open Systems Interconnection

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

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

A database is an organised collection of data

A Database Management System has the following characteristics?

What is not a function of a Database administer

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

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

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

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

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

Quiz 1: Computer Networks, Databases, and Programming Languages

Which database structure arranges data in some natural hierarchy?

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

The database administrator is, in effect, the co-ordinator between the _________________ and 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?

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

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

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

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

Which is the correct definition of the Open Systems Interconnection

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

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

A database is an organised collection of data

A Database Management System has the following characteristics?

What is not a function of a Database administer

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

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

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

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

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

The database administrator is, in effect, the co-ordinator between the _ and the ________