📝 5th Semester Solved Question Paper 🎓 TDC GECA (CBCS)

This is speciality for 📝 5th Semester TDC GECA (CBCS) GE-5 Solved Question Paper 🎓 but all of the computer science students are read this for your exams.

📖 Subject: Computer Applications
📜 Paper: GE-5 (IT Fundamentals)

🔹 Section A: Answer the following questions briefly (1×10=10)

1. What is a Digital Signal?

A digital signal consists of discrete values (0s and 1s) used in digital communication and computing, representing data in binary format.

2. What is a Bar Code in Computer Science?

A barcode is a machine-readable code consisting of parallel lines or patterns that store data, commonly used for product identification.

3. What is Virtual Memory?

Virtual memory is a memory management technique where a part of the hard disk is used as RAM to extend the system's memory capacity.

4. What is a Primary Key?

A primary key is a unique identifier in a database table that ensures no duplicate records exist.

5. What is an IP Address?

An IP address is a unique numerical label assigned to devices in a network, enabling communication over the internet.

6. What is Indexing in Search Engines?

Indexing is the process where search engines store and organize website data to provide fast and relevant search results.

7. Give one example of a data analysis tool.

One common data analysis tool is Microsoft Excel, used for data visualization and statistical analysis.

8. What is a Firewall?

A firewall is a security system that monitors and controls incoming and outgoing network traffic to prevent unauthorized access.

9. What is Heterogeneous Storage?

Heterogeneous storage combines different types of storage systems (HDDs, SSDs, and cloud storage) to optimize performance and cost.

10. What does BCC stand for in Email?

BCC (Blind Carbon Copy) allows users to send emails to multiple recipients without revealing other recipients’ addresses.

---

🔹 Section B: Differentiate between the following (4×2=8)

1. Primary Memory vs. Secondary Memory

Feature	Primary Memory (RAM)	Secondary Memory (HDD/SSD)
Speed	Very fast	Slower
Volatility	Temporary storage	Permanent storage
Accessibility	Directly used by CPU	Requires retrieval

2. Internet vs. Intranet

Feature	Internet	Intranet
Access	Open to everyone	Restricted to an organization
Security	Less secure	More secure
Purpose	Global communication	Internal collaboration

---

🔹Section C: Answer any five of the following questions (5×5=25)

1. What are the main components of a computer system? Explain the primary function of each component.

A computer system consists of:

• CPU (Central Processing Unit): The brain of the computer, processes data.

• Memory (RAM): Temporarily stores active data for quick access.

• Storage (HDD/SSD): Permanently stores data and files.

• Input Devices: Devices like keyboards and mice for user interaction.

• Output Devices: Devices like monitors and printers that display results.

2. How does a Star Topology work? What are its primary benefits?

A star topology connects all devices to a central hub or switch. Benefits: ✔ Easy troubleshooting
✔ High performance
✔ Scalable network

3. What is meant by User Interface? Explain various types of user interfaces of an OS.

A user interface (UI) is the medium through which users interact with a computer. Types:

• Graphical User Interface (GUI): Uses icons and windows (e.g., Windows, macOS).

• Command Line Interface (CLI): Text-based commands (e.g., Linux Terminal).

• Menu-Driven Interface: Users navigate using menus.

• Touch-Based Interface: Found in smartphones and tablets.

4. What is Transmission Media in a Computer Network? Explain various types of transmission media.

Transmission media are the channels used for data transfer. Types:

• Wired: Twisted pair, coaxial, fiber optic.

• Wireless: Wi-Fi, Bluetooth, radio waves.

5. List the benefits and drawbacks of online education.

✅ Benefits:

• Flexible learning schedule

• Accessibility from anywhere

• Lower costs ❌ Drawbacks:

• Lack of face-to-face interaction

• Requires strong self-discipline

6. Discuss the role of an operating system in managing hardware resources and providing services to applications and users.

An Operating System (OS) manages computer hardware and software. It:

• Allocates memory and processor resources.

• Provides a user interface for interaction.

• Manages security and system processes.

---

🔹 Section D: Answer any two of the following questions (5×2=10)

1. What is a relationship in a database, and how does it connect different entity sets?

A relationship in a database connects different tables based on a common field. Example:

• A Student table can be linked to a Courses table via an Enrollment table.

2. How do you write a basic SQL query to retrieve all columns from a table? Provide an example.

To fetch all records from a table, use:

SELECT * FROM students;

This command retrieves all student records from the database.

---

🎯 Hope this solved paper helps you in your preparation! Keep practicing and excel in your exams. 🚀

📢 For more solved papers, study materials, and tech insights, visit TechnicalRelated4U!