Computer Fundamentals Test 2

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.

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.

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.

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.

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.

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.

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.

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.