Lesson 8



Introduction to Database Management System

    👉Text Books PDF
    👉MCQ Online Exam
    👉MCQ Answer
    👉Paid Answer (For Membership User)


1. What is a Database Management System (DBMS)? (Database Management System (DBMS) কি?)
Answer: A DBMS is software that allows users to create, store, manage, and retrieve data efficiently. It organizes data in a structured format and provides tools for data manipulation.
(DBMS হল এটা সফ্টৱেয়াৰ যি ডাটা সংৰক্ষণ, ব্যৱস্থাপনা, আৰু পুনৰুদ্ধাৰ কৰিবলৈ সহায় কৰে।)

2. What is the difference between a Database and a DBMS? (Database আৰু DBMS-ৰ মাজত পাৰ্থক্য কি?)
Answer: Database: A collection of related data stored together.
DBMS: Software used to manage and access the database.
(Database হল ডাটাৰ সমাহাৰ, DBMS হল ডাটা ব্যৱস্থাপনা কৰাৰ বাবে ব্যৱহৃত সফ্টৱেয়াৰ।)

3. What are the advantages of using a DBMS? (DBMS ব্যৱহাৰৰ সুবিধা কি?)
Answer: Reduces data redundancy.
Ensures data consistency.
Provides data security and integrity.
Allows multiple users to access data simultaneously.
(DBMS-এ ডাটা পুনৰাবৃত্তি কমায়, ডাটা নিৰ্ভুলতা ৰাখে, আৰু ডাটা সুৰক্ষিত ৰাখে।)

4. What is a table in a DBMS? (DBMS-ত Table কি?)
Answer: A table is a collection of rows and columns that store related data.
Each row is called a record and each column is called a field.
(Table হল Row আৰু Column-এৰে গঠিত ডাটাৰ সংৰক্ষণ স্থান।)

5. What is a primary key? (Primary Key কি?)
Answer: A primary key is a unique identifier for each record in a table.
It ensures that no two rows have the same value in the key field.
(Primary Key হল এটা Table-ৰ বিশেষ চিনাক্তকৰণ যি প্ৰতিটো Row-ৰ অনন্যতা নিশ্চিত কৰে।)

6. What is a foreign key? (Foreign Key কি?)
Answer: A foreign key is a column in one table that refers to the primary key in another table. It establishes a relationship between two tables.
(Foreign Key হল এটা টেবুলৰ Column, যি আন টেবুলৰ Primary Key-ৰ সৈতে সম্পৰ্ক স্থাপন কৰে।)

7. What is data redundancy? (Data Redundancy কি?)
Answer: Data redundancy means storing the same data multiple times, leading to data duplication. DBMS reduces data redundancy.
(Data Redundancy হল একেটা ডাটা একাধিকবাৰ সংৰক্ষণ হোৱা।)

8. What is data integrity in DBMS? (DBMS-ত Data Integrity কি?)
Answer: Data integrity ensures the accuracy and consistency of data in a database.
It prevents invalid or incorrect data entry.
(Data Integrity হল ডাটাৰ নিৰ্ভুলতা আৰু স্থিৰতা বজাই ৰখা।)

9. What are the different types of DBMS? (DBMS-ৰ প্ৰকাৰসমূহ কি?)
Answer: Hierarchical DBMS: Data is organized in a tree-like structure.
Network DBMS: Uses a graph-like structure.
Relational DBMS: Uses tables to organize data.
Object-oriented DBMS: Stores data as objects.
(Hierarchical, Network, Relational, আৰু Object-oriented DBMS-ৰ প্ৰধান প্ৰকাৰসমূহ।)

10. What is SQL? (SQL কি?)
Answer: SQL (Structured Query Language) is used to interact with and manage data in a DBMS. It allows users to create, update, delete, and retrieve data from databases.
(SQL হল ডাটাবেইচ ব্যৱস্থাপনা কৰিবলৈ ব্যৱহৃত ভাষা।)

11. What is normalization in DBMS? (DBMS-ত Normalization কি?)
Answer: Normalization is the process of organizing data to reduce redundancy and improve data integrity. It divides large tables into smaller, related tables.
(Normalization হল ডাটা পুনৰাবৃত্তি কমাই ডাটা নিৰ্ভুলতা বজাই ৰখাৰ প্ৰক্ৰিয়া।)

12. What is a query in DBMS? (DBMS-ত Query কি?)
Answer: A query is a request to retrieve specific information from a database.
It allows filtering, sorting, and extracting data.
(Query হল ডাটাবেইচৰ পৰা নির্দিষ্ট তথ্য উলিয়াই অনাৰ অনুৰোধ।)

13. What is the difference between DDL and DML? (DDL আৰু DML-ৰ মাজত পাৰ্থক্য কি?)
Answer: DDL (Data Definition Language): Used to define the structure of the database (e.g., CREATE, ALTER).
DML (Data Manipulation Language): Used to manipulate data (e.g., SELECT, INSERT, UPDATE).
(DDL ডাটাবেইচৰ গঠন সংজ্ঞা দিয়ে, DML ডাটাবেইচৰ তথ্য সম্পাদনা কৰে।)

14. What is a relational database? (Relational Database কি?)
Answer: A relational database organizes data into tables (relations) with rows and columns. It uses keys to establish relationships between tables.
(Relational Database-এ Table-ৰ আকাৰত ডাটা সংৰক্ষণ কৰে আৰু Key-ৰ জৰিয়তে সম্পৰ্ক স্থাপন কৰে।)

15. What are the functions of DBMS? (DBMS-ৰ কাৰ্য কি?)
Answer: Data storage and retrieval.
Data security and integrity management.
Multi-user accessibility.
Backup and recovery.
(DBMS-এ ডাটা সংৰক্ষণ, সুৰক্ষা, আৰু পুনৰুদ্ধাৰ কৰা কাম কৰে।)


EDIT BY : KRISHNA  SAIKIA