Class 10 Database Management important questions Session 2022-2023

Hello student in this article we will discuss very important question related to Database management system. These question are very important for your Class 10 Board Examination. Session 2022-2023. You have to learn this question and you will get  10-12 Marks out of 12 Marks from this Section. Soon We will share more question based on Case Study or Competency Based question. Till now learn these question and ask your doubt by writing in comment section.

What is database? What is its significance?
A database is a collection of logically relate data. The database systems store data centrally at ne place where from all applications can get the data required. 

The centralized storage facilitates many advantages like:

• Controlled Redundancy
• Data Sharing
• Data consistency
• Standardization
• Enhanced data Security.

 

What do you understand by tables in database management system?
In a database management system various types of object together manage and maintain the system. Tables are one of them. A table is a storage container that stores data pertaining to single object, subject or purpose. 

What is difference between a flat database and relational database?

• In a flat database, all the data is stored in a single file    e.g. a spreadsheet.
• In a Relational database data is stored in multiple tables linked via common fields  e.g. Base of OpenOffice.org is relational database.

What is primary key?

A primary key is a field that uniquely identifies the records in a table.

What is a key difference between a foreign key and a primary key?

A foreign key is a filed or fields that refer to a primary key of another table while primary key is a field in table that uniquely identifies each record in a table.

What is a database management system?

A software package which can be used to manipulate, validate and retrieve this database is called a Database Management System.

What is the purpose of the Database Management System?

Major Organisations choose to work using the Database Management System because it helps the user and the administrator easily manage the data and information on the database. The ultimate purpose of a DBMS is to store and transform data into information to support making decisions.

What are the components of the database management system?

The database management system can be divided into four major components, they are DATA, User, Hardware and Software.

What is a Database?

A collection of information which is managed such that it can be updated and easily accessed is called a database.

What are the types of the database management system?

There are 4 important types of Database Management System, which are as follows:

• Network Database
• Hierarchical Database
• Relational Database
• Object-Oriented Database

Important Terms related to Database Management System

• Data Manipulation Languages (DML)
• Structured Query Language (SQL) 
• Data Definition Language (DDL) 
• Transcation Control language (TCL)
• Primary Key . 
• Foreign Key .
• Table/Relational.
• Query.

 Advantages of using a Database Management System:

• It allows multi-users to operate the database at a single time, making it more efficient
• Securing the data is easy. The administrator can restrict the usage of the database to a few people only. 
• A single file can manage the entire database which is why duplicity and redundancy cannot happen. This makes the data more consistent and easy to update
• Since tables can be created in DBMS, interrelating the data and elements with each other is convenient
• The backup and recovery of data is managed by the software, which ensures that the database is secure at all times