Smart Learning

Digital Learning

Thursday, October 9, 2025

What are Queries in Base? Class-10-Part:B-Unit:3-Ch:4:

CBSE Solutions-2025-26 ,
What are Queries in Base? Class-10-Part:B-Unit:3-Ch:4:


CBSE SOLUTIONS-2025-26
CLASS-10-PART-B
unit-3 database Management system using lobreoffice base

chapter- 4 Queries in libreoffice base

A. Fill in the blanks
Q1_______ allow you to retrieve, manipulate, and analyse data efficiently.
Answer: Queries
Q2_______ is the standard language for managing and manipulating relational databases.
Answer: SQL (Structured Query Language)
Q3An _______ in a query is a custom name assigned to a field to make the output more user-friendly.
Answer: Alias
Q4 In LibreOffice Base, the _______ is a tool that provides a step-by-step guide for creating queries without writing SQL code.
Answer: Query Wizard
Q5 In Design View, you can add tables and fields by dragging them from the table list into the _______.
Answer: Design Grid

B. True or False
Q1 The Query Wizard allows users to create complex queries without needing to know SQL.
Answer:  True
Q2 In Design View, users must write all SQL commands manually to create a query.
Answer:  False
Q3 Design View provides a visual interface for adding tables and fields to a query.
Answer:  True
Q4 The Query Wizard does not allow for sorting of results after the query is created.
Answer:  False
Q5 In Design View, you can specify which fields to include in the query by dragging them into the design grid.
Answer:  True
Q6 Users can switch between Design View and SQL View in LibreOffice Base while working on a query.
Answer:  True

Read more »
By
at No comments:
Tags

Monday, October 6, 2025

What is multiple tables? Class-10-Part:B-Unit:3-Ch:3:

CBSE Solutions-2025-26 ,
What is multiple tables? Class-10-Part:B-Unit:3-Ch:3:


CBSE SOLUTIONS-2025-26
CLASS-10-PART-B
unit-3 database Management system using lobreoffice base

chapter- 3 working with multiple tables

A. Fill in the Blanks.
Question.1: ________ is a rule that maintains consistency between related tables ensuring that changes in the parent table are reflected in the child table.
Answer: Referential Integrity
Question.2: In a ________ relationship, a record in one table can have many matching records in another table, but each matching record has only one corresponding record in the first table.
Answer: One-to-Many
Question.3: A relationship is created between tables based on matching ________ in both tables.
Answer: Fields
Question.4: A ________ relationship occurs when a single record in one table is associated with only one record in another table.
Answer: One-to-One
Question.5: In LibreOffice Base, the ________ dialogue box is used to create and manage relationships between tables.
Answer: Relationships
Question.6: ________ option in relationships ensures that related records in the child table are automatically deleted when the parent record is deleted.
Answer: Cascade Delete

B. True or False.
Question.1: A primary key must always contain unique values.
Answer: True
Question.2: Referential integrity ensures that data across related tables remains consistent.
Answer: True
Question.3: It is possible to create a relationship between two tables without a foreign key.
Answer: False
Question.4: You can delete a record from the parent table without affecting the child table when referential integrity is enforced.
Answer: False
Question.5: In a one-to-many relationship, one record in the parent table can relate to multiple records in the child table.
Answer: True
Question.6: You can create relationships between tables in the Relationships dialogue box of LibreOffice Base.
Answer: True

Read more »
By
at No comments:
Tags

Saturday, October 4, 2025

What is a LibreOffice Base? Class-10-Part:B-Unit:3-Ch:2:

CBSE Solutions-2025-26 ,
What is a LibreOffice Base? Class-10-Part:B-Unit:3-Ch:2:


CBSE SOLUTIONS-2025-26
CLASS-10-PART-B
unit-3 database Management system using lobreoffice base

chapter- 2 Starting with LibreOffice base

Question A: Fill in the Blanks
1.In LibreOffice Base, you can create a new table using either the ______ view or the ______.
Answer: Design View or Table Wizard
2.When using the Table Wizard, the first step is to select the type of table you want to create, which is called a ______.
Answer: Table Category
3.In Design View, you can specify the ______ and ______ for each field in your table.
Answer: Field Name and Data Type
4.A ______ is used to uniquely identify each record in a table and cannot contain duplicate values.
Answer: Primary Key
5.The ______ data type is used to store whole numbers in a table.
Answer: Integer
6.The ______ option in the wizard provides a step-by-step approach to define your table’s structure.
Answer: Table Wizard

Read more »
By
at No comments:
Tags

Thursday, October 2, 2025

CBSE SAMPLE PAPER-Class-X (Session-2025-26):

CBSE Solutions-2025-26 ,
CBSE SAMPLE PAPER-Class-X (Session-2025-26):

CBSE- Sample Question Paper(SQP) and
Marking Scheme(MS), Session-2025-26

CBSE has been released the Sample Question Paper and Marking Scheme for Session-2025-26 
 
CBSE Board Sample Question Paper(SQP) and Marking Scheme(MS) for Session-2025-26 has been released.
You can download here SQP and MS by direct click on following link(PDF format).

To download Hindi Course-A(Code-002) Sample Question Paper(SQP) and Marking Scheme(MS) for class-X-(Session-2025-26) click on the following link:

To download English language and literature(Code-184) Sample Question Paper(SQP) and Marking Scheme(MS) for class-X-(Session-2025-26) click on the following link:

To download Mathematics(Standard-041) Sample Question Paper(SQP) and Marking Scheme(MS) for class-X-(Session-20245-26) click on the following link:

To download Mathematics(Standard-041) Sample Question Paper(SQP) and Marking Scheme(MS) for class-X-(Session-2025-26) click on the following link:

To download Science(Code-086) Sample Question Paper(SQP) and Marking Scheme(MS) for class-X-(Session-2025-26) click on the following link:

To download Social Science(C0de-087) Sample Question Paper(SQP) and Marking Scheme(MS) for class-X-(Session-2025-26) click on the following link:

To download Information Technology(Code-402) Sample Question Paper(SQP) and Marking Scheme(MS) for class-X-(Session-2025-26) click on the following link:

Read more »
By
at No comments:
Tags

What is the database management system DBMS? Class-10-Part:B-Unit:3-Ch:1:

CBSE Solutions-2025-26 ,
What is the database management system DBMS? Class-10-Part:B-Unit:3-Ch:1:

CBSE SOLUTIONS-2025-26
CLASS-10-PART-B
unit-3 database Management system using lobreoffice base

chapter- 1 Introduction to Database Management System

A. Fill in the blanks:
Q1. ____ is a collection of raw facts and figures that have not been processed into meaningful information.
Ans: Data
Q2. ____ is processed data that is meaningful and useful for decision making.
Ans: Information
Q3. A ____ key is a unique identifier for each record in a table and cannot contain null values.
Ans: Primary Key
Q4. ____ keys are used to establish a relationship between two tables in an RDBMS.
Ans: Foreign Keys
Q5. RDBMS organizes data into ____.
Ans: Tables
Q6. A ____ key consists of two or more attributes that uniquely identify a record in a table.
Ans: Composite Key

Read more »
By
at No comments:
Tags