CHAPTER 12: FORMS AND REPORTS
1. The LibreOffice Base provides the _ feature for data entry purposes.
a. Table b. Form c. Report d. None of the above
2. Which features are used by the database to retrieve data in a user friendly,
understandable and formatted manner.
a. Table b. Form c. Report d. None of the above
3. The Table, Query, Forms and Reports are considered as __ of the database.
a. Object b. Function c. Method d. None of the above
4. The database objects are present in the __ of the LibreOffice Base User Interface.
a. Database Pane b. Windows Pane c. Data Pane d. None of the above
5. Form is also defined as __.
a. Back End Application b. Front End Application
c. Both a) and b) d. None of the above
6. Which types of field control is used to design a Form in a database.
a. Text Box, Label, heading and names b. Radio Button, graphics like logos
c. Combo Box, Check Box d. All of the above
7. In LibreOffice Base form can be created using which of the following ways.
a. Using a wizard b. Using the design view
c. Both a) and b) d. None of the above
8. In LibreOffice Base the simplest way to create a form is using _.
a. Using wizard b. Using design view c. Using Query d. None of the above
9. In LibreOffice Base the field control consists of _ parts.
a. 2 b. 3 c. 4 d. 5
10. In LibreOffice Base the field control consists of __.
a. Label b. Field Value c. Both a) and b) d. None of the above
11. How many layouts are given in LibreOffice Base using the wizard option.
a. 3 b. 4 c. 5 d. 6
12. In LibreOffice Base by default the name of the form is the same as the name of the _.
a. Form b. Table c. Database d. None of the above
13. _ toolbar contains various controls that can be added to the form.
a. Records toolbar b. Form Control Toolbar
c. Format Toolbar d. None of the above
14. The Form Control toolbar is present on the __ of the Form design window.
a. Left b. Right c. Middle d. Bottom
15. The _ toolbar contains the navigation control buttons and we can traverse and view the
records in the file.
a. Records toolbar b. Form Control Toolbar
c. Format Toolbar d. None of the above
16. The form modification can be done once it is created, In LibreOffice Base modification
can be changed to the __.
a. Background color b. Font size
c. Font color of the text or positioning of various controls d. All of the above
17. To change the background color of the form, right click on the form and select _.
a. Page Style b. Background Style c. Database Style d. None of the above
18. The Page Style dialog box will appear when you will click on __.
a. Color tab b. Area tab c. Design tab d. None of the above
19. Label text can be changed using which of the following options in LibreOffice Base.
a. Property b. Design View c. Font design d. All of the above
20. A __ is a small piece of text that appears when the mouse cursor is over a specific
control.
a. Tool-design b. Tool-tip c. Tool-Font d. All of the above
21. To add titles, headings or subheading in the Form using __.
a. Textbox b. Combobox c. Labels d. Radio Button
22. The records that have been extracted using a query are displayed in a simple row and
column format known as __.
a. Query b. Form c. Report d. None of the above
23. A layout is used to display the report in the form of _.
a. Landscape b. Portrait c. Both a) and b) d. None of the above
24. A default layout selected by the LibreOffice Base is __.
a. Landscape b. Portrait c. Both a) and b) d. None of the above
25. By default the type of report is __ in LibreOffice Base.
a. Dynamic b. Static c. Both a) and b) d. None of the above
26. What do you mean by Dynamic report in LibreOffice Base.
a. Automatic updation is allowed in the report
b. Automatic updation is not allowed in the report
c. Manually you have to add component in the report
d. None of the above
27. If you don’t want automatic updation of the report in LibreOffice Base, you can select
the _ option.
a. Dynamic b. Static c. Both a) and b) d. None of the above
28. To make the report more presentable by inserting __.
a. Titles b. Author name c. Date of generation of report d. All of the above
29. To insert data and time in Report, you can use __.
a. Insert > Date and Time b. Edit > Date and Time
c. View > Date and Time d. None of the above
30. We can create a report based on a _.
a. Table b. Query c. Both a) and b) d. None of the above
SOME EXTRA PREVIOUS TEXTBOOK MCQ
31. A_________________ database management system is referred to as a relational model.
a. RDBMS b. DBMS c. DB d. None of the above
32. Data can be organized into __.
a. Flat File b. Relational c. Both a) and b) d. None of the above
33. Data is stored in multiple tables, which are connected together via a common field.
a. Flat File b. Relational c. Both a) and b) d. None of the above
34. DBMS Stands for __.
a. Database Management System b. Database Manage System
c. Data Manage System d. None of the above
35. __ are dedicated computers which store database and related DBMS software.
a. Database Server b. Decided Server c. Web Server d. None of the above
36. When the same data stored in multiple table is known as __.
a. Data Redundancy b. Data Integrity c. Data Consistency d. None of the above
37. _ prevents creating multiple copies in the database.
a. Data Redundancy b. Data Integrity c. Data Consistency d. None of the above
38. __ means that the data is accurate and consistent in the database.
a. Data Redundancy b. Data Integrity c. Data Consistency d. None of the above
39. _ prevent multiple mismatching copies of the same data in the database and only valid
data will be added in the database.
a. Data Redundancy b. Backup and Recovery
c. Data Consistency d. None of the above
40. The relationship between two tables where one table has one record and another table
has many records is known as _.
a. One-to-Many b. Many-to-Many c. Many-to-One d. None of the above
41. SQL stands for _.
a. Single Query Language b. Structured Query Language
c. Semantic Query Language d. None of the above
42. __ are the basic building blocks of a database.
a. Table b. Query c. Database d. None of the above
43. _ data type can store 0 or 1 in the database.
a. Boolean b. TinyInt c. Smalint d. BigInt
44. In a table, a __ represents a single data item.
a. Row b. Truple c. Both a) and b) d. None of the above
45. __ is used to maintain accuracy and consistency of data in a relationship.
a. Referential data b. Referential Integrity
c. Referential Value d. None of the above
46. What are the different types of relationships in LibreOffice Base, which are used to
make connection between two tables___________.
a. One to One b. One to Many or Many to One
c. Many to Many d. All of the above
47. A Which of the following command used to define structure in the database.
a. Data Manipulation Language (DML) b. Data Definition Language (DDL)
c. Both a) and b) d. None of the above
48. A __ is a language that enables users to access and manipulate data in a database.
a. Data Manipulation Language (DML) b. Data Definition Language (DDL)
c. Both a) and b) d. None of the above
49. A __ is a subset of DML that just deals with information retrieval.
a. Query Language b. Structure Language c. Both a) and b) d. None of the above
50. To retrieve all the columns in a table the syntax is _.
a. Select % from “Table name”; b. Select ** from “Table name” ;
c. Select $ from “Table name” ; d. Select * from “Table name” ;
51. The syntax of the update statement is _.
a. Update set where ; b. Update set where ;
c. Modify set where ; d. Modify set < value> where ;
52. By default, data is arranged in _ order using ORDER BY clause.
a. Ascending b. Descending c. Both a) and b) d. None of the above
53. Which of the following use a systematic way for storing data in database.
a. Query b. Form c. Table d. None of the above
54. __ will help you to display summarized data from the database.
a. Report b. Form c. Table d. None of the above
55. What does referential integrity in a database ensure?
a. All primary keys are unique across the database.
b. All records in a table must have a value in every column.
c. Every foreign key value must match a primary key in the referenced table or be null.
d. Data can be freely deleted from any table without constraints.
56. Data stored in a single table is known as __.
a. Flat File b. Relational c. Both a) and b) d. None of the above