Teachers and Examiners collaborated to create the Database Management System Class 10 Questions and Answers. All the important Questions and Answers and taken from the NCERT Textbook Information Technology 402.
Database Management System Class 10 Questions and Answers
Session 1: Appreciate Concept of Database Management System
1. What is a database?
Answer – A database is an organized collection of data. Databases can store, retrieve and manage large amounts of data. The database stores the information in the form of a table.
2. What is the purpose of a Database Management System?
Answer – A database management system (DBMS) is a software package which manages and maintains data in a database. A DBMS enables several user application programs to access the same database at the same time. It enables organizations to easily create databases for a variety of purposes. A database is a comprehensive collection of data records, files, and other items.
3. How is data organized in a database?
Answer – There are two way to organized data in database –
a. Flat File – It stores the data in a single table and it is suitable for small amounts of data.
b. Relational – It stores the data in a multiple table and all the tables are connected to each other using a common field with the help of relationships.
4. What do you mean by Database Servers?
Answer – Database servers are powerful computers that store and manage data on a server. This type of server is dedicated to a single purpose and helps to hold the database and run only DBMS and related software.
5. Give the Advantages of database?
Answer – Advantages of database are –
a. Reduce Data Redundancy – When the same data set is stored in two or more locations, this is referred to as data redundancy. As a result, this helps in the protection of duplicate data in a database.
b. Sharing of Data – Databases can share the data with multiple users at a time. There are multiple levels of authorization to access the data, and as a result, the data can only be shared with those who are permitted.
c. Data Integrity – The term “data integrity” refers to the accuracy and consistency of the data in the database. Data integrity also refers to data safety.
d. Data Security – You know that data is very important, databases give privileges to authorized users and allow them to access the database using username and password.
e. Privacy – A database’s privacy rule says that only authorized users are permitted to access the database in accordance with its privacy constraints. For example – if you log in your Gmail account then you will see your email only, you will not see any other account email.
f. Backup and Recovery – Backup and recovery are handled automatically by the Database Management System.
g. Data Consistency – Data consistency ensures the modification in the data will be the same for all the users who are accessing the database. For example if you have registered a train ticket from IRCTC website then whatever changes are there it will be the same for all the users who are trying to reserve the ticket.
Database Management System Class 10 Questions and Answers
6. What are the key features of a database?
Answer – Some of the key features of database are –
a. Multiple table can be store in a single database
b. Database can share the data to multiple users
c. Database can create backups automatically
d. Database save storage space
e. Large amount of data can be managed by database
f. Each table in a database contains separate information
g. Provides high level security
7. What is RDBMS?
Answer – RDBMS stands for Relational Database Management System is an upgraded version of DBMS, RDBMS stores the data in the form of a table. In RDBMS multiple tables can be linked together, and support multiple users to access the database.
8. What different types of keys are available in RDBMS?
Answer – The different keys available in RDBMS are –
a. Primary Key (PK) – A primary key is a unique value that identifies a row in a table. If the primary key is defined to any table column it means the duplication will be not allowed.
b. Composite Primary Key – When a primary key is applied to one or more columns in the same table is known as Composite Primary Key.
c. Foreign Key (FK) – By default columns are foreign key, foreign key points to the primary key of another table.
Database Management System Class 10 Questions and Answers
Session 2: Create and Edit tables using wizard & SQL commands
9. What are the different database objects?
Answer –
a. Table – A table is a collection of data components structured in the form of vertical columns and horizontal rows.
b. Columns / Fields / Attributes – Columns or Fields or Attributes all are the same, A column is a collection of data values of a single data type, one for each row in a table. It is also known as the heading of the column.
c. Rows / Records / Tuples – A row, also known as a Record or Tuple, is a single data item in a table. A database table can be represented as a series of rows and columns or fields. Each row in a table represents a set of related data, and each row has the same structure.
10. What are data types?
Answer – Datatypes are used to define the type of data that will be stored in the database. Data types in the OpenOffice base are classified into five types.
a. Numeric Types – Numeric data types are used to describe numerical values for fields in a database table. Numeric data types used for numbers and decimals.
Some of the important numeric data types are –
a. Boolean
b. Integer
c. Numeric
d. Decimal
e. Float
f. double
b. Alphanumeric Types – Alphanumeric data types are used to describe character values for fields in a database.
Some of the important alphanumeric data types are –
a. Longvarchar
b. Char
c. Varchar
d. Varchar_ignorecase
c. Binary Types – For storing data in binary formats, binary data types are used. Binary data types in a database can be used to store images, music files, and so on.
Some of the important Binary data types are –
a. Varbinary
b. Binary
c. Longvarbinary
d. Date time – Date and time data types are used to describe date and time values for fields in a database table.
Some of the important Date time data types are –
a. Date
b. Time
c. Timestamp
11. In how many ways tables can be created in Base?
Answer – There are two different ways to creating the table in database –
a. Using Design View
b. Using Wizard
12. Define the structure of a table.
Answer – A table is a collection of data components structured in the form of vertical columns and horizontal rows.
13. Differentiate between Tuples and Attributes of a table.
Answer – Tuple is a single data item in a table. A database table can be represented as a series of rows and columns or fields.
An attribute is a collection of data values of a single data type, one for each row in a table.
Database Management System Class 10 Questions and Answers
Session 3: Perform Operations on Table
14. What is referential Integrity?
Answer – Referential integrity is used to keep data maintained, accurate and consistent.
Data in Base can be connected between two or more tables using primary key and foreign key constraints.
Referential integrity helps to –
a. If there is no connected record in the main key table, records are added to a related table.
b. Changing values in a primary if there are any dependent records in the linked table
c. If there are any matching linked records in an associated table, records from a primary key table are deleted.
15. What is the advantage of relationships between two tables?
Answer – Advantage of relationships between two tables are –
a. Save time as there is no need to enter the same data in separate tables.
b. Reduce data-entry errors.
c. Summarize data from related tables.
16. What is the file extension for databases created using OpenOffice.Org Base?
Answer – Extension for OpenOffice base is .odb.
17. List any three file formats that can be managed using OpenOffice.Org Base?
Answer – The three file formats are –
a. .odt – This file format use for create digital document file
b. .odd – This file format use for create spreadsheet
c. .odp – This file format use for creating presentation file
18. How many types of relationships can be created in Base? Explain each of the them.
Answer – There are three types of relationships –
a. One to One – Both tables in this relationship must have primary key columns.
b. One to Many or Many to One – One of the tables in this relationship must have a primary key column.
c. Many to Many – The primary key column is not present in any of the tables in this relationship.
19. What do you mean by Sorting? In how many ways it can be done?
Answer – Sorting means arranging the data in ascending or descending order.
The two way to arranging the data is –
a. Ascending
b. Descending
20. Explain Referential Integrity with the help of an example.
Answer – Referential integrity is used to keep data maintained, accurate and consistent.
Data in Base can be connected between two or more tables using primary key and foreign key constraints.
For example – Suppose there is two table “Student_details” and “fee_details”,
in the student_detils table fields are –
Grno, Student_name, Address, phone_number ( here Grno is primary key)
In the Fee_details table fields are –
Grno, Fee_date, Amount (here Grno is foregn key)
Here, both have a common field “Grno” this is known as referential Integrity.
Database Management System Class 10 Questions and Answers
Session 4: Retrieve data using Query
21. How many types of language are there in the database?
Answer – Three are two types of languages –
DDL (Data definition language) – Data definition language is used to design and modify the structure of a database.
Common DDL commands are
a. Create – This command is used to create database
b. Alter – This command is used to modify the database.
c. Drop – This command is used to delete database tables.
DML (Data manipulation language) – Data manipulation language provides commands for manipulating data in databases.
Common DML commands are
a. Select – This command is used to display information from the database.
b. Insert – This command is used to insert new records in the database.
c. Delete – This command is used to delete records from the database.
d. Update – This command is used to modify records in the database.
22. Name DML commands.
Answer – Data manipulation language (DML) access and manipulate data in existing tables.
Name of DML commands –
a. Select
b. Insert
c. Update
d. Delete
23. What is the purpose of using queries?
Answer – Queries are commands that describe the data structure as well as manipulate the data in the database. The purpose of a query is to do calculations, integrate data from many tables, and add, alter, or delete data from a database.
24. Which clause of Select statement helps to display specific data?
Answer – Where clause is used to display specific data from the database.
25. Differentiate between Where clause and Orderby clause of SQL statements.
Answer – Where clause is used to display specific data from the database and Orderby used to display data in ascending order or descending order.
26. State the purpose of Update Command with the help of an example.
Answer – The update statement is used to modify records in the table. Example of update command is – Update Student_details set Location = ‘Pune’ where Rollno = 10;
Database Management System Class 10 Questions and Answers
27. Consider the following table “Teachers”
Rollno | Student_Name | DOB | Address | Mobile_no | Gender | Percentage |
|---|---|---|---|---|---|---|
1 | Jugal | 10/01/2003 | Mumbai | 5555555555 | M | 98 |
2. | Pratigya | 24/03/2002 | Pune | 4444444444 | F | 82 |
3 | Sandeep | 12/12/2003 | Delhi | 8888888888 | M | 91 |
4 | Sangeeta | 01/07/2004 | Banglore | 6666666666 | F | 96 |
5 | Satti | 05/09/2002 | Mumbai | 7777777777 | M | 89 |
Write SQL commands:
a. To display all the information from the table whose address is ‘Mumbai’.
Answer – Select * from students where address = “Mumbai”;
b. To list the details of all the students whose percentage is between 90 to 100.
Answer – Select * from students where percentage >= 90 and percentage <= 100;
c. To display the name of all the students whose gender is Female.
Answer – Select Subject from students where Gender = ‘F’;
d. To display the list of names of all the students in alphabetical order.
Answer – Select * from students order by Student_name;
Database Management System Class 10 Questions and Answers
29. Write the SQL commands to answer the queries based on Fabric table
FabricID | Fname | Type | Disc |
F001 | Shirt | Woolen | 10 |
F002 | Suit | Cotton | 20 |
F003 | Tunic | Cotton | 10 |
F004 | Jeans | Denim | 5 |
a. Write a query for insert the following record
(“F005”, “Kurta”, “Woollen”,5)
Answer – insert into Fabric values (‘F005’, ‘Kurta’, ‘Woolen’,5);
b. Write a query to display only those fabric whose disc is more than 10
Answer – select * from Fabric where Disc>10;
c. To display those record whose type is ‘Woolen’
Answer – select * from Fabric where type = ‘Woolen’;
d. To modify the fabric shirt by increasing discount by 10
Answer – update fabric set Disc = Disc + 10 where Fname = ‘Shirt’;
e. To delete the record of fabric F003 from table
Answer – delete from Fabric where FabricID =‘F003’;
Database Management System Class 10 Questions and Answers
30. Consider the following Vendor table and write the queries
VendorID | VName | DateofRegistration | Location |
|---|---|---|---|
V001 | Mother Dairy | 20-01-2009 | Delhi |
V002 | Havmor | 01-04-2015 | Gujrat |
V003 | Amul | 12-05-2012 | Kolkata |
V004 | Kwality Walls | 15-10-2013 | Mumbai |
a. Write a Query to display all records
Answer – Select * from Vendor;
b. Write a Query to add a new row with the following details
(„V005‟, „Vadilal‟, „2010-03-20‟, „Pune‟)
Answer – Insert into Vendor values (“V005‟, “Vadilal‟, “2010-03-20‟, “Pune‟);
c. Write a query to modify the location of V003 from Kolkata to Gujrat
Answer – Update Vendor Set location= “Gujrat‟ Where location= “Kolkata‟;
Database Management System Class 10 Questions and Answers
31. Consider the following table “ITEM”:
Itemno | Iname | Price | Quantity |
11 | Soap | 40 | 80 |
22 | Powder | 80 | 30 |
33 | Face cream | 250 | 25 |
44 | Shampoo | 120 | 100 |
55 | Soap box | 20 | 50 |
a. Display the total amount of each item. The amount must be calculated as the price multiplied by quantity for each item.
Answer – Select price * quantity from item;
b. Display the details of items whose price is less than 50.
Answer – Select * from item where price < 50;
32. Identify the columns and data types of a table: Airlines. Mention at least four columns with data type.
Answer –
Columns Data type
Flight No Text
No.of Passengers Integer
Airlines Text
Arrival_Time Date/Time
Departure_Time Date/Time
Fares Float
33. Identify the columns and data types of a table: Students. Mention at least four columns with data type.
Answer –
Columns Data type
RollNo Integer
Student_name Varchar(20)
Father_name Varchar(20)
Mother_name Varchar(20)
Address Varchar(50)
DOB Date
Database Management System Class 10 Questions and Answers
Session 5: Create forms and reports using wizard
34. Why there is a need to create Forms?
Answer – A form allows the user to enter information into a database in a systematic manner. It is a user-defined interface that allows users to see, enter, and edit data directly in database.
35. What is the purpose of creating Reports?
Answer – Reports help to present the data in proper manner which is stored in the database, It also displays the data in summary format.
36. What are the prerequisites to create a Form and Reports?
Answer –
Forms –
a. Forms help or manage to store data in a systematic format.
b. The prerequisites to create a form would be –
c. Add all the necessary fields in the form
d. Make the connection between form and the table
Reports –
a. Reports display the data in a summarized manner.
b. The prerequisites to create a report would be –
c. Data
d. Data source
Database Management System Class 10 Questions and Answers
37. Differentiate between Forms and Reports.
Answer –
Form
a. Forms are used to store the data in the semantic way
b. Edit, delete & modify can be easily managed
c. Auto calculation can be done easily
Report
a. Report display the data in the presenting format
b. Report can display all the record from the table
c. Edit, delete & modification cannot be done through report
d. You can take printout with the help of report
38. Can a form display data from queries?
Answer – Yes form can display the data from queries, with the help of query you can filter the data and you can display in the form.
39. In how many ways Forms and Reports can be created in a database?
Answer – There are two ways to create a form and report in the database.
a. Using Wizard
b. Using Design View
Employability skills Class 10 Notes
- Unit 1- Communication Skills Class 10 Notes
- Unit 2- Self-Management Skills Class 10 Notes
- Unit 3- Basic ICT Skills Class 10 Notes
- Unit 4- Entrepreneurial Skills Class 10 Notes
- Unit 5- Green Skills Class 10 Notes
Employability skills Class 10 MCQ
- Unit 1- Communication Skills Class 10 MCQ
- Unit 2- Self-Management Skills Class 10 MCQ
- Unit 3- Basic ICT Skills Class 10 MCQ
- Unit 4- Entrepreneurial Skills Class 10 MCQ
- Unit 5- Green Skills Class 10 MCQ
Employability skills Class 10 Questions and Answers
- Unit 1- Communication Skills Class 10 Questions and Answers
- Unit 2- Self-Management Skills Class 10 Questions and Answers
- Unit 3- Basic ICT Skills Class 10 Questions and Answers
- Unit 4- Entrepreneurial Skills Class 10 Questions and Answers
- Unit 5- Green Skills Class 10 Questions and Answers
Information Technology Class 10 Notes
- Unit 1- Digital Documentation Class 10 Notes
- Unit 2- Electronic Spreadsheet Class 10 Notes
- Unit 3- RDBMS Class 10 Notes
- Unit 4 – Maintain Healthy Safe and Secure Working Environment Class 10 Notes
Information Technology Class 10 MCQ
- Unit 1- Digital Documentation Class 10 MCQ
- Unit 2- Electronic Spreadsheet Class 10 MCQ
- Unit 3- RDBMS Class 10 MCQ
- Unit 4 – Maintain Health Safety and Security at Workplace Class 10 MCQ
Information Technology Class 10 Questions and Answers
- Unit 1- Digital Documentation Class 10 Questions and Answers
- Unit 2- Electronic Spreadsheet Class 10 Questions and Answers
- Unit 3- RDBMS Class 10 Questions and Answers
Reference Textbook
Hi Students, Thank you for taking the time to reading Database Management System Class 10 Questions and Answers. Please take a few moments and leave your thoughts in the comment box below.
Disclaimer – 100% of the questions are taken from the CBSE textbook Database Management System Class 10 Questions and Answers, and our team has tried to collect all the correct Question and Answer from the textbook . If you found any suggestion or any error please contact us anuraganand2017@gmail.com.
This is enough for you to bag those 12 marks from this chapter, I would suggest not to read the whole chapter but instead do the question and answers for this chapter.
it was very useful before exams