Computer Fundamentals Test 2

1.

What FILES (or tables) might a school database include (select ALL that you think)

A.

Students
B.

Products
C.

Clients
D.

Teaching staff
E.

Non-teaching staff

Correct Answer(s)
A. Students
D. Teaching staff
E. Non-teaching staff

Explanation
A school database would typically include tables for Students, Teaching staff, and Non-teaching staff. These tables would store information such as student details, staff details, attendance records, grades, and other relevant data. The tables for Products and Clients are not typically found in a school database as they are more relevant to businesses or organizations that deal with products and clients.

Rate this question:

2.

Which of these WOULD NOT be a field in a telephone directory database file?

A.

First name
B.

Telephone number
C.

Street
D.

Date of birth
E.

Suburb
F.

Last name

Correct Answer
D. Date of birth

Explanation
A telephone directory database file typically includes fields such as first name, last name, telephone number, street, and suburb. However, the date of birth is not typically included in a telephone directory as it is not relevant or necessary for the purpose of a telephone directory. Therefore, date of birth would not be a field in a telephone directory database file.

Rate this question:

3.

Applying a FILTER in a database table reduces the number of records visible.

A.

True
B.

False

Correct Answer
A. True

Explanation
Applying a FILTER in a database table allows users to specify certain criteria or conditions, which then narrows down the dataset and only displays the records that meet those criteria. This effectively reduces the number of records visible, as only the relevant ones are shown. Therefore, the statement "Applying a FILTER in a database table reduces the number of records visible" is true.

Rate this question:

4.

How can computers and devices be connected in a network?

A.

By a modem
B.

By a network cable
C.

By wireless
D.

All of these
E.

None of these

Correct Answer
D. All of these

Explanation
Computers and devices can be connected in a network by using a modem, which allows them to connect to the internet. Additionally, they can be connected by using a network cable, such as an Ethernet cable, to establish a wired connection. Lastly, they can be connected wirelessly through technologies like Wi-Fi or Bluetooth. Therefore, all of these options are valid methods for connecting computers and devices in a network.

Rate this question:

5.

Which of these IS NOT an advantage of a computer network

A.

Saving electricity
B.

Sharing resources
C.

Sharing programs
D.

Communicating

Correct Answer
A. Saving electricity

Explanation
Saving electricity is not an advantage of a computer network because the power consumption of a network is generally higher than that of individual computers. The main advantages of a computer network include sharing resources, such as printers and storage devices, sharing programs and software applications, and facilitating communication between users. However, saving electricity is not directly related to the benefits of a computer network.

Rate this question:

6.

One advantage of a BUS network is that is uses less cabling

A.

True
B.

False

Correct Answer
A. True

Explanation
A BUS network is a type of computer network where all devices are connected to a single cable called a bus. This design allows for the use of less cabling compared to other network topologies like a star network, where each device requires a separate cable to connect to a central hub. In a BUS network, devices can simply tap into the main bus cable, reducing the overall amount of cabling required. Therefore, the statement that a BUS network uses less cabling is true.

Rate this question:

7.

This is a drawing of a

A.

Bus network
B.

Star network
C.

Peer-to-peer network
D.

None of these

Correct Answer
B. Star network

Explanation
The drawing represents a star network because it shows multiple nodes connected to a central hub or switch. In a star network, all communication between nodes is routed through the central hub, which allows for efficient and centralized control of data flow. This type of network is commonly used in Ethernet networks, where each device is connected to a central switch or router.

Rate this question:

8.

Which type of network is unaffected if one of the computers on it fails?

A.

Bus network
B.

Star network

Correct Answer
B. Star network

Explanation
A star network is unaffected if one of the computers on it fails because it operates on a centralized architecture. In a star network, all computers are connected to a central hub or switch, and communication between computers is routed through this central point. If one computer fails, the rest of the network can still function normally as the failure is isolated to that particular computer. Other computers can continue to communicate with each other through the central hub without any disruption. This makes the star network more reliable and fault-tolerant compared to other types of networks like a bus network where a failure in one computer can disrupt the entire network.

Rate this question:

9.

The four stages of the design process are:

Investigate the problem

Design the solution

Produce the solution

Evaluate the solution

Imagine you are a website developer and your next job is to set-up a website for Jim who runs a lawnmowing and gardening business. What would you do at each stage of the design process in this job?