BCA Semester 1 – Computer Fundamentals and Applications () Questions & Answers | Past TU Exam Papers

Question 1

Differentiate between primary and secondary memory.

Marks: 5

Year: 2019 Final TU FOHSS

| Aspect | Primary Memory | Secondary Memory | |--------|----------------|------------------| | Nature | Volatile (loses data when power off) | Non-volatile (retains data) | | Speed | Very fast access

Question 2

Define database? Explain the advantages of database over file based system.

Marks: 5

Year: 2019 Final TU FOHSS

A database is an organized collection of structured data stored electronically in a computer system, managed by a Database Management System (DBMS). Advantages of Database over File-Based System: 1. D

Question 3

Who is a database administrator? Explain the major roles and responsibilities of DBA.

Marks: 5

Year: 2020 Final TU FOHSS

A Database Administrator (DBA) is a professional responsible for managing, maintaining, and securing an organization's database systems. The DBA ensures the database operates efficiently and remains a

Question 4

What is DBMS? Explain the Relational database model with a suitable diagram.

Marks: 5

Year: 2020 Final TU FOHSS

Database Management System (DBMS): DBMS is software that provides an interface to create, manage, and manipulate databases. It allows users to store, retrieve, update, and delete data efficiently whil

Question 5

Who supervises the databases in the organization? What tasks and obligations are under the scope of the database administrator?

Marks: 5

Year: 2022 Final TU FOHSS

1. Who Supervises Databases in an Organization? The Database Administrator (DBA) is the person responsible for supervising and managing the organization’s databases. The DBA ensures that data is sec

Question 6

What is DBMS? Explain the advantages of DBMS over flat-file system.

Marks: 5

Year: 2023 Final TU FOHSS

1. Definition of DBMS A Database Management System (DBMS) is a software system that allows users to store, manage, retrieve, and manipulate data in a structured way. - Provides an interface between

Question 7

Why do we need to use DBMS? How does relational model represent both data and relationship among those data? Explain.

Marks: 5

Year: 2024 Final TU FOHSS

1. Why Do We Need to Use DBMS? A Database Management System (DBMS) is required to manage data efficiently and effectively. The main reasons are: 1. Data Redundancy Reduction - Avoids storing the