Smart Learning

Digital Learning

Wednesday, October 15, 2025

What is the IT and ITeS Industry? Class-9-PART-B UNIT-I-CH-1:

CBSE Solutions-2025-26 ,
What is the IT and ITeS Industry? Class-9-PART-B UNIT-I-CH-1:

PART-B Unit-1 Introduction to IT-ITes Industry (2025-26)
Chapter-1 Appreciate the Applications of IT

A : Fill in the Blanks
1.2D and – have made it easy for teachers to explain concepts in a class.
Answer: 3D animations
2.Technology-enabled whiteboards help – record her lessons.
Answer: Teachers
3.Apps and – such as Fitbit help to monitor heart rate, sleep pattern, and provide personalized information to the user.
Answer: Wearable devices
4.In marketing, computers are used for – of products.
Answer: Advertisement and promotion
5.Complex scientific applications like rocket launching, space exploration etc., are not possible without the use of –.
Answer: Supercomputers

B : True or False
1.You cannot book LPG cylinder online and establish helpline as part of disaster management.
Answer: False
2. ICT is used to issue timely warning and establish helpline as part of disaster management.
Answer: True
3.Using Duolingo app, you can easily learn many languages such as English, Spanish, French, etc.
Answer: True
4.Video conferencing allows for simple real-time communication between two groups.
Answer: True
5.Social media networks like Facebook, Instagram, Twitter, WhatsApp are services to keep in touch with family and friends.
Answer: True

Read more »
By
at No comments:
Tags

Friday, October 10, 2025

What are forms and reports in Base? Class-10-Part:B-Unit:3-Ch:5:

CBSE Solutions-2025-26 ,
What are forms and reports in Base? Class-10-Part:B-Unit:3-Ch:5:


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

chapter- 5 Forms and reports

A. Fill in the Blanks
Q1.To create a form in LibreOffice Base, you can use the ________, which guides you through the process step by step.
Answer: Form Wizard
Q2.The Form Wizard allows you to set the ______ order of the records displayed in the form.
Answer: Sort
Q3.After creating a form using the wizard, it is saved with a specific _______ for future use.
Answer: Name
Q4.To insert a new record in a form, click the ______ button in the form’s navigation bar.
Answer: New Record
Q5.The background colour of the form can be changed by selecting a colour from the ________.
Answer: Colour Palette
Q6.In the Report Wizard, you can group data by selecting a field in the _________
Answer: Grouping Step
Q7.In the Report Wizard, you select the _______ such as tabular or columnar for displaying the data.
Answer: Layout Style

B. State True or False
Question.1: The Form Wizard in LibreOffice Base allows you to create a form without selecting a table or query as the data source.
Answer: False
Question.2: Once a form is created using the Form Wizard, it cannot be modified in Design View.
Answer: False
Question.3: The Form Wizard automatically sets up navigation controls for moving between records.
Answer: True
Question.4: After creating a form using the wizard, the form is automatically saved without asking for confirmation.
Answer: False
Question.5: In the Report Wizard, it is mandatory to specify field choices.
Answer: True

C. Multiple Choice Questions
Q1.Which of the following steps is the first when creating a form using the Form Wizard in LibreOffice Base?
(A) Selecting the layout of the form
(B) Choosing the tables or queries
(C) Grouping data in the form
(D) Saving the form
Answer: (B) Choosing the tables or queries
Q2.How can you insert a new record in a form in LibreOffice Base?
(A) By typing in the form and clicking the Next button
(B) By using the New Record button
(C) By right-clicking and selecting Insert New
(D) By opening Design View
Answer: (B) By using the New Record button
Q3.To delete a record in a form, which of the following is true?
(A) You must switch to Design View
(B) Use the Delete Record button in the form navigation bar
(C) Go to the table view and remove the data manually
(D) Deleting records is not possible from the form
Answer: (B) Use the Delete Record button in the form navigation bar
Q4.How can you change the background colour of a form in LibreOffice Base?
(A) Modify the background colour of the table
(B) Use the Colour Palette
(C) Use the Query Wizard
(D) Change the form layout in the Form Wizard
Answer: (B) Use the Colour Palette
Q5.What is the purpose of a report in a database?
(A) To allow users to enter and modify data
(B) To present data in a structured, printable format
(C) To sort data alphabetically
(D) To create new tables in the database
Answer: (B) To present data in a structured, printable format
Which of the following tools can you use to create a report in LibreOffice Base?
(A) Design View
(B) Report Wizard
(C) Form Wizard
(D) Query Wizard
Answer: (B) Report Wizard

D. Very Short Answer Questions
Question.1: How do you create a form using the Form Wizard in LibreOffice Base?
Answer: Open LibreOffice Base → click Forms → choose Use Wizard to Create Form → select table or query and fields → choose layout → save the form.
Question.2: What is the purpose of using the Form Wizard in LibreOffice Base?
Answer: It helps users create forms easily by guiding them step by step to select fields, layout, and style without coding.
Question.3: What happens when you delete a record from a form in LibreOffice Base?
Answer: The deleted record is permanently removed from the form and the linked table.
Question.4: What is the purpose of the Report Wizard in LibreOffice Base?
Answer: It helps users create structured and printable reports from tables or queries.
Question.5: What happens after you complete the steps in the Form Wizard?
Answer: The form is created and saved with the name given by the user.
Question.6: What is the purpose of the New Record button in a form?
Answer: It allows adding a new record to the database directly through the form.

E. Short Answer Questions (Expanded)
Question.1: What is the first step when creating a report using the Report Wizard?
Answer:
The first step is to select the table or query from which you want to extract the data. This determines which records and fields will appear in your report. After selecting the data source, the wizard allows you to choose specific fields to include and organize them into a clear format.
Question.2: How does the Report Wizard help in creating dynamic reports that update automatically?
Answer:
The Report Wizard connects the report directly to the database tables or queries. This means whenever data in those tables or queries is updated, the report automatically reflects those changes the next time it is opened or printed. This makes the reports dynamic, accurate, and always up-to-date.
Question.3: What is a form and why do you need a form?
Answer:
A form is a user-friendly interface used to enter, edit, or view data stored in a database. It allows users to work with data one record at a time without dealing directly with complex tables. Forms reduce data entry errors and make it easier for non-technical users to interact with the database.
Question.4: What layout options are available in the Report Wizard?
Answer:
The Report Wizard provides mainly two layout options: Tabular and Columnar.
In the Tabular layout, records are displayed in rows and columns like a spreadsheet.
In the Columnar layout, each record appears as a separate block, which is suitable for detailed reports.
Users can also select page orientation (portrait or landscape) for better printing format.
Question.5: What is the purpose of the Delete Record button in a form?
Answer:
The Delete Record button helps remove a selected record from the database. When clicked, it permanently deletes the record from both the form and the connected table. It ensures data remains clean and relevant, but users must use it carefully to avoid accidental deletion.

F. Long Answer Questions (Expanded)
Question.1: What is a form in LibreOffice Base and how does it enhance user interaction with a database?
Answer:
A form in LibreOffice Base is a graphical tool that allows users to view, enter, and update data easily. Instead of working directly with tables that display raw data, forms provide a user-friendly interface with text boxes, drop-down menus, and buttons.
Forms improve interaction by making data handling simpler and reducing the chances of mistakes. They can also include navigation buttons for moving between records, making database management efficient. For example, a school database form can allow teachers to enter student details directly without editing the main table. Thus, forms enhance both usability and accuracy in database operations.
Question.2: Explain the role of reports in LibreOffice Base and how they differ from forms.
Answer:
Reports in LibreOffice Base are used to present and print summarized data in an organized format. They are designed for viewing results, not for editing or entering data. A report can include totals, groupings, and formatted headings, making data easier to analyze.
The key difference between forms and reports is their purpose:
Forms are for data entry and modification.
Reports are for data presentation and analysis.
For example, a sales form is used to record new sales, whereas a sales report shows monthly totals and summaries.
Question.3: How do you create a form using the Wizard in LibreOffice Base and what are the steps involved in each process?
Answer:
To create a form using the Wizard, follow these steps:
Open LibreOffice Base and click on Forms.
Click Use Wizard to Create Form.
Select the table or query from which you want to pull data.
Choose the fields you want to include in the form.
Decide whether to include a subform to display related data.
Choose how the data should be displayed (columnar, tabular, etc.).
Select the style and background colour for better appearance.
Name and save the form for future use.
The wizard simplifies form creation by guiding users through each step, allowing even beginners to design efficient forms easily.
Question.4: Describe the process of creating a report using the Report Wizard in LibreOffice Base. What options are available during this process?
Answer:
The Report Wizard in LibreOffice Base provides a structured method for creating professional reports. The process includes:
Selecting the Table or Query: Choose the data source for the report.
Choosing Fields: Select which fields you want to include.
Grouping Information: Decide if you want to group data by a certain field (e.g., class, category).
Sorting Data: Set the order in which records appear (ascending or descending).
Selecting Layout and Orientation: Choose between Tabular or Columnar layout and portrait or landscape page orientation.
Selecting Report Style: Choose a visual style (font, colour, etc.) to improve readability.
Naming and Saving: Provide a name and finish the report creation process.
Once the wizard completes, the report can be previewed, printed, or exported. Reports are especially useful for presenting data summaries like marksheets, employee details, or sales summaries.

Read more »
By
at No comments:
Tags

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