Smart Learning

Digital Learning

Saturday, October 4, 2025

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

by
on in


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


Question B: State Whether the Following Statements are True or False
1.You can only create a table in LibreOffice Base using the Design View.
Answer: False
2.The Table Wizard provides a step-by-step guide to help you create a table.
Answer: True
3.In Design View, you can specify the data types for each field in the table.
Answer: True
4.You can create duplicate values in a primary key field.
Answer: False
5.The Table Wizard allows you to choose from predefined templates for your table.
Answer: True
6.You cannot change the structure of a table once it has been created in Design View.
Answer: False

Question C: Multiple Choice Questions
1.What is the purpose of the Design View in LibreOffice Base?
A) To view the data in a table
B) To define the structure of a table
C) To write SQL queries
D) To create reports
Answer: B) To define the structure of a table
2.Which option allows you to create a table quickly using predefined structures in LibreOffice Base?
A) Design View
B) SQL View
C) Table Wizard
D) Form View
Answer: C) Table Wizard
3.In LibreOffice Base, which of the following is not a data type?
A) Text
B) Character
C) Float
D) Boolean
Answer: D) Boolean
4.What does the primary key in a table do?
A) It allows multiple records to have the same value
B) It uniquely identifies each record in a table
C) It stores data types
D) It creates relationships between tables
Answer: B) It uniquely identifies each record in a table
5.Which data type would you use to store a person’s birthday in LibreOffice Base?
A) Text
B) Integer
C) Date/Time
D) Boolean
Answer: C) Date/Time
6.When creating a new table using the wizard, what is the first step?
A) Define field properties
B) Choose a table type
C) Select data types for fields
D) Enter records
Answer: B) Choose a table type


Question D: Very Short Answer Questions
1.What are the two methods for creating a table in LibreOffice Base?
Answer: The two methods are Design View and Table Wizard. Design View lets you create manually, while Table Wizard gives step-by-step guidance.
2.In which view can you manually set field properties for a table?
Answer: You can manually set field properties like field name, data type, and length in Design View.
3.What is the primary purpose of a primary key in a table?
Answer: The primary key is used to uniquely identify each record and prevent duplication.
4.Which data type would you use for storing whole numbers?
Answer: The Integer data type is used for storing whole numbers.
5.What is the maximum character length for a text data type?
Answer: The Text data type can store up to 255 characters.
6.What data type is used for storing dates and times?
Answer: The Date/Time data type is used for storing both date and time values.

Question E: Short Answer Questions
1.What are the main components of the LibreOffice Base interface?
Answer: The main components are:
Database Pane: Displays object types (Tables, Queries, Forms, Reports)
Tasks Pane: Lists actions for the selected object type
Object Pane: Shows created objects
Work Area: Displays the design or data view

2.What types of database objects can be created in LibreOffice Base?
Answer: The main objects are Tables, Queries, Forms, and Reports. Tables store data, Queries retrieve data, Forms are for data entry, and Reports present data in printed form.

3.What is the purpose of the Table Wizard in LibreOffice Base?
Answer: The Table Wizard provides an easy step-by-step process for creating a table quickly with predefined fields and suitable data types.

4.What are the different data types available in LibreOffice Base?
Answer: The commonly used data types are Text, Memo, Integer, Decimal, Date/Time, Boolean, Currency, and AutoValue. Each is used to store a specific kind of data.

5.How do you set a primary key in a table?
Answer: In Design View, select the field you want as the key and click the Primary Key icon or right-click and choose “Primary Key.”

6.How can you change the data type of an existing field in a table?
Answer: Open the table in Design View, select the field, and choose a new Data Type from the dropdown list.

7.What is the difference between CHAR and VARCHAR data types?
Answer:
CHAR is for fixed-length text (always uses defined space).
VARCHAR is for variable-length text (uses only required space).


You May Also Like:
By
at
Tags

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)