SAI International School

Information Technology (402)

Unit-3 Database Management System
Class - X
A. Multiple choice questions

[1] Which of the following can be considered as an example of a database?

(a) Dictionary
(b) Telephone directory
(c) Marks Register
(d) Newspaper

Ans. (b) Telephone Directory

Dictionary, Marks Register and Newspaper are not a database.

[2] Which of the following is NOT a DBMS?

(a) MS Access
(b)

LibreOffice Base
(c) MS Excel
(d) MySQL

Ans. (c) MS Excel

MS Access, LibreOffice Base and MySQL are DBMS softwares.

[3] DBMS stands for __________.

(a) Data and Books Management System
(b) Database Management System
(c) Duplicate Books Management System
(d) Data Management Multi System

Ans. (b) Database Management System

[4] Which of the following data models sets a relation between the two or more tables?
(a) Relational Data Model
(b) Network Data Model
(c) Hierarchical Data Model
(d) Connection Data Model

Ans. (a) Relational Data Model

(b) Network Data Model – has logical association between the segments
(c) Hierarchical Data Model – data are organized like Tree-Structure
(d) Connection Data Model – used to connect related information between entities
[5] The details associated with an entity are called ________________.
(a) Table
(b) Attributes
(c) Records
(d) Primary key

Ans. (b) Attributes

(a) Table – Intersection of row and column
(c) Records – Set of fields represents one entity
(d) Primary Key – identifies rows uniquely

[6] A ______________ is represented as rows in a table.

(a) field
(b) attribute
(c) record
(d) candidate key

Ans. (c) Record

(a) field and (b) attribute- is represented as column in table
(d) Candidate key – The field which can be a candidate for primary key

[7] In which of the following forms can a data value be represented?

(a) Numeric
(b) Character
(c) Alphanumeric
(d) All of the above

Ans. (d) All of the above

[8] Which of the following uniquely identifies a row in a table?

(a) Primary key
(b) Alternate key
(c) Foreign key
(d) Candidate key

Ans. (d) All of the above

[9] A ___________is a feature of a database using which we can enter data in a table in an easy and user friendly
manner.
(a) query
(b) report
(c) form
(d) field
Ans. (c) Form
(a) Query – To fetch records from table
(b) report – Represent data from tables in summarized manner
(d) field – Represents a column of a table

[10] A __________________ is a question asked from a database.

(a) query
(b) report
(c) form
(d) field

Ans. (a) Query

B. State whether the following statements are True or False

[1] A database cannot be organized.

Ans.: False
A database can be organized in efficient manner.

[2] Data is the collection of raw facts.

Ans.: True

[3] A table can be created without a primary key.

Ans.: True

[4] Two tables can be related in a network data model.

Ans.: False
Two tables can be related in a relational data model.

[5] MS Access is an example of a database.

Ans.: False
MS Access is an example of DBMS.

C. Fill in the blanks

[1] The raw facts constitutes _____________.

Ans.: data

[2] An ________________ is a real world object about which information is to be stored in a database.

Ans.: entity

[3] The output of a query may be displayed in the form of ______________.

Ans.: report

[4] The data values for all the fields related to a person or object is called a _____________.

Ans.: report

[5] All the field values that are eligible to be the primary key are the __________ keys for that table

Ans.: candidate

D. Answer the following questions

[1] Define the terms

(a) Database
(b) Data redundancy
(c) Report

Ans.:
1. Database: A database is a collection of logically related data items stored in an organised manner. The information
being stored in a database can be added, modified, deleted or displayed according to the requirements of the user.
2. Data Redundancy: The same data field repeated in different table is known as data redundancy.
3. Report: The output of query stored formal and proper layout is called report. A report represents the query output
in printed form or summarized manner.

[2] Give one point of difference between

(a) Data and Information,
(b) Form and Query
(c) Network and hierarchical data model

Ans.:

Data Information

Raw facts are known as data Process data or meaningful data is known as information

Only roll numbers, marks, names are data Report cards along with appropriate data are information
1, ‘Madhav’, 98.5 Rollno – 1, Name – ‘Madhav’, Percentage – 98.5

Form Query

A form is a way to supply data in an easy and user friendly Query is used to retrieve information from database
manner. table

A form is used to display and input A query is a question asked from database

Form creates an interface for user Query returns a particular dataset

Network Model Hierarchical Model

Multiple records are linked to same master file Data is organized into tree like structure

It is also considered as invert tree Data is stored in form of records

Master is present at the bottom of the tree and branches It forms a hierarchy and all the records are linked
contains information linked to master each other at various levels

[3] Give any four advantages of a DBMS.

Ans.:
Organized Storage – The data in the database is stored in an organised manner, so that retrieval of the required data
is fast and accurate.
Data Analysis – A database helps in analysis of data based on certain criteria. It is easy to find out maximum or
minimum value, average or mean using a database.
Data Sharing – If the same data set is required for different applications then the database can be shared with other
applications. Hence using a database means making once and using it repeatedly for multiple applications.
Minimal Data Redundancy – In the event of requiring the same data field in several tables the data field might get
repeated in number of tables. This is called as data redundancy. This can be reduced by using DBMS tools.
Data Consistency – By minimizing data redundancy, chances of inconsistent data being stored is reduced. For
example, it should not happen that the name of the student is changed in one table and not in another. Such
inconsistency is reduced by using a DBMS.

[3] Consider the table given below and answer the questions that follow:

Table: Library

Book_ID Book_Name Author_Name Price Publisher

F001 Pride and Prejudice Jane Austen 550 ABC

S004 Amazing Astronomy E. Shane 1050 ABC

C005 IT and Mankind MHA Diwan 2500 HYM

(a) Name the fields in the given table.

(b) Which field should be made the primary key?
(c) Is there any alternate key in the table?
(d) How is primary key different from foreign key? Explain with example.

Ans.:

(a) Field are : Book_ID, Book_Name, Author_Name, Price, Publisher

(b) Primary key: Book_ID as it contains unique records

(c) As far as this table data Book_Name, and Author can be an alternate key

(d) Primary key identifies unique records from relation. The value entered in the filed of primary cannot be
repeated. A foreign key is a value taken from primary key of another table. It can be repeated in the column.

That’s all from NCERT solutions Information Technology Chapter 8 Introduction to Database Management System. I
hope it is helpful for you. If you have any specific concerns, feel free to share your valuable feedback for this
article.

A. Multiple choice questions

[1] Which of the following is NOT a type of text data type?

(a) Memo
(b) Varchar
(c) Float
(d) Char

Ans. (c) float

Memo, Varchar and char are text data types.

[2] A currency data type can only store monetary data that is in dollars.
(a) True
(b) False
(c) Neither a nor b
(d) Both a and b

Ans. (b) False

Currency data type is not supported in LibreOffice Base.

[3] Which of the following data can a date data type store?
(a) Date
(b) Time
(c) Both date and time
(d) Neither date nor time

Ans. (c) Both date and time

[4] Which of the following is true about LibreOffice Base?

(a) It is a

spreadsheet software
(b) It is free and open source software
(c) It can store only character data
(d) It is a licensed software.

Ans. (b) It is free and open source software

(a) It is a DBMS software
(c) It can store multi kind data types
(d) It is not a licensed sodtware

[5] Which of the following methods can be used to create a table in Base?
(a) Using a table wizard
(b) Design View
(c) Both a and b
(d) Neither a nor b

Ans. (c) Both a and b

[6] The related objects of a database can be seen in _____________ pane of the Base Database window.
(a) Database
(b) Task
(c) Title Bar
(d) Menu Bar

Ans. (a) Databse

[7] Which is the shortcut key to open an existing database?

(a) Ctrl+ D
(b) Ctrl+O
(c) Ctrl+E
(d) Ctrl+F

Ans. (b) Ctrl + O

[8] The Design view of Table Creation window in LibreOffice Base is divided into _______ sections or panes.
(a) 2
(b) 3
(c) 4
(d) 5

Ans. (a) 2

[9] While entering records in a table, we can move to the next field by pressing the ________ key.
(a) Tab
(b) Ctrl
(c) Enter
(d) Shift

Ans. (a) tab

[10] Which of the following is true about primary key of a table?
(a) Every table must have a primary key
(b) The data values in primary key field cannot be duplicated.
(c) A primary key field cannot be left blank
(d) All of the above

Ans. (d) All of the above

Now lets discuss type B questions. Type consists of questions of True or False. Lets disucss!

B. State whether the following statements are True or False

[1] The text data can contain special characters.

Ans. True

[2] Memo data type can be used to store descriptive data.

Ans. True

[3] A Boolean data type can have two or more than two values.

Ans. False

[4] We cannot store audio data in LibreOffice Base.

Ans. False

[5] The properties of a field change according to the data type selected.

Ans. False

[6] Field description may or may not be entered while designing a table.

Ans. True

[7] |< is pressed to move to the last record.

Ans. False
[8]

appears when the record is being edited.

Ans. True

[9] A table once created in a database cannot be edited.

Ans. False

[10] Sort dialog box can only help to sort data in ascending order.

Ans. False

In the next section I am going to discuss Type C questions which are Fill in the blanks questions.

C. Fill in the blanks

[1] A data type refers to the type of data that will be stored in ___________ that particular field.

Ans. Datatype
The question is not proper.

[2] The _________________ data is a combination of letters, numbers or special characters.

Ans. Text

[3] ____________________ data type can be used to store Aadhar number.

Ans. Text – To store number With space

[4] The ___________ data type used to store digitized images.

Ans. Binary or Varbinary

[5] The shortcut key to save a table is _____________________.

Ans. Ctrl + S

[6] _____________ on the Base Interface Window displays information about the type of view of the object in the

database.

Ans. Tasks Pane

[7] A ____________________ icon appears before the field name indicating that it is a primary key.

Ans. Key

[8] The data can be entered in a table only in ______________ view.

Ans.: Datasheet

[9] The black pointing arrow just before the field name in a table is called ______________.

Ans.: Record Pointer

[10] The process of arranging the records in particular order on any filed is called _____________.

Ans.: Sorting

D. Answer the given questions

[1] Differentiate between:

(a) Memo and Varchar data type
(b) Number and Decimal data type
(c) Design View and Datasheet view of a table

Memo Varchar

It is used to store up to maximum length data indicated by

It is used to store up to the specified length by user.
user.

It can store the descriptive values having more than 255

It can store text values up to 255 characters.
characters. It can store data up to 64,000 characters.

It can store values like names, cities, locations, any

It can store values like remarks, address, description etc.
other short texts having various length characters.

Number Decimal
 It allows higher numbers and can store more digits than
It can store number as exactly as precise it can defined.
specified

If user has specified Numeric(6,2) that means 6 total If user has specified Decimal(6,2) that means 1-6 total
digitals with 2 decimal places. No more or no less digits digitals with 2 decimal places. Means it can store 11.56
before or after decimals. but not 11.005.

In this data type 0 is automatically ignored and not

It accept 0s in value. For example the 6000.50 will be
displayed in the value. For example, the value 6000.50 will
accepted as 6000.50
be accepted as 6000.5

Design View Datasheet View

It is not a default view of a database table. It is a default view of database table.

It shows only field names and data types of fields of the It shows all the records of tables entered by user along
table but no records. with fields title.

It allows to create or change the table structure only. It allows to change information entered in the table.

Row does not represent any record. As much fields are Each row represents a record in the datasheet view. If
available in the table that much rows are displayed in five records are entered in the table, it displays five
design view. rows.

[2] Name the menu items present on the Base User Interface.

Answer:

Base user interface offers these menu items:

1. File – New, Open, Recent Documents, Close, Wizards, Save, Save As, Save All, Check out, Cancel Check out,
Check in, Export, Send and Exit

LibreOffice

Edit – Undo, Cut, Copy, Paste, Paste Special, Select All, Open Database Object, Edit, Delete, Rename, Create as
View, Edit in SQL view, Form Wizard, Report, Report Wizard, Database – Properties, Connection Type, Advanced
Settings

View – Tables, Queries, Forms, Reports, Toolbars, Status Bar, Sort Ascending, Sort Descending, Refresh Tables,
Preview

Insert – Form, Report, Report Wizard, Query (Design View), Query (SQL View), Table Design, View Design, View
Simple, Folder

Tools – Relationships, User Administration, Table Filter,

5. SQL, Macros, XML Filter Settings, Extensions, Customize, Options

6. Window – Close Window, Database

7. Help – LibreOffice Help, What’s This?, User Guides, Show Tip of the Day, Get Help Online, Send Feedback,
Restart in Safe Mode, Get Involved, Donate to LibreOffce, License Information, Check for Updates, About
LibreOffice

[2] Label the components – Title Bar, Database Pane, Tasks Pane, Status Bar of the LibreOffice Base User Interface.

Answer:
[3] How can we define a primary key in a table?

Answer:

Follow these steps to define primary key:

1. To make a particular field as the primary key, place the mouse pointer before the field name, say Event Id in
our above example and right click.

2. A pop up menu appears. Select the Primary Key option from pop up menu.

3. A key icon appears before the field name indicating that it is a primary key. Click on the key icon.

[4] Write steps to sort the table in descending order of primary key.

Answer:

To sort the table in descending order of primary key follow these steps:

1. Open database and table in datasheet view.

2. Select the Primary Key field.

3. Click on Data > Sort Descending option or Sort Descending icon from toolbar.

4. The fields and records gets sorted in descending order.

[5] What is the use of navigation box with respect to tables in a database?

Answer:

The navigation box is present at the bottom of datasheet view. It allows to navigate through various records in a
database table. It indicates the current record of a table at any time. It has following components:

• Record Selector Box – It is a text box where the currently active record number is displayed. User may enter
the record number to see in this text box.

• Navigation Buttons – These are used to scroll vertically in the table.

o |<: Used to move to first record

o > and <: Used to navigate to Next and Previous record

 o >|: Used to move last record

o +: Used to insert a new record

A. Multiple choice questions

[1] Which of the following actions can be performed once the tables are created in a

database?
(a) Add a field in a table
(b) Rename a table
(c) Delete a table
(d) All of the above

Ans.: (d) All of the above

[2] Which of the following is checked by a

DBMS?
(a) Redundancy
(b) Inconsistency
(c) Both (a) and (b)
(d) Neither (a) nor (b)

Ans.: (c) Both (a) and (b)

Redundancy and Inconsistency are two main advantages of DBMS.

[3] Which of the following is required to set a relationship between the two tables?
(a) Both the tables must be in different databases
(b) Both the tables must have a common field
(c) Both the tables must have the same name
(d) Both tables must be stored in documents folder only.

Ans.: (b) Both the tables must have a common field

[4] If a record is added in a master table, which of the following is NOT true for transaction table
(a) The record in the master table is called the master record
(b) The corresponding record in transaction table can only be entered once.
(c) The record in the transaction table is called the transaction record.
(d) It is possible to add a record in the master table

Ans.: (b) The corresponding record in transaction table can only be entered once.
[5] Which type of relationship exists between a student and the subjects studied by him/her?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) All of the above

Ans.: (b) One-to-many

A rol number can be used to established a relationship.

[6] Consider the following tables. Which type of relationship can be established between the two tables?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) None of the above

Table 1: Item

Item_Code

Item_Name

Price

Qty

Category_Code

Table 2: Item_Category

Category_Code

Cat_Name

Item_Code

Cat_Disc

Ans.: (b) One-to-many

More than one can be used to establish a relationship. Category code and Item code are the fields.

[7] Which of the following menus contains the Relationship option?

(a) Edit
(b) File
(c) Tools
(d) View

”Answer”

[8] The list of tables to be added is displayed in the ____________ dialog box in the Relationship Screen.
(a) Add Tables
(b) Add Databases
(c) Both (a) and (b)
(a) Neither (a) nor (b)

”Answer”

[9] In the relationship design screen, the relationship between the two tables is done using _____________
operation.
(a) Click
(b) Double Click
(c) Drag and Drop
(d) Right click

Ans.: (c) Drag and Drop

[10] Which of the following is NOT an option that can be used to maintain referential integrity in a
database?
(a) No Action
(b) Set NULL
(c) Set Default
(d) Set Value

Ans.: (d) Set Value

Set default and set null can be used as constraints.

B. State whether the following statements are True or False

[1] Redundancy is preferred in a database.

Ans.:False
No redundancy can be avoided in database.

[2] In a table, a record for a particular entity should not be repeated.

Ans.: True

[3] A single field should always have only one data value.

Ans.: False
A single filed should always have more than one values.
[4] If a table is edited, the records already entered in it are deleted.

Ans.: False
No when table is edited, the records remains as it was.

[5] The record in master table should be entered before the corresponding record is entered in the transaction
table.

Ans.: True

[6] In one-to-many relationship, one specific record of the master table has more than one corresponding
records in the related transaction table.

Ans.: True

[7] The Relationship option is present in the Widows menu.

Ans.: False
The Relationship option is present in the Tools menu.

[8] In a database, the referential integrity is maintained by the user.

Ans.: False
The Relationship option is present in the Tools menu.

[19] A relationship is always set between the tables based on a common field.

Ans.: True

[20] If the master record is deleted, the transaction records will always be deleted.

Ans.: False
No if master record is deleted then it is not necessary that transaction records also deleted.
C. Fill in the blanks
[1]A table to be edited is displayed in _____________ view.

Ans.: Design

[2] The most important prerequisite for setting a relationship between the two tables is that there must be a
________________between them.

Ans.: common field

[3] In ________________relationship, one specific record of a master table has one and only one
corresponding record in the transaction table.

Ans.: one-to-one

[4] ___________________is one of the most common types of relationship between the tables in a

database.

Ans.: one-to-many

[5] A record being entered in a ________________ table must always exist in a table.

Ans.: transaction or master or parent or base

[6] The principle of _______________helps prevent missing data by keeping deleted data from getting out
of synch.

Ans.: referential integrity

[7] Creating ________________ between tables restricts the user from entering invalid data in the
referenced fields.
Ans.: relationship

[8] Data integrity is maintained by ______________.

Ans.: DBMS

[9] A relationship between customers and products is an example of ______ relationship.

Ans.: many to many

[10] The ______ window is used to set relationships between the tables.

Ans.: Relation Design

D. Answer the following questions

[1] Give any two advantages of relating a table in a database.

Ans.:
1. Data Redundancy
2. Data Inconsistency

[2] How is redundancy or inconsistency controlled in a database? Explain with an example.

Ans.:
Redundancy: Data redundancy refers to reducing the repeated data field in several tables. It can be controlled by
using primary key or unique key constraints.
Inconsistency: When data redundancy is applied into table it should not happen that the same data changed in one
table should not in another.

[3] Define referential integrity. Who maintains referential integrity in a database?

Ans.:
Referential Integrity refers to establish a relationship between two tables which can help in data redundancy and
prevent missing data by keeping deleted data from getting out of synch. The referential integrity is maintained by
Primary key and Foreign Key.
[4] Differentiate between one to one relationship and one to many relationship. Give suitable examples
to explain your answer.

Answer:

One to one One to many

In one to one relationship, one record of In One-to-Many type of relationship, one

master table has one and only one specific record of the master table has more
corresponding record in the related than one corresponding records in the related
transaction table. transaction table

For example – A table salesman has fields like salesman_id,

For example – A table dept has three fields
salesman_name, city, commission is related with table customer
Deptno, Dname and loc is with with emp
having customer_id, cname, bill_amt and salesman_id as well as
table h having fields like Empno, ename,
related with commission table having fields as com_id,
job, sal, comm, hiredate, deptno.
commission_amt, salesman_id.

[5] Explain many to many relationship with an example.

Ans.:
Many to many relationship the multiple records are related with a master table that correspond to multiple records
in the transaction table.
For example – A company store has tables such as Supplier, Product and Customer where all tables are related with
product id and different ids of supplier as well as customer.

A. Multiple Choice Questions – NCERT Solutions Chapter 11 Queries in Base

[1] Which of the following is refer to asking questions from the database?
(a) Report
(b) Table
(c) Query
(d) Database

Ans.:(c) Query
(a) Reports display the query results in summarized manner
(b) Table is container to store data in tabular form
(d) Database is systematics way to store data in different objects

[2] Which of the following are the ways to design a query?

(a) Wizard
(b) Design View
(c) SQL
(d) All of the above

Ans.: (d) All of the above

Query can be created using query wizard, design view and SQL view in Libreoffice base.
[3] Which is a flexible way to create a query?
(a) Wizard
(b) Design View
(c) Both (a) and (b)
(d) Neither (a) nor (b)

Ans.: (b) Design View

Because it is something like drag drop way to create a query

[4] Into how many parts is the query design window divided?
(a) One
(b) Two
(c) Three
(d) Four

Ans.: (b) Two

Tables and Query specification

[5] Which of the following is NOT true about queries?

(a) It can be created using multiple tables
(b) Multiple queries can be created in a database
(c) A query can run multiple times
(d) A query once created cannot be edited

Ans.: (d) A query once created cannot be edited

A query can be edited any time after its creation

[6] Which of the following is the shortcut key to run the query?
(a) F3
(b) F4
(c) F5
(d) F6

Ans.: (c) F5

[7] Which of the following functions can be performed on numerical data while designing a query?
(a) Sum
(b) Minimum
(c) Maximum
(d) All of the above

Ans.: (d) All of the above

[8] In a Query Design wizard, which of the following buttons is clicked to move a field from ‘Available fields’ list box to
‘Fields in the query‘ list box?
(a) >
(b) < 9
(c) ∨
(d) ∧

Ans.: (a) >

Option b,c and c buttons are not present in query wizard

[9] Which of the following relational operators can be applied to set the criterion while designing a query in
LibreOffice Base?
(a) >
(b) =
(c) !=
(d) All of the above

Ans.: (d) All of the above

There is a printing mistake in this question in textbook, as option D is given as Add a form which is not relevant to
question.

[10] Which of the following dialog box is present when the Query Design window is opened for the first time to
design a query?
(a) Add Table
(b) Add Query
(c) Add Table or Query
(d) None of the above

Ans.: (c) Add Table of Query

[11] Which of the following step is not performed if there is no numerical data to be worked upon in a query?
(a) Selection of fields
(b) Giving Aliases
(c) Summarizing
(d) Selection of tables

Ans.: (c) Summarizing

Now lets discuss True or False statements from NCERT Solutions Chapter 11 Queries in Base.

B. State whether the following statements are True or False

[1] You can run a query only once

Ans.: False
[2] A query cannot be created from multiple tables

Ans.: False

[3] The shortcut key to run a query is F5.

Ans.: True

[4] LibreOffice Base provides us with two ways to create a query.

Ans.: False

[5]vA query with numerical data cannot be saved.

Ans.: False

[6] By default the query result is not sorted.

Ans.: True

[7] A query can be used to display the average value of a numerical field.

Ans.: True

[8] While designing a query, the criterion can be set on only one field.

Ans.: False

[9] Alias is an alternative name for a field in a query.

Ans.: True

[10] In query Design window, the visible check box is selected by default.

Ans.: True

[11] A query once created using a wizard can only be edited in the Design view.
Ans.: True

Lets see Fill in the blanks now for NCERT Solutions Chapter 11 Queries in Base. Here we go!

C. Fill in the blanks

[1] A ________________ is a sort of question asked from a database.

Ans.: query

[2] The result of the query is displayed in _____________ form with field names in columns

Ans.: report

[3] A query can be created in ________ways.

Ans.: three (3)

Using Query Design, Query Wizard and SQL View

[4] The Query Design window is divided into ___________ sections.

Ans.: Two
1 Add Table or Query
2 Query Specification

[5] The shortcut key to run the query is ____________.

Ans.: F5

[6] The conditions to filter the records are set in the ____________ row.

Ans.: criterion

[7] When a table is selected in a Query wizard, the corresponding fields are displayed in the __________________
list box.

Ans.: available fields

[8] The result of the query can be displayed in ____________ or _______________ order of any particular field of the
table.
Ans.: ascending, descending

[9] At the most _____________ search conditions can be given in the query wizard.

Ans.: three (3)

[10] The last step of the Query wizard displays the entire ____________ of the query.

Ans.: overview

[11] The __________________ view is a more flexible method to create a query.

Ans.: design

[12] To edit any query, right click on the _____________ icon of the query that has to be edited.

Ans.: saved query name

[13] In the _____________ row of the Query Design grid, we can type the column heading that will be displayed
instead of field name when we run the query.

Ans.: alias

Now lets start descriptive questions and answers from NCERT Solutions Chapter 11 Queries in Base. Here we go!

D. Answer the given questions

[1] Define a query? What is the need of creating a query in a database?

Ans.: A query is a SQL command used to retrieve, manipulate, or manage data in a database. It acts as a tool for users
to interact with the database and access the required information. It is also a general question asked to database to
fetch records from table(s).
Need of query:
1. Data Retrieval
2. Data Manipulation
3. Filtering data
4. Aggregation or Analysis
5. Data Integrity or Consistency

[2] Rearrange the steps given below so as to create a query using a wizard.

1. Give Alias
 2. Select the fields

3. Set the criterion

4. Set the sorting order

5. Give query name

Answer:

1. Select the fields

2. Set the sorting order

3. Set the criterion

4. Give Alias

5. Give query name

[3] What all information is seen in the overview (last step) of the Query wizard?

Ans.: The overview (last step) of query wizard shows following:

1. Name of query to be assigned
2. creating query by display query or modify query
3. Overview Such as selected fields, Sorting order (ASC or DESC), Search Condition (if any), groups and group
conditions.

[4] What is the use of Alias row in the Design grid of the Query Design window?

Ans.: The alias row in design grid of the query design window shows the alias names for fields selected in the query.
Sometime user don’t want to display the same field name as specified in the table. So other names can be given
using alias row.

[5] Name any four mathematical functions that can be applied to numerical data in a query.

Ans.: The mathematical functions that can be applied to numerical data in query are as follows:
1. sum()
2. max()
3. min()
4. avg()
5. count()

[6] Name the three ways of creating a query in LibreOffice Base?

Ans.: The three ways to create a query are:

1. Using Design View

2. Using Query Wizard

 3. Using SQL View

A. Multiple choice questions

[1] Which of the following toolbars contains the Label tool?
(a) Standard Toolbar
(b) Forms Controls Toolbar
(c) Records toolbar
(d) Formatting toolbar

Ans.:(b) Forms Controls Toolbar

[2] The Record toolbar has the buttons to move to the

(a) first record
(b) second record
(c) last record
(d) all records

Ans.:(d) all records or All of the above

[3] Which of the following is NOT true about forms?

(a) It is the front end for data entry
(b) It can contain only text fields
(c) Graphics can be inserted on the form
(d) It can contain only fixed number of records

Ans.:(b) It can contain only text fields

[4] Which of the following keys is pressed to select only textbox on the form?
(a) Alt
(b) Shift
(c) Ctrl
(d) Tab

Ans.:(c) Ctrl

[5] Which of the following properties in the Properties: Label, Field, text box is used to insert a tool-tip on
the form?
(a) Tool Text
(b) Help Text
(c) Tool Tip
(d) Help Tip
Ans.:(b) Help Text

[6] Which of the following objects of

LibreOffice Base is used to display data retrieved from one or more tables in a presentable manner?
(a) Query
(b) Form
(c) Report
(d) Panel

Ans.: (c) Report

[7] Which of the following values of Date Format property is selected to view a calendar on the form?
(a) Standard (short)
(b) Standard (long)
(c) Default
(d) Standard (Medium)

Ans.:(b) Standard (long)

[8] Which of the following commands on the Forms Control toolbar is used to toggle between Design View
and Form view?
(a) Design Mode
(b) Toggle Mode
(c) View Mode
(d) Print mode

Ans.: (a) Design Mode

[9] Using which of the following objects in a database, can a report be generated?
(a) Tables
(b) Queries
(c) Both a and b
(d) Neither a nor b

Ans.:(c) Both a and b

[10] Which of the following components open along with the Report Wizard?
(a) Report Builder
(b) Add Fields dialog box
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Ans.:(c) Both (a) and (b)

B. State whether the following statements are True or False

[1] Report is an object of a database but form is not.

Ans.: False
Report and Form both are an object of a databse.

[2] We can choose the layout of the form.

Ans.: True

[3] We have to add all fields of the table on the form.

Ans.: False
Not necessarily, we can add the fields on form as per requirements.

[4] There are two ways n which a form can be created.

Ans.: True

[5] A report is generated in a separate window.

Ans.: True

[6] Once a control is added on to the form, it cannot be repositioned.

Ans.: False
A control added on to the form can be repositioned any time.

[7] The Record toolbar has the button to add a new record.
Ans.: True

[8] We can create a report only using a table.

Ans.: False
A report can be created using a query.

[9] By default, the records in a report are sorted in descending order.

Ans.: False
Records in the report are not sorted by default.

[10] We can group data based on a particular field in a report.

Ans.: True

[11] A report can have data only in row and column format.

Ans.: False
A report can have data in any format as per user’s customization.

[12] We can insert both date and time of generation of report.

Ans.: True

[13] A report once created cannot be edited.

Ans.: False
A report once created can be edited anytime.

C. Fill in the blanks

[1] A form can be used for ____________ and _________.
Ans.: Enter, View Data

[2] Each field control consists of a ____________and _____________.

Ans.: label, field value

[3] A __________ is a piece of text that specifies the data that should be entered in the field value text box.

Ans.: label

[4] By default the border of the field text value is displayed in ___________.

Ans.: 3D

[5] A __ is a small piece of text that is displayed when the mouse pointer is placed on a particular control
on the form.

Ans.: tooltip

[6] The default orientation option for a

report is ___________,

Ans.: landscape

[7] A ______________ is the manner in which the labels, field values, titles etc. will be displayed in the
report.

Ans.:layout

[8] The option to insert date and time in the report is present in _______________ menu.

Ans.: insert

[9] A Report Wizard contains _____________ steps.

Ans.: six (6)

[10] A _______________ type of report changes automatically as the field values in the base table or query
change.

Ans.: dynamic

D. Answer the following questions

[1] Give one difference between a form and a report.

Answer:

Form Report

Form is used to enter and view data. Report is used to display data in formatted manner.

Forms can be used for input and output both.

Reports can be used only as output.

Forms can have a single record each. Report can have multiple records on each page.

Forms mostly used for soft copy only display and data entry. Reports are mostly used for hard copy (printed)

[2] What is a field control with respect to forms?

Ans.: A field control in form represents a label and field text to represent a record on form. A label is a piece of text
that specifies the data that should be entered in the field value text box. A field value text box is linked to the
respective field in the table.

[3] Which tool on the Forms Record toolbar is used to insert text on the form?

Ans.: Text Field tool on the Forms Record toolbar is used to insert text on the form.

[4] Name the two ways to create a form in LibreOffice Base.

Ans.: The two ways to create a form in libreoffice base are:

1. Create a form in design vuew
2. Use wizard to create a form
[5] What is the difference between a static and a dynamic report?

Answer:

Static Report Dynamic Report

Display the same data from when they are created. Updates automatically as data changes in the source.

They are text centric and no interactive features. They allows users to interact with data and identify the insights.

Used for daily, monthly or weekly reporting Used for data analysis such as financial analysis, sales funnel etc.

[6] Write the function of Forms Controls toolbar and Records toolbar.

Answer:

Form Controls Records Toolbar

The Form Controls toolbar or sub-menu contains The Records toolbar contains the navigation control buttons
tools that you need to create an interactive form. You in the extreme left. With the help of these buttons, we can
can use the toolbar or sub-menu to add controls to a traverse and view the records in the file. As we move from
form in a text, drawing, spreadsheet, presentation, or one record to another, the record number in the record text
HTML document, for example a button that runs a boxes changes. It also contains command buttons such as
macro. add a new record, save a record, delete a record etc.