5.0 KiB
Week 3 Practice Quiz: Presentations, Databases & Networks
Q1: Slide Design Best Practice
What is the recommended best practice for text on presentation slides?
A. Include full paragraphs so the audience can read along B. Use short bullet points with key ideas — elaborate verbally C. Use as many fonts and colors as possible to keep the audience interested D. Put all your content on one slide to save time
Answer: B Explanation: Effective slides use short bullet points as visual support while the speaker provides detail. Overcrowded slides cause the audience to read instead of listen, reducing engagement.
Q2: Database Table Structure
In a relational database, what is a "record"?
A. A single column in a table B. A single row in a table, representing one complete entry C. The name of the database D. A type of query
Answer: B Explanation: A record (row) represents one complete entry in a table — for example, one student's information. Columns represent fields (attributes) like name, ID, or email.
Q3: LAN vs WAN
What is the main difference between a LAN and a WAN?
A. LANs are wireless and WANs use cables B. LANs cover a small area like a building; WANs cover large geographic areas C. LANs are faster than WANs because they use newer technology D. WANs are only used by governments
Answer: B Explanation: A LAN (Local Area Network) covers a limited area like a home, office, or school. A WAN (Wide Area Network) spans large distances — the internet itself is the largest WAN.
Q4: DNS Purpose
What does DNS (Domain Name System) do?
A. Blocks malicious websites automatically B. Translates human-readable domain names (like google.com) into IP addresses C. Encrypts all web traffic D. Assigns physical addresses to network cables
Answer: B Explanation: DNS is like the internet's phone book — when you type "google.com," DNS translates it to an IP address (like 142.250.80.46) so your computer can find and connect to the right server.
Q5: CRUD Operations
In database terminology, what does CRUD stand for?
A. Copy, Read, Undo, Delete B. Create, Read, Update, Delete C. Connect, Retrieve, Upload, Download D. Compile, Run, Update, Debug
Answer: B Explanation: CRUD stands for Create, Read, Update, and Delete — the four basic operations you can perform on data in a database. Almost every database application revolves around these actions.
Q6: Router vs Switch
What is the PRIMARY difference between a router and a switch?
A. A router connects different networks together; a switch connects devices within the same network B. A switch is wireless and a router uses cables C. Routers are used at home and switches are only for businesses D. There is no difference — they are the same device
Answer: A Explanation: A switch connects devices within a single local network (like computers in an office). A router connects different networks together (like your home network to the internet) and directs traffic between them.
Q7: Database Queries
What is the purpose of a query in a database?
A. To delete the entire database B. To ask the database a question and retrieve specific data that matches your criteria C. To create a backup of all tables D. To redesign the table structure
Answer: B Explanation: A query lets you search, filter, and retrieve specific information from a database. For example, you could query a student database to find all students with a GPA above 3.5.
Q8: IP Addresses
What does an IP address identify?
A. The brand of computer you're using B. A specific device on a network C. The speed of your internet connection D. The physical location of a cable
Answer: B Explanation: An IP (Internet Protocol) address is a unique numerical label assigned to each device on a network. It's how devices find and communicate with each other — similar to a mailing address for your computer.
Q9: WiFi Standards
What does it mean when a WiFi network is described as "802.11ac" or "WiFi 5"?
A. It can only connect 5 devices at a time B. It refers to the wireless standard/generation, which determines speed and capabilities C. The network costs $5 per month D. It uses 5 different passwords for security
Answer: B Explanation: WiFi standards (like WiFi 5/802.11ac or WiFi 6/802.11ax) define the generation of wireless technology. Newer standards generally offer faster speeds, better range, and improved performance with multiple devices.
Q10: Primary Key
In a database table of students, why would you use a Student ID number as the primary key instead of the student's name?
A. Numbers are always smaller than text in a database B. Names can be duplicated, but a primary key must uniquely identify each record C. Databases cannot store text fields D. Student IDs are required by law to be primary keys
Answer: B Explanation: A primary key must be unique for every record. Two students could share the same name (e.g., two "Maria Garcia"), but each Student ID is unique. This ensures every record can be identified without ambiguity.