Scribd
Upload
5 views5 pages

DATABASE Practical File

The document provides a comprehensive overview of databases, including definitions, the role of DBMS, and practical exercises using LibreOffice Base. It covers creating tables, inserting records, and executing various SQL queries to manipulate and retrieve data. Additionally, it outlines the steps for creating databases, tables, and reports, along with the advantages of using a DBMS.

Uploaded by

js7111437
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views5 pages

DATABASE Practical File

The document provides a comprehensive overview of databases, including definitions, the role of DBMS, and practical exercises using LibreOffice Base. It covers creating tables, inserting records, and executing various SQL queries to manipulate and retrieve data. Additionally, it outlines the steps for creating databases, tables, and reports, along with the advantages of using a DBMS.

Uploaded by

js7111437
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

DATABASE

Q1. What is a Database?

Answer:
A database is an organized collection of related data stored in a computer so that it can be easily
accessed, managed and updated.

Q2. What is DBMS? Write its full form.

Answer:
DBMS stands for Database Management System.
It is software that helps us to create, store, manage and retrieve data from a database.

Q3. Name the DBMS software used in Class 10 IT practicals.

Answer:
LibreOffice Base is used as DBMS software in Class 10 IT practicals.

Q4. Create a table named Student with suitable fields.

Solution:

Table Name: Student

Field Name Data Type


RollNo Integer (Primary Key)
Name Text
Class Integer
Section Text
Age Integer
Q5. Insert five records into the Student table.

Solution:

RollNo Name Class Section Age


1 Aman 10 A 15
2 Riya 10 B 16
3 Neha 9 A 14
4 Rahul 10 A 15
5 Karan 9 B 14

Q6. Write a query to display all records from the Student table.

Solution (SQL Query):

SELECT * FROM Student;

Q7. Write a query to display Name and Class of all students.

Solution:

SELECT Name, Class FROM Student;

Q8. Write a query to show details of students studying in Class 10.

Solution:

SELECT * FROM Student WHERE Class = 10;

Q9. Write a query to display students of Section ‘A’.

Solution:

SELECT * FROM Student WHERE Section = 'A';


Q10. Write a query to sort students by Name in ascending order.

Solution:

SELECT * FROM Student ORDER BY Name ASC;

Q11. Write a query to count the total number of students.

Solution:

SELECT COUNT(*) FROM Student;

Q12. Write a query to find the maximum age of students.

Solution:

SELECT MAX(Age) FROM Student;

Q13. What is a Primary Key?

Answer:
A primary key is a field that uniquely identifies each record in a table.
Example: RollNo.

Q14. What is a Query?

Answer:
A query is a request to retrieve specific information from a database.

Q15. What is a Form in DBMS?

Answer:
A form is used to enter, edit and view data easily in a database.
Q16. What is a Report?

Answer:
A report is used to display data in a printable and well-formatted manner.

Q17. State any two advantages of DBMS.

Answer:

1. Data is stored in an organized way


2. Easy data retrieval and updating

Q18. Write steps to create a database in LibreOffice Base.

Solution:

1. Open LibreOffice
2. Click on Base
3. Select Create a new database
4. Click Finish
5. Save the database file

Q19. Write steps to create a table in LibreOffice Base.

Solution:

1. Open the database


2. Click on Tables
3. Choose Create Table in Design View
4. Enter field names and data types
5. Set primary key
6. Save the table
Q20. Write steps to create a report.

Solution:

1. Open database
2. Click on Reports
3. Select Use Wizard to Create Report
4. Choose table and fields
5. Finish and save report

You might also like