Practice Final Questions

Instructions: Please answer all questions to the best of your ability. Note that in E 115, exams are given through Moodle, but these questions are similar to the type you’ll see on exams. Multiple choice style questions are directly on Moodle. Questions with practical aspects (e.g., file upload and answering questions) require you to use the software in this class (including the terminal, file transfer, GitHub, Excel, and text editors).

Please scroll down to the “Practical Questions” section to see what types of practical questions we ask!

Matching Questions

  1. Match Shells to Operating Systems

    • CMD __ (Windows / MacOS and Linux)
    • PowerShell __ (Windows / MacOS and Linux)
    • ZSH __ (Windows / MacOS and Linux)
    • BASH __ (Windows / MacOS and Linux)
  2. Match Web Technologies

    • Used to structure content on a webpage. __ (JavaScript / CSS / HTML)
    • Used to style content on a webpage. __ (JavaScript / CSS / HTML)
    • Used to add interactivity to a webpage. __ (JavaScript / CSS / HTML)
  3. Wireless Std Frequencies (4)

    • 802.11a __ (2.4 Ghz / 5 Ghz)
    • 802.11b __ (2.4 Ghz / 5 Ghz)
    • 802.11g __ (2.4 Ghz / 5 Ghz)
    • 802.11n __ (2.4 Ghz / 5 Ghz)

Multiple Choice Questions

  1. Cables Max Length

    What is the correct order of these cables from longest maximum length (length possible before signal loss is experienced) to shortest?

    • ( ) CAT5 (Twisted Pair Cable), Fiber Optic Cable, Coaxial Cable
    • ( ) CAT5 (Twisted Pair Cable), Coaxial Cable, Fiber Optic Cable
    • ( ) Fiber Optic Cable, Coaxial Cable, CAT5(Twisted Pair Cable)
    • ( ) Fiber Optic Cable, CAT5(Twisted Pair Cable), Coaxial Cable
  2. Center Align Example

    Which of the following should you use to begin a paragraph with its text center-aligned?

    • ( ) <center><p>
    • ( ) <p align=”center”>
    • ( ) <p align=”middle”>
    • ( ) <p “center”>
    • ( ) <p style=”text-align: center”>
  3. Class Selector

    Which of the following lets us identify a group of tags with a selector?

    • ( ) ID
    • ( ) Category
    • ( ) Group
    • ( ) Class
    • ( ) Identify
  4. Counta

    I want to count only the cells within a range that store a mixture of character and numerical data. Which single function would be the best for me to use?

    • ( ) count
    • ( ) counta
    • ( ) countif
    • ( ) sumif
  5. cp File Syntax3

    Which command would copy the file cows.txt from the common/assignments/basicunix directory of the E115 course locker and put it in your home directory? (Assume you are already in the E115 course locker)

    • ( ) cp cows.txt ~/
    • ( ) cp common/assignments/basicunix ~/
    • ( ) cp common/assignments/basicunix/cows.txt ~/
    • ( ) mv common/assignments/basicunix/cows.txt ~/
    • ( ) I cannot copy that file
  6. Device Drivers

    What is the individual piece of software that a kernel uses to interface with a particular piece of hardware?

    • ( ) API
    • ( ) Device driver
    • ( ) GUI
    • ( ) Interface
    • ( ) None of these
  7. DHCP Addressing

    Which of the following automates the assignment of IP addresses, subnet masks, gateways, and other IP parameters?

    • ( ) RDP
    • ( ) VCL
    • ( ) DNS
    • ( ) DHCP
    • ( ) IP
  8. Drivers and Kernel2

    Device drivers contain ___ for the kernel.

    • ( ) instructions
    • ( ) a piece of hardware
    • ( ) a piece of junk
    • ( ) an application
    • ( ) a piece of software
  9. Expansion Slot Additions

    Which of the following can be used as an expansion slot on a computer?

    • ( ) PCI
    • ( ) AGP
    • ( ) PCI-Express
    • ( ) All of these
    • ( ) None of these
  10. Firewall Definition

    Which piece of hardware (or software) is designed to prevent intruders and software alike from entering a computer?

    • ( ) Hub
    • ( ) Firewall
    • ( ) Router
    • ( ) Switch
    • ( ) None of these
  11. Formatting Tags

    Which of the following uses formatting tags to make a few words in the middle of a specific sentence italic, bold and/or underlined?

    • ( ) <strong><em><ins>
    • ( ) <p style=”text-decoration: underline; font-weight:bold; font-style:italic;”>
    • ( ) <p style=”text:strong,em,ins”>
    • ( ) <font bold, italic, underline>
    • ( ) Highlight the word and ctrl + b + u + i
    • ( ) <p><b><i><u></p>

Multiple Answer Questions (Check all that apply)

  1. GUI Input (2)

    Consider a computer that only has a Graphical user interface. How would this computer receive input? Choose all that apply.

    • [ ] Mouse click
    • [ ] Keyboard
    • [ ] Command line
  2. Hex Primary Colors (3)

    In an additive color system (the type used by hex color codes), what are the three primary colors? Choose all that apply.

    • [ ] Red
    • [ ] Green
    • [ ] Yellow
    • [ ] Blue
    • [ ] Orange
    • [ ] Purple
    • [ ] White
    • [ ] Black
  3. ins

    Inserted text tags are used to ____

    • ( ) bold an element
    • ( ) underline an element
    • ( ) emphasize an element
    • ( ) strike through an element
  4. IPv6 Bits

    How many bits are in an IPv6 address?

    • ( ) 32
    • ( ) 64
    • ( ) 128
    • ( ) 256
  5. LAN Definition

    What does LAN stand for?

    • ( ) Local Area Network
    • ( ) Local Area Navigation
    • ( ) Local Average Network
    • ( ) Local Average Navigation
    • ( ) None of these
  6. Link Types (3)

    Select the three types of links. Choose all that apply.

    • [ ] text
    • [ ] picture
    • [ ] email
    • [ ] table
    • [ ] movie
  7. ls Syntax

    Which of the following is NOT a valid example of the List Directory (ls) command?

    • ( ) ls -a
    • ( ) ls
    • ( ) ls ./pathway/to/directory
    • ( ) ls – ~/
  8. Multi-Computer Network

    Which of the following are needed for a network with more than one computer?

    • ( ) Router
    • ( ) Wireless Access Point
    • ( ) Network-based firewall
    • ( ) Ethernet switch
    • ( ) None of these
  9. NAT Definition

    What does NAT stand for?

    • ( ) Natural Address Translator
    • ( ) Network Address Translation
    • ( ) Neural Allocator for Transmutation
    • ( ) Network Addressor Tidbit
    • ( ) Does not stand for anything
  10. Parent and Child

    The users directory in the NFS file tree is considered a…

    • ( ) Root
    • ( ) Parent
    • ( ) Child
    • ( ) Root and Parent
    • ( ) Parent and Child
  11. PCI Express

    Which connects the CPU to the Video Processor?

    • ( ) I/O Device
    • ( ) I/O Slot
    • ( ) PCI Express
    • ( ) A cord
    • ( ) None of these
  12. PS/2

    Before the popularity of USB which port, developed by IBM, was used to connect keyboards and mice?

    • ( ) Parallel
    • ( ) PS/2
    • ( ) Serial
    • ( ) VGA
    • ( ) None of these
  13. Rel Pathname – Home Dir

    What is the pathname for your home directory?

    • ( ) ./
    • ( ) ../
    • ( ) ~/
    • ( ) /
    • ( ) None of these
  14. Rel Pathname – Home Dir3

    What does ~/ stand for?

    • ( ) Home directory
    • ( ) Your friend’s home directory
    • ( ) Parent directory
    • ( ) Your mom’s directory
    • ( ) Current working directory
  15. Scheduling

    What term is used to identify the process in which certain programs have priority for the processor, in other words, sets up a queue?

    • ( ) Multi-tasking
    • ( ) Shell
    • ( ) Control bus
    • ( ) Scheduling
    • ( ) None of these
  16. Security Threat

    What poses the greatest threat to a computer?

    • ( ) virus
    • ( ) spyware
    • ( ) your mother
    • ( ) adware
  17. Serial

    This port was as universal in the 1980’s as the USB port is today.

    • ( ) Serial
    • ( ) PS/2
    • ( ) USB
    • ( ) Parallel
  18. Shareware2

    If you were to buy a new laptop and you received a trial version of Microsoft Office, what kind of license would that be?

    • ( ) Freeware
    • ( ) Shareware
    • ( ) Network
    • ( ) Alpha
    • ( ) Buyware
  19. Styling Example

    Select the appropriate XHTML coding for this: 5210*43

    • ( ) 52<sub>10</sub>*4<sup>3</sup>
    • ( ) 52<sup>10</sup>*4<sub>3</sub>
    • ( ) <sup>52</sup>10*<sub>4</sub>3
    • ( ) None of These
  20. Sum Syntax

    Which of the following is the correct syntax, using a function, for determining how much a given range adds up to?

    • ( ) =count(A9:A29)
    • ( ) =E10+E11+E12+E13+E14+E15+E16+E17+E18+E19…+E29
    • ( ) =sum(E10:E29)
    • ( ) sum(E10:E29)
    • ( ) None of these
  21. Switch Control

    Which of the following devices has more control over which computers receive which data?

    • ( ) Switch
    • ( ) Hub
    • ( ) Node
    • ( ) Mouse
    • ( ) CPU
  22. VGA2

    Which port was used exclusively for video with older monitors?

    • ( ) Modem
    • ( ) Ethernet
    • ( ) VGA
    • ( ) DVI
    • ( ) HDMI
  23. Win 10 + Putty Interface

    Microsoft Windows 10, running Putty, provides what kind of interaction with the user?

    • ( ) GUI-based
    • ( ) Command Line-based
    • ( ) Hybrid (GUI + CLI)
    • ( ) None of these
    • ( ) CLI
  24. Windows FS

    Computers running modern versions of the Microsoft Windows operating system line use what file system as a hierarchy for their files?

    • ( ) FAT32
    • ( ) NTFS
    • ( ) XFS
    • ( ) exFAT
    • ( ) HFS+

Short Answer Questions

  1. IF Output3

    What would be the result of this IF statement (use the image)?

    * Answer: __

  2. Mini-Display Port

    Based on the following image, which port is this?

    * Answer: __

  3. Number of Kernel Services

    How many individual services does a monolithic kernel provide?

    Answer: __

True/False Questions

  1. Backup Rec

    Backing up files is optional and not recommended.

    • ( ) True
    • ( ) False

Practical Questions

Final Exam Practical Practice Problems

  1. Using this template, create a basic webpage in GitHub that is visible at a URL to NC State people. Also upload an image so that the it is visible at the URL.
<html>


<head>
<title>An animal picture</title>
<style type="text/css">
body { max-width:700px; }
</style>
</head>

<body>

<h1>Animals</h1>

<p>Something that resembles a bold <b>paragraph</b>.


<p>We are going to show you an image using the "img" tag with a "src" url
pointing to the image data file, like this 
<p><img src="myimage.jpg">

</body>
</html>

  1. Download this following Excel spreadsheet and answer the following questions
    1. What is the average rating?
    2. What is the earliest review year?
    3. How many unique bean types are there?
  1. Log into remote Eos. Copy the file dracula.txt (/mnt/coe/workspace/csc/admin/e115/common/assignments/basicunix/dracula.txt) from the common E 115 directory to your home directory.
    1. Use wc -l to count the number of lines in dracula.txt
    2. Use grep -c to count the number of instances of “Mina Harker” in dracula.txt.
    3. Use ls to get the size of the dracula.txt file in bytes.