Database Concepts using LibreOffice Base is an important chapter for HSC Class 12 Information Technology students. This chapter helps students understand the basics of databases, tables, forms, queries, reports, and relational concepts using LibreOffice Base. On this page, you will find chapter-wise MCQs prepared strictly as per the Maharashtra HSC syllabus, useful for board exam preparation, practice tests, and quick revision.
Database Concepts Using Libreoffice Base HSC Class 12 MCQs
1. LibreOffice Base is an __.
a. Open-source database
b. License-based
c. GPL License
d. None of the above
2. DBMS stands for _.
a. Database Management System
b. Database Management Software
c. Database Management Software
d. Database Management System
3. Data means all kinds of __.
a. Facts
b. Figures
c. Details related to people, places, things, or events
d. All of the above
4. Information is the output generated through processing of raw data.
a. Yes
b. No
5. A database is a collection of related data items stored __.
a. in an organized manner
b. Randomly
c. In scattered files
d. None of the above
6. A database consists of different objects like _.
a. Table
b. Query
c. Form and report
d. All of the above
7. _ is a collection of related data.
a. Table
b. Query
c. Form
d. Report
8. _ is used to retrieve information from a database.
a. Table
b. Query
c. Form
d. Report
9. _ is used to collect the information from the user.
a. Table
b. Query
c. Form
d. Report
10. __ is used to represent the data in printed form.
a. Table
b. Query
c. Form
d. Report
11. A database management system is software designed to _.
a. Manipulate the data in the database
b. Retrieve the data in the database.
c. Manage the data in the database
d. All of the above
12. Databases provide various functions that allow entry, storage, and retrieval of large quantities of information and provide ways to manage that information.
a. True
b. False
13. RDBMS stands for _.
a. Relational Database Management Software
b. Retain Database Management System
c. Relational Database Management System
d. Retain Database Management System
14. The relational data model is one of the most popular data models because _.
a. It is based on a hierarchical structure.
b. It is simple and easy to understand.
c. It uses complex pointer structures.
d. It is difficult to implement.
15. RDBMS stands for __.
a. Regional Database Management System
b. Relational Database Management System
c. Relational Database Management Software
d. None of the above
16. A data model is the internal structure of a database, which describes a way of __.
a. Way of storing
b. Way of retrieving
c. Both a) and b)
d. None of the above
17. In RDBMS data is stored in the most simple and versatile structure, i.e., a table.
a. Yes
b. No
18. In LibreOffice Base the working area is divided into _ panes.
a. 2
b. 3
c. 4
d. 5
19. In the left pane of the LibreOffice Base display, the __.
a. Name of database object, like table, queries, forms, and report
b. Display activities related to that particular object.
c. Both a) and b)
d. None of the above
20. In the right pane of the LibreOffice base display the __.
a. Name of database object, like table, queries, forms, and report
b. Display activities related to that particular object.
c. Both a) and b)
d. None of the above
21. _ are organized in the form of columns and rows.
a. Table
b. Query
c. Form
d. Report
22. _ is any real-world object about which data is to be stored.
a. Table
b. Query
c. Entity
d. Report
23. _ of an entity are stored in the form of columns.
a. Table
b. Query
c. Entity
d. Attributes
24. In LibreOffice Base, data types are categorized as __.
a. Alphanumeric
b. Numeric
c. Calendar and binary type
d. All of the above
25. Which of the following data types is used to store images?
a. Image[LONGVARBINARY]
b. Binary [VARBINARY]
c. Memo [LONGVARCHAR]
d. None of the above
26. __ datatype stores descriptive type of information, i.e., a large block of text like article text.
a. Image[LONGVARBINARY]
b. Binary [VARBINARY]
c. Memo [LONGVARCHAR]
d. None of the above
27. A __ is a question asked within the database environment. For example, how many students are in the XII standard?
a. Table
b. Query
c. Entity
d. Attributes
28. __ is used to retrieve records from the table.
a. Table
b. Query
c. Entity
d. Attributes
29. __ is an object that allows entering the data and editing or deleting existing data in the table.
a. Table
b. Query
c. Form
d. Attributes
30. In LiberOffic, the base form contains __.
a. Radio button
b. List boxes
c. Buttons
d. All of the above
31. The presentation of information in an organized and readable format as per the user’s requirement is known as __.
a. Table
b. Query
c. Form
d. Report
32. A data model defines __.
a. How data are connected to each other
b. How they are processed
c. How they are stored inside the system
d. All of the above
33. Which of the following are examples of data models?
a. Relational data model
b. Network data model
c. Hierarchical data model
d. All of the above
34. The most commonly used data model is __.
a. Relational data model
b. Network data model
c. Hierarchical data model
d. All of the above
35. A relational database refers to a database that stores data in a _.
a. Structured format
b. Using rows and columns
c. Both a) and b)
d. None of the above
36. A relational database refers to a database that stores data in a relation.
a. Attribute
b. Tuple
c. Domain
d. Degree
37. Each row of data in a relation (table) is called a __.
a. Attribute
b. Tuple
c. Domain
d. Degree
38. __ is a set of values from which an attribute can take a value in each row.
a. Attribute
b. Tuple
c. Domain
d. Degree
39. In database design, every attribute has a predefined value scope. What is this scope called?
a. Relation
b. Domain
c. Tuple
d. Schema
40. The number of attributes in a relation is called the __ of the relation.
a. Degree
b. Domain
c. Tuple
d. Cardinality
41. The number of tuples in a relation is called the __ of the relation.
a. Degree
b. Domain
c. Tuple
d. Cardinality
42. The tuples within a relation must be unique. It means no two tuples in a relation should have the same value for all attributes.
a. True
b. False
43. If a relation can have one or more attributes that take unique values, it is known as __.
a. Foreign Key
b. Candidate Key
c. Composite Key
d. None of the above
44. In a relational database, what is a candidate key?
a. A set of attributes that uniquely identifies a tuple and may serve as a primary key
b. A non-unique attribute used for indexing
c. A foreign key referencing another table
d. A redundant attribute that can be removed
45. One or more candidate keys, the attribute used to uniquely identify the tuples in a relation, is called the __.
a. Foreign Key
b. Candidate Key
c. Composite Key
d. Primary Key
46. If no single attribute in a relation is able to uniquely distinguish the tuples, then more than one attribute is taken together as a primary key. Such a primary key consisting of more than one attribute is called _.
a. Foreign Key
b. Candidate Key
c. Composite Key
d. Primary Key
47. A __ key is an attribute whose value is derived from the primary key of another relation.
a. Foreign Key
b. Candidate Key
c. Composite Key
d. Primary Key
48. How many types of relationships are there in relational database design?
a. 2
b. 3
c. 4
d. 5
49. Which of the following best describes a one-to-one (1:1) relationship?
a. Each entity in Table A can relate to multiple entities in Table B.
b. Each entity in Table A relates to exactly one entity in Table B.
c. Each entity in Table A can relate to many entities in Table B, and vice versa.
d. No relationship exists between Table A and Table B.
50. In a one-to-many relationship, how are entities connected?
a. One entity in Table A can be linked to multiple entities in Table B.
b. One entity in Table A can only be linked to one entity in Table B.
c. Multiple entities in Table A can be linked to multiple entities in Table B.
d. Entities in Table A and Table B are unrelated.
51. Which relationship type allows multiple entities in Table A to be linked with multiple entities in Table B?
a. One-to-One
b. One-to-Many
c. Many-to-Many
d. None of the above
52. A student has only one ID card, and each ID card belongs to only one student. This is an example of:
a. One-to-One
b. One-to-Many
c. Many-to-Many
d. None of the above
53. A teacher can teach many students, but each student is taught by only one teacher. This is an example of:
a. One-to-One
b. One-to-Many
c. Many-to-Many
d. None of the above
54. Students can enroll in multiple courses, and each course can have multiple students. This is an example of:
a. One-to-One
b. One-to-Many
c. Many-to-Many
d. None of the above
Disclaimer: We have provide you with the accurate handout of “Database Concepts Using Libreoffice Base HSC Class 12 MCQs“. If you feel that there is any error or mistake, please contact me at anuraganand2017@gmail.com. The above study material present on our websites is for education purpose, not our copyrights.
All the above content and Screenshot are taken from Information Technology Class 12 Textbook and MSBSHSE (HSC) Support Material which is present in MSBSHSE (HSC) website, This Textbook and Support Material are legally copyright by Maharashtra State Bureau of Textbook Production and Curriculum Research, Pune. We are only providing a medium and helping the students to improve the performances in the examination.
Images and content shown above are the property of individual organisations and are used here for reference purposes only. To make it easy to understand, some of the content and images are generated by AI and cross-checked by the teachers. For more information, refer to the official website.