TU BCA 1st Semester – Computer Fundamentals and Applications Model Question Paper Set 2

Note: All questions are compulsory.

(Each question carries 5 marks)
Answer the following questions briefly.

What do you understand by computer memory? Differentiate between RAM and ROM.
Define the term “Peripheral Device” and give examples of input and output devices.
Explain the concept of “Booting” in a computer system.
Discuss the various types of software in a computer system with examples.
What are the primary functions of an operating system?
Differentiate between the “File” and “Folder” in a computer system.
What is the role of a database management system (DBMS)? Explain with an example.
Explain the concept of “Cloud Computing” and mention its advantages.
What are the different types of computer viruses? Give examples of each type.
Define the term “Data Communication” and explain the types of communication modes.

(Each question carries 10 marks)
Answer the following questions in detail.

Discuss the role of the Control Unit and the Arithmetic Logic Unit (ALU) in the CPU. How do they interact to perform computational tasks?
Explain the different types of memory hierarchy in a computer system. Discuss the characteristics of primary and secondary memory devices.
What is the difference between a compiler and an interpreter? Explain their working with examples.
Explain how the Windows Operating System handles processes. Discuss the concept of multi-tasking and process scheduling.
Describe the structure of a Database. What are the advantages of using a Relational Database Management System (RDBMS)?
What are the different types of computer networks based on scale and topology? Discuss in detail the LAN, WAN, and MAN networks with suitable examples.
Define and explain the concept of HTML. Write a simple HTML code to display a webpage with a heading, a paragraph, and an image.
Describe the key components and working of the Internet. Explain the role of IP Addressing, DNS, and Web Browsers in internet communication.

(Each question carries 10 marks)
Answer the following practical questions.

Case Study:
A company is setting up a computer network for its office. The office consists of 4 departments, each with 15 employees. Suggest an appropriate network topology and explain why you would recommend it. What hardware would you need to set up the network?
Create a simple flowchart and pseudocode for calculating the sum of the first 100 natural numbers.
Write a short procedure on how to install a printer in a Windows operating system. Include steps for troubleshooting any common installation issues.
Practical Task:
- Create a spreadsheet in Microsoft Excel containing data for the following:
  - Name of employees, department, salary, and joining date.
  - Perform the following operations:
    - Calculate the total salary of all employees.
    - Find the average salary.
    - Sort the data by department.

(Total 20 marks)
This section is based on activities throughout the semester and will be evaluated based on the following:

Classroom Quiz or MCQs (5 marks): Multiple-choice or short-answer questions based on topics such as operating systems, hardware, software, and networking.
Practical Assignment (5 marks): Any task or project involving the use of a word processor, spreadsheet software, or database application.
Lab Work/Project (5 marks): A mini-project or assignment on a specific topic, such as creating a basic webpage, setting up a small local area network, or writing simple code in a programming language.
Presentation (5 marks): A presentation on a given topic related to computer fundamentals, operating systems, or internet technologies, including visual aids and explanation.

All questions are compulsory.
Write your answers in a clear, organized manner with proper headings and sub-headings.
Use diagrams where necessary, especially for technical explanations such as network topologies and memory hierarchies.
Ensure your practical work is well documented and demonstrates clear understanding.

Computer Hardware and Software: Understand the different components of a computer system and how they function.
Operating System Basics: Focus on memory management, process scheduling, and file handling.
Database Systems: Grasp the concepts of DBMS, RDBMS, and database management tools.
Networking: Study different network topologies, types, and communication methods.
Practical Skills: Be familiar with basic tasks such as file handling, working with spreadsheets, and using operating system utilities.
Case Studies and Applications: Apply theoretical knowledge to real-world scenarios such as setting up networks, troubleshooting hardware, and creating basic software applications.

Published by Admin