Computer Fundamentals Test 2

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Hbailie
H
Hbailie
Community Contributor
Quizzes Created: 5 | Total Attempts: 745
Questions: 11 | Attempts: 92

SettingsSettingsSettings
Computer Fundamentals Test 2 - Quiz


Questions and Answers
  • 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:
    1. Investigate the problem
    2. Design the solution
    3. Produce the solution
    4. 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?

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Nov 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jun 04, 2012
    Quiz Created by
    Hbailie
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.