12th Commerce IT Chapter 5 Exercise – Database Concepts using Libre Office Base | Maharashtra Board (Free Solution)

12th Commerce IT Chapter 5 Exercise

Chapter 5 – Database Concepts using Libre Office Base

Q 1. Fill in the blanks

1) Database is a collection of related data.

2) Queries are used to retrieve information from database.

3) The representation of data in printed form is called as report.

Q 2. State True/False.

1Form is used to collect the data from the user.
Answer: True

2) Menu bar is present below Title bar.
Answer: True

3) Columns are called as records.
Answer: False

Q 3. Multiple Choice Question.
(1 correct answer)

1) Rows in Base are called as …………………..
a) records
b) fields
c) table
d) database

2) File extension of Base is …………….
a) .odt
b) .ods
c) .odb
d) .odp

Free online lecture on above topic – Click Here

Solution of other subjects
Solution of Chapters of IT
1 – 2 – 3 – 4 – 5 – 6

Q 4. Answer in brief.

1) Define database.

Answer:

A database is a collection of related data items stored in an organized manner. A Database consists of different objects like table, query, form, and report. The table is a collection of related data. The query is used to retrieve information from database. The form is used to collect the information from user. Report is used to represent the data in printed form.

2) What is a query?

Answer:

a) A Query is a question asked within the database environment. For example how many students are in XII standard.
b) Query displays a subset of data contained in various tables of database.
c) Query is used to retrieve records from the table.

3) Define report.

Answer:

a) The presentation of information in an organised and readable format as per the user’s requirement is known as report.
b) Various complex reports can be generated that can help in taking decisions by the management.
c) Report is the representation of data in printed form.

4) Explain working area of Base.

Answer:

a) Rest of the part below standard tool bar is called as working area.
b) It is divided into two panes-Left pane and right pane.
c) Left pane displays name of database objects like tables, queries, forms and reports.
d) Right pane displays activities related to that particular object.

Q 5. Match the following.

A	B
1) Query	a) Collect information from user.
2) Report	b) Collection of related data.
3) Form	c) Retrieve data from database.
4) Table	d) printed form of data.

1) – c) Retrieve data from database.
2) – d) printed form of data.
3) – a) Collect information from user.
4) – b) Collection of related data.

Extra Questions

Choose a single correct answer from the given options.

1. _____ is an open source database.
a) LibreOffice writter
b) LibreOffice Base
c) Microsoft Access
d) LibreOffice Calc

2. ______means all kinds of fat, figures, place, things, or events.
a) Data
b) Information
c) Query
d) Report

3. _____ may be in oral, written, computerized form.
a) Information
b) Query
c) Report
d) Data

4. ______must be processed in a proper way to generate useful and meaningful information.
a) Information
b) Data
c) Table
d) Report

5. _____is the required result obtained from the processing of the data.
a) Table
b) Data
c) Information
d) Report

6. _____ is output generated through processing of raw data.
a) Information
b) Database
c) Data
d) Query

7. _____is a collection of related data items stored in an organised manner.
a) Information
b) Database
c) Raw Data
d) Operations

8. _____consists of object like table, query, form and report.
a) Information
b) Raw data
c) Database
d) Operation

9. _____is a collection of related data.
a) Data
b) Table
c) Query
d) Report

10. ____ is used retrieve information from database.
a) Table
b) Report
c) Query
d) Data

11. ____ is used to collect the information from user.
a) Table
b) Query
c) Report
d) Form

12. _____ is used to represent the data in printed form.
a) Query
b) Form
c) Report
d) Table

13. ____is a software design to define manipulate, retrieve and manage data in a database.
a) Table
b) Query
c) Report
d) DBMS

14. ____ defines rules to validate and manipulate the data.
a) DBMS
b) Report
c) Methods
d) Functions

15) DBMS stands for_____.
a) Digital Management System
b) Design Management System
c) Database Management System
d) Draft Management System

16. _____ is a Relational Database Management System.
a) Excel
b) Base
c) Word
d) Tally

17. RDBMS stands for______.
a) Ratio Database Management System
b) Right Database Management System
c) Regional Database Management System
d) Relational Database Management System

18. A DBMS that is based on Relational data model is called as ______.
a) RDBMS
b) Table
c) Report
d) Query

19. A_____model is the internal structure of a database that describes a way of storing and retrieving of data.
a) Table
b) Data
c) Query
d) Report

20. _____ is a collection of related data objects known as Tables, Forms, Queries, and Reports.
a) Word
b) Excel
c) Tally
d) Base

21. Extensions off base file is______.
a) .odx
b) .odb
c) .odm
d) .doc

22. On the screen of the base _____ bar is present below Title bar.
a) Tool
b) Standard
c) Menu
d) Working Area

23. ______ is a basic unit of storing data in database.
a) Query
b) Table
c) Form
d) Report

24. ______ is a real-world object about which data is to be stored.
a) Entity
b) Report
c) Data
d) Database

25. Each entity has a collection of_____associated with it.
a) Record
b) Row
c) Attributes
d) Column

12th Commerce IT Textbook Solutions

Chapter Name	Solution Link
1) Advanced Web Designing	Click Here
2) Digital Marketing	Click Here
3) Computerised Accounting with GST	Click Here
4) E-Commerce and E-Governance	Click Here
5) Database Concepts using Libre Office Base	Click Here
6) Enterprise Resource Planning (ERP)	Click Here

Check out our other posts related to 12th Commerce

Textbook Solutions of 12th Commerce (All Subjects)	Click Here
Free pdf of 12th Commerce Textbooks	Click Here
12th Commerce IT MCQ Preparation (Online Test)	Click Here
12th Commerce Paper Pattern and Chapter Wise Marks Distribution	Click Here
Sample Paper of 12th Commerce for Practice	Click Here
Solved Sample papers of 12th Commerce to improve Paper Presentation	Click Here