112 lines
5.0 KiB
Markdown
112 lines
5.0 KiB
Markdown
# 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.
|