UNIT-2: Electronic Spreadsheet (Advanced)

CLASS 10
Analyze Data Using
6 Scenarios, and Goal Seek
SOLUTIONS

I. TRAIN YOUR BRAIN

A. Multiple Choice Questions.
1. Reference from another worksheet can be selected by
Ans: Source data range
2. This option automatically updates the values when any change happens to
referenced cells.
Ans: Link to source
3. The subtotal function summarises data by creating a group and using inbuilt
functions like
Ans: Sum
4. Consolidated by option in the consolidation dialogue box does not have
Ans: Arranging
5. The Range can be defined in
Ans: Source Data range
6. .......................... allow you to gather data from different worksheets into a worksheet.
Ans: Data Consolidation
7. Consolidate can be found under ................................... menu.
Ans: Data
8. Subtotals ................................... data arranged in a group of cells.
Ans: Add

IT-X This is an attempt to help teachers with Answer key. YEP 51

The teachers have the discretion to choose answers and their formation.
 9. Subtotal is available in ................................... menu.
Ans: Data
10. ................................... is more elaborate form of Goal Seek.
Ans: Solver

B. Write T for True statements and F for False statements.

1. When data in all worksheets are arranged in the same order and location, it is
called consolidated by category.
Ans: False
2. Subtotal displays your formula results according to column group and row labels.
Ans: True
3. The Subsum function summarises data by creating a group and using inbuilt
functions like sum, count, and average.
Ans: False
4. Define Range option is available in the Insert menu.
Ans: False
5. We cannot modify the Range.
Ans: False
6. Comment in a creative scenario dialogue box is optional.
Ans: False
7. We can create only one Scenario for a given range of cells.
Ans: False
8. When we print a spreadsheet, only active Scenario is printed.
Ans: True
9. Each Scenario has a name.
Ans: True

52 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 10. We can give different colors to different Scenario.
Ans: True

C. Answer the following questions.

1. What do you understand by Consolidation?
Ans: Consolidation is the process of combining data from multiple sources into a single
dataset. This can be useful when you need to analyze data from multiple sources sheet
into a single worksheet or workbook.
2. What is the difference between the Source data range and Copy result?
Ans: The source data range refers to the data that will be consolidated, while the copy result
refers to the target location where the consolidated data will be displayed.
3. How can data be analyzed?
Ans: Data can be analyzed using various tools and functions in Calc like consolidation,
Subtotal, Sum, count, Solver, Scenario etc.
4. What is a Plot Area?
Ans: The plot area is the area on a chart that displays the graphical representation of the data.
5. Define Subtotal.
Ans: A subtotal is a sum, or total, of a range of cells in a spreadsheet. Subtotals are typically
used to sum a range of cells that are related, such as a group of same size. The subtotal
function in a spreadsheet program can be used to quickly calculate a subtotal.
6. Give one example of a scenario.
Ans: An example of a scenario could be determining the effect of a change in interest rates
on the cost-effectiveness of a business.
7. How can we change the color of each Scenario?
Ans: We can change the color of each Scenario using the display border option in create
Scenario display box.
8. What is the use of Goal seek?
Ans: Goal seek is a built-in calc tool that allows users to find the desired result of a formula
by changing one input value.

IT-X This is an attempt to help teachers with Answer key. YEP 53

The teachers have the discretion to choose answers and their formation.
 9. Define Solver.
Ans: Solver is used to finding the optimum value for one or more target variables under
certain constraints. Solver deals with a situation where one or more unknown variables
are used. It minimizes or maximizes the results according to the set of values.
10. Which option from the Calc can be used to solve “To find out how many products
need to be sold to reach a certain profit.”
Ans: Goal Seek
11. Write down the steps to calculate subtotal.
Ans:
Step 1. To calculate a subtotal, select the range of cells that you want to sum.
Step 2. Click the subtotal button on the toolbar.
Step 3. A dialog box will appear. Select the type of operation that you want to perform (sum,
average, count, etc.), and click OK.
The subtotal will be calculated and appear in the cell that you selected.
12. What is Consolidation? Write down the steps used to consolidate data.
Ans: Consolidation is the process of combining data from multiple sources into a single
dataset. This can be useful when you need to analyze data from multiple sources sheet
into a single worksheet or workbook.
To consolidate in Calc, follow the following steps:
Step 1: Select the desired worksheet where the consolidated data needs to be placed.
Step 2: Click the cell in the worksheet where you want to place the consolidated data.
Step 3: Go to the Data tab on the Menu bar.
Step 4: Click on Consolidate.
Step 5: The consolidate dialog box opens.
Step 6: Select the data you want to include in Consolidation. Click on Add. The selected
Range now appears on the Consolidation ranges list.
Step 7: Select More data from other worksheets and click Add after each selection.

54 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 Step 8: Specify the cell address where you want to display the result by selecting a target
range from the Copy results to the box.
Step 9: Click + Options.
Step 10: Click on Row labels and Column labels. If you want to change the Consolidation
data as you change in the worksheet, then click on Link to Source data.
Step 11: Click on OK.
13. What are the Options available in Consolidation?
Ans:
1. Function: the desired function can be selected to display consolidated results. The Sum
function is the default setting.
2. Source data range: Reference from another worksheet can be selected.
3. Add button: add button is used to add a reference. Repeat the same step to add all the
references.
4. Consolidation ranges: Display the added references from the workbook.
5. Consolidated by: The row headers and column headers of worksheets can be used by
this option.
6. Links to source data: this option automatically updates the values when any change
happens to referenced cells..
14. What is the use of the sum function in subtotal?
Ans: The sum function in subtotal is used to add up the data within a group of cells.
15. What is What-if analysis?
Ans: What-if analysis can help to analyze data. What-if analysis is a powerful tool that you
can use to explore different scenarios and see how they will affect your results. This
can be especially helpful when deciding what course of action to take in a particular
situation.

IT-X This is an attempt to help teachers with Answer key. YEP 55

The teachers have the discretion to choose answers and their formation.
 16. What are the uses of Goal seek.
Ans: Goal seek is a built-in calc tool that allows users to find the desired result of a formula
by changing one input value.
17. What are the different tools that can be used for what-if analysis.
Ans: The different tools that can be used for what-if analysis include Goal seek, Scenario,
and Solver.

II. CRITICAL THINKING

1. Vaibhav has created a workbook that stores the marks scored by Students in
different tests in different worksheets. Now at the time of report card printing,
he wants to find out the consolidate result which has total of marks scored by
students. How can this be done?
Ans: By using the consolidation option of calc.
2. Vanshika is working in human resource department, she has created a Calc sheet
that displays the name, designation, department, salary drawn and the annual
bonus that each employee will get. She wants to calculate the annual bonus earned
by other department. Suggest how can Rashi do that.
Ans: Using the Subtotal option.

56 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 UNIT-2: Electronic Spreadsheet (Advanced)
CLASS 10
7 Link Data and Spreadsheets
SOLUTIONS

I. TRAIN YOUR BRAIN

A. Multiple Choice Questions.
1. When you open a new Spreadsheet, how many sheets are there by default?
Ans: One
2. The name of the default sheet in the workbook is
Ans: Sheet1
3. By default the sheet tab can be located at the .......................... of the worksheet.
Ans: Bottom
4. New sheet can be inserted by clicking on .......................... Tab.
Ans: Sheet
5. Which of the following is not a type.
Ans: Text
6. Which of the following element is not present at Insert sheet dialogue box.
Ans: Replace the current sheet
7. Hyperlinks in the calc can be used.
Ans: Both a and b
8. If you have two spreadsheets in the same folder linked to each other and move the
entire folder to a new location.
Ans: Relative hyperlink will not break.
9. The Hyperlink is present under
Ans: Insert

IT-X This is an attempt to help teachers with Answer key. YEP 57

The teachers have the discretion to choose answers and their formation.
 10. In calc Link to the external Link is present under.
Ans: Sheet

B. Write T for True statements and F for False statements.

1. When you open a new spreadsheet, it has a sheet named Sheet_1 by default.
Ans: False
2. While you open a workbook, it has one worksheet by default.
Ans: True
3. Insert sheet is present under the Data tab.
Ans: False
4. Right-click on the tab at the bottom of the sheet and select Insert Sheet.
Ans: True
5. Hyperlinks in Calc can be either relative or absolute.
Ans: True
6. Absolute Link will stop working only if the target is moved.
Ans: False
7. A relative link will stop working only if the target is moved.
Ans: True
8. We cannot unshare a spreadsheet once it is shared.
Ans: False
9. Several users can access shared workbooks simultaneously.
Ans: True
10. In the Calc link to external data is in the insert menu.
Ans: False

58 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 C. Answer the following questions.
1. Define absolute Link.
Ans: An absolute hyperlink in Calc is a link to a specific sheet or range within a workbook, or
to an external file, website, or another workbook. You can create an absolute hyperlink
in Calc by selecting the cell where you want the Link to appear and then entering the
URL, email address, or file path into the Hyperlink dialog box.
2. Define Hyperlink in Calc.
Ans: Hyperlinks in Calc are easy to create links to other parts of your spreadsheet or other
files and websites. To create a hyperlink, select the cell you want to link from, then click
the Insert Hyperlink button on the ribbon.
3. Write two uses of cell reference.
Ans: Data from one or more adjacent cells on the worksheet. Data is contained in different
areas of a worksheet.
4. Why do we need Multiple sheets?
Ans: Multiple sheets are needed in a workbook to organize and separate data, perform complex
calculations, and present data in a more understandable and user-friendly manner.
5. Write the ways to reference cells in other sheets.
Ans: The two ways to reference cells in other sheets are by entering the formula directly
using the keyboard or by selecting through a mouse.
6. When can a relative link stop working?
Ans: A relative link will stop working only if the start and target locations change relative to
each other.
7. Write the steps to Insert a new sheet.
Ans:
Step 1. Click on the + located at the sheet tab at the bottom of the worksheet. The new sheet
will be inserted after the active sheet.
Step 2. Go to the Sheet tab, on the menu bar then click on the insert sheet.

IT-X This is an attempt to help teachers with Answer key. YEP 59

The teachers have the discretion to choose answers and their formation.
 8. How to create cell references with the mouse?
Ans:
Step 1: Click on the cell address and type =. The icons change, and that equals sign appears
in the formula bar.
Step 2: Now, Go to the sheet tab and click on the sheet which has the cell to be referenced.
For example April_sale sheet.
Step 3: Click on the cell in the referenced sheet (April_sale). The phrase =$April_sale. (cell
address) appears in the formula bar.
Step 4: Click the green checkmark in the formula bar to finish.
9. How can you create a reference with the keyboard?
Ans: The reference can be created by directly writing the address of that cell with the sheet
name here = is a must before any address, then a $ sign is required to refer to the sheet,
followed by the sheet name, dot, and finally, the cell address you want to refer to.
10. Write the steps to register data sources?
Ans:
Step 1. Go to the Tools tab, then select Options.
Step 2: Select OpenOffice.org Base, and choose Databases.
Step 2. Click the New button to open the Create Database Link dialog.
Step 3: Enter the location of the database file, or click on Browse to locate a file browser and
select the database file.
Step 4: Give a name to the data base which is used as the registered name and then click
on OK. Now the database is added to the list of registered databases then click OK
button.
11. How does Hyperlink work in Calc?
Ans: Hyperlink in Calc works by creating a clickable link that points to a specific location,
such as a cell or a range of cells in the same or a different worksheet. When the user
clicks on the hyperlink, Calc jumps to the specified location.

60 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 II. CRITICAL THINKING
1. Vanshika wants to insert ten sheets in a workbook to store sales of ten items, and
she wants to insert these sheets in one go. Can you help her? She also wants to
create a summary of these ten sheets on one sheet. How can she do all these tasks?
Ans: Right-click on the tab at the bottom of the sheet and select Insert Sheet. A summary can
be done using consolidation.
2. Monika wants to create a set of worksheets for storing records of marks of different
classes and compare all these on a separate worksheet. How can she do this?
Ans: Using consolidation.

IT-X This is an attempt to help teachers with Answer key. YEP 61

The teachers have the discretion to choose answers and their formation.
 UNIT-2: Electronic Spreadsheet (Advanced)
CLASS 10
8 Share and Review a Spreadsheet
SOLUTIONS

I. TRAIN YOUR BRAIN

A. Multiple choice questions.
1. Which of the following fields are unavailable while working on the shared sheet?
Ans: Edit>Compare Document or Data> DataPilot
2. Which version of the Worksheet shows up when all the user changes were saved?
Ans: latest
3. ................................. appears in the dialog box when you accept and reject changes.
Ans: Changes
4. Which column, by default, explains the change made?
Ans: Comment
5. You can edit comments in
Ans: Edit > Changes > Comments
6. Sharing worksheet data offers the following advantages
Ans: Speed up the data entry process
7. The share workbook option is available under .................................. group of review
tab.
Ans: Changes
8. The change history option is available under
Ans: View
9. The comment tab is available under
Ans: Review

62 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 10. The changes are arranged hierarchically with an /a
Ans: + Sign

B. Write T for True statements and F for False statements.

1. When you open a spreadsheet document in shared mode, you see a message that
the Document is in shared mode and that some features are not available in this
mode.
Ans: True
2. Most spreadsheet software automatically turns off some of the features in shared
worksheets.
Ans: True
3. User can accept or reject the changes done by a specific user.
Ans: True
4. The merge and compare option automatically updates the changes found in copied
Worksheet.
Ans: False
5. Original worksheet is required to be compared.
Ans: True
6. The original author of the Worksheet can accept or reject changes made by other
users.
Ans: True
7. Changes from different authors appear in different colors on the Worksheet.
Ans: True
8. The Comment column, by default, contains an explanation of the change.
Ans: False
9. To enable sharing, select the box at the top of the dialog and then click OK.
Ans: True

IT-X This is an attempt to help teachers with Answer key. YEP 63

The teachers have the discretion to choose answers and their formation.
 C. Answer the following questions.
1. Write the advantages of sharing a worksheet.
Ans: Sharing worksheet data offers the following advantages:

h It makes work more accessible and better.

h Save time and effort.
h Used by anyone in the network to whom it is shared.
h Speed up the data entry process.
2. Write steps to share the Worksheet.
Ans:
Step 1: Go to Tools, then select Share Document to activate the collaboration features for
this Worksheet.
Step 2: A dialog box open up from where you can enable or disable sharing. Select the box
at the top of the dialog to enable sharing and click OK.
Step 3: A message box states that you must save the Worksheet from activating the shared
mode. Click Yes.
You will notice the word ‘shared’ at the title bar after the Worksheet’s title.
3. What is the role of comments in a spreadsheet?
Ans: Comments play a significant role in a spreadsheet, allowing users to add notes or
explanations to cells, rows, or columns. Comments can also be used to collaborate with
other users by asking questions or providing feedback on specific cells or ranges.
4. Write steps to insert a comment.
Ans: By using comments on the review tab.
5. Write the steps to merge the Worksheet.
Ans:
Step 1. Open the original Worksheet.
Step 2. Go to Edit, click on Track Changes, then select Merge Document.
Step 3. Locate a file you want to merge from a file selection dialog, then click OK.

64 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 Step 4. After the worksheets merge, the Accept or Reject Changes dialog box opens and
displays the changes made by more than one reviewer.
6. What type of changes are found and marked by the Calc?
Ans: CALC FINDS AND MARKS THE CHANGES AS FOLLOWS:
All the data in the edited Worksheet but not the part of the original worksheet is identified
as inserted. All the data in the original Worksheet but not in the edited Worksheet is
identified as deleted. All data that is changed is marked as changed.
7. Can you edit the comment? How?
Ans: Yes, you can edit comments once made.
Step 1. Go to the “Review” tab, and click on the “Comments” section.
Step 2. Click on the “Edit Comment” button.
Step 3. A new window will open that will allow you to change the comment. Once you have
made the changes you want, click the “Save” button.
8. Write the steps to save a Worksheet.
Ans: Open the spreadsheet and click on the File menu. Then, click on Save As. In the Save
As dialog box, make sure that you select the correct file format. But there are a few
things you need to know first. First, make sure that you have permission to save the
spreadsheet. You need to ask the owner or administrator for permission if you do not
have permission.
9. Where can the spreadsheet be shared? And how?
Ans: Sharing and reviewing spreadsheets can be a great way to get feedback on data or ideas.
There are different ways to share and review spreadsheets. The most basic is emailing
a file copy to someone, but this can be cumbersome if multiple people need to review
it. A better option is to use a service like Google Drive or Dropbox, allowing multiple
people to view and edit the File simultaneously.
Spreadsheets can be shared using the “Share Spreadsheet” option present in the Tools
Tab.

IT-X This is an attempt to help teachers with Answer key. YEP 65

The teachers have the discretion to choose answers and their formation.
 II. CRITICAL THINKING
1. Suppose you are the sponsor of a youth baseball team. The coach has submitted a
budget to you for the season, and you need to edit the costs and return them to her.
You are concerned that if you make the changes, the coach will not see the changes
you made. Which feature should you turn on so that the coach can easily see the
changes you have made?
Ans: To make it easier for the instructor to see what changes have been made, the Track
Changes feature should be turned on. This feature highlights any changes made to the
document and allows the instructor to review and accept or reject as needed.
2. If another user tries to save the shared Worksheet and resolve conflicts, you see
a message that the shared spreadsheet file is locked due to a merge-in progress.
What can you do in this situation?
Ans: If another user attempts to save the shared Worksheet and resolve conflicts, you can
either wait for the merge process to complete or request that the other user release its
changes so you can save your changes. Alternatively, you can create a copy of a shared
worksheet and process it separately to avoid any conflicts.

66 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 UNIT-2: Electronic Spreadsheet (Advanced)
CLASS 10
9 Macros in Spreadsheet
SOLUTIONS

I. TRAIN YOUR BRAIN

A. Multiple choice questions.
1. Which of the following is not a Built-in function?
Ans: Addition
2. Macro can be recorded by clicking on
Ans: Tools tab
3. Macro must be compiled before use, to compile macro press.
Ans: F5
4. ......................................... means the function ends there.
Ans: End Sub
5. ......................................... is the values passed to the function.
Ans: Argument
6. The algorithms which automate the repeated tasks are called .................................
Ans: Macro
7. To record a macro, you need to enable the ..........................................
Ans: Macro
8. We can also ......................................... macro code.
Ans: Both i and ii
9. Macros are useful to ......................................... a task.
Ans: Simplify

IT-X This is an attempt to help teachers with Answer key. YEP 67

The teachers have the discretion to choose answers and their formation.
 10. Click on ......................................... to stop the macro recording.
Ans: Stop recording

B. Write T for True statements and F for False statements.

1. Macro cannot be recorded.
Ans: False
2. You can also write a macro code.
Ans: True
3. Sorting can arrange the data in descending order only.
Ans: False
4. You can use Macro in the sheet for which they are written.
Ans: False
5. A library is a place where macros are saved or stored.
Ans: True
6. The argument is the value called into the function.
Ans: False
7. Calc defines the working of the sum function, so it is called an in-built function.
Ans: True
8. Macros are a great way to automate repetitive tasks in Calc.
Ans: True
9. Once you have enabled macro recording, perform the actions you want to record
and then it automatically stops once the recording is finished.
Ans: True
10. One should know the coding to create a Macro.
Ans: True

68 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 C. Answer the following questions.
1. What are the two types of sorting?
Ans: Sorting is a process that arranges data either in Ascending or Descending order.
2. Which line of code is used to end the function?
Ans: The line of code used to end the function is “End Sub”.
3. Where are macros stored for further use?
Ans: Macros are stored in the library for further use.
4. Which key needs to be pressed to compile the Macro?
Ans: The macro code can be checked for errors by pressing the F5 key.
5. What is the use of Macros in Calc?
Ans: Macros can automate repetitive tasks and help to simplify complex tasks in Calc.
6. Define Macro.
Ans: A piece of programming code or keystrokes that run in a Spreadsheet and help to
automate routine tasks is called a macro. The action or set of actions recorded, saved,
and named in Calc is macro. Macro is nothing but recording mouse clicks and keystrokes
in a sequence in which they are saved to use later.
7. What do you mean by a recorded Macro?
Ans: A recorded Macro is a Macro that is created by recording a series of actions taken in
LibreOffice.
8. What is the use of the library?
Ans: A library is a place where macros are saved or stored for easy access.
9. Write a short note on how to write a macro.
Ans:
Step 1: Go to the Tools menu, click on Macro, and select Record Macro.
Step 2: Perform the action and steps that need to be recorded in the macro.
Step 3: Click on stop recording from the window.

IT-X This is an attempt to help teachers with Answer key. YEP 69

The teachers have the discretion to choose answers and their formation.
 10. How to sort data by using Macro in Calc?
Ans: To sort data by using Macro in Calc, you can start recording the Macro, sort the data as
required, and stop recording the Macro. Once the Macro is saved in the library, you can
use it to sort data with just a single click.

II. CRITICAL THINKING

1. Sonia wants to record a macro, but the recorded macro is not visible to her. Can
you help her by telling her the possible solution?
Ans: If the option of the recorded macro is not visible perform the following steps:
Step 1: Click on Tools, then click on Options.
Step 2: From the left panel in the opened window, click on LibreOffice.
Step 3: Click on Advanced.
Step 4 Enable macro recording.
Step 5: Click on Apply.
2. Madhuri needs to sort her company’s data again and again according to the
salaries of her employees. She wants a button on the screen that can sort data
from the sheet when needed. Is it possible, if yes, and which function of Calc can
be used to do so?
Ans: We can record the sorting process using macros in LibreOffice.

70 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 UNIT-3: Database Management System
CLASS 10
The Concept of Database
10 Management System
SOLUTIONS

I. TRAIN YOUR BRAIN

A. Multiple choice questions.
1. Select the odd one out from the following:
Ans: MySQL
2. A ....................................... keys refer to the combination of two or more attributes
that uniquely identify the records in the table.
Ans: Composite primary
3. The foreign key should be a ....................................... key of another related table.
Ans: Primary
4. Number of columns in a table is known as ....................................... .
Ans: Degree
5. Number of rows in a table is known as ....................................... .
Ans: Cardinality
6. A database is a collection of related.
Ans: Data
7. A .................................... is a computerized Record Keeping system.
Ans: DBMS
8. Which of the following is not a characteristic of DBMS?
Ans: Increase data redundancy
9. ....................................... is a type of Database Management System
Ans: Both a and b

IT-X This is an attempt to help teachers with Answer key. YEP 71

The teachers have the discretion to choose answers and their formation.
 10. Which database is used to retrieve the data from the related table?
Ans: Relational Database Management System
11. Which of the following is an example of RDBMS?
Ans: Both a and b

B. Fill in the following blanks.

1. Row of a table is also known as ....................................... in RDBMS.
Ans: Tuple
2. We can select ....................................... primary key(s) and .......................................
foreign key(s) for a table.
Ans: One, zero or more
3. Processed form of ....................................... is known as ....................................... .
Ans: Data, Information
4. Candidate Keys which are not selected as Primary key are known as ....................
................... .
Ans: Alternate Key
5. A computer running all databases and provide services to all users is a .................
...................... .
Ans: Database Server
6. ....................................... key is used to maintain referential integrity.
Ans: Foreign key
7. The first RDBMS was developed in the year ...................................... .
Ans: 1979
8. ....................... is a named memory location on a computer device that contain data
and processed information.
Ans: File

72 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 9. ............................. database is a type of database that stores data in several tables.
Ans: Relational
10. ................................ database is a type of database that stores a small amount of
data in a single table.
Ans: Flat
11. Maintaining similar formats for data is known as data .......................................
Ans: Inconsistency
12. In the object-oriented data model, the collection of similar objects creates a .........
..............................
Ans: Class
13. Libre Office Base and Open Office base are both examples of FOSS, where ‘F’
means ...................... .
Ans: Free

C. Write T for True statements and F for False statements.

1. A table can have multiple primary keys.
Ans: False
2. A table can have multiple foreign keys.
Ans: True
3. Libre Office Base is an RDBMS.
Ans: True
4. Object network is a kind of database model.
Ans: False
5. We may select more than one column as a primary key collectively.
Ans: True
6. A database can have two tables with the same name.
Ans: False

IT-X This is an attempt to help teachers with Answer key. YEP 73

The teachers have the discretion to choose answers and their formation.
 7. Flat file and Relational are two types of data storage methods.
Ans: True
8. Foxpro is the oldest DBMS software.
Ans: False
9. Data redundancy means data is unique.
Ans: False
10. In the network data model, links are used for the connection.
Ans: True

D. Answer the following questions.

1. What is a database server?
Ans: A computer that provides all database services to authorized users and connects computers
on a network is known as a Database Server. It runs on client-server architecture. These
computers are dedicated to database storage and retrieval from databases.
2. What is Primary Key?
Ans: In a table, a column used to uniquely identify a record is called the Primary key. A
column can be selected as a primary key. It must have unique values and cannot have a
NULL value. Each table can have only one Primary key. The primary key value cannot
be modified or deleted if it is related to some other table. For example, in the Course
table, Courseid is a primary key.
3. Name one rule to be followed while selecting any column as a Primary for the table
Ans: The column or set of columns selected as the primary key should be unique for each
row and should not contain null values.
4. Name any two software that allows using of multiple tables.
Ans: MySQL and MS Access.
5. Explain the concept of the composite key with the help of an example.
Ans: In the place of one column, we may select two or more columns combined as a Primary
key, which is called a Composite Primary key. For example, in a Student table, Roll no
and Class (X102) can be selected as the Primary key.

74 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 6. Write any three examples of DBMS software.
Ans: Oracle and PostgreSQL
7. What do you mean by file?
Ans: A file is a memory location in a memory that holds some data in a specific format.
8. Write the full form for the following abbreviations.
Ans: a. DBMS: Database management system
b. RDBMS: Relational Database management system
c. FOSS: Free and Open-source Software
9. What is a database?
Ans: A database management system is a software package with computer programs that
control a database’s creation, maintenance, and use. It allows organizations to develop
databases for various applications conveniently.
10. What are the advantages of using DBMS over traditional files?
Ans:

h Large Data Storage – DBMS provides the facility to store a large amount of data.
h Reduced Data Redundancy - Data redundancy means duplication of data. It occurs
when the same information is stored in multiple files.
h Easy and Speedy Access to Shared Data- The database’s data is available anytime and
anywhere.
h Minimizes Data Inconsistency- Using proper constraints and similar formats in the
database helps minimize data inconsistency.

IT-X This is an attempt to help teachers with Answer key. YEP 75

The teachers have the discretion to choose answers and their formation.
 11. How is DBMS different from RDBMS? Name four examples for DBMS and
RDBMS software.
Ans:

12. What is a file system? List out the limitations or disadvantages of file- processing
system.
Ans: A file system is a method of organizing and storing data on a computer’s hard drive or
other storage devices. Limitations of file-processing systems include:
a. Lack of data consistency and integrity.
b. Limited data sharing and accessibility.
c. Limited scalability.
d. Data redundancy and inconsistency.
e. Data security issues.
13. What is a data model? Define all types of data models.
Ans: The collection of conceptual tools for describing data and its relation is called a data
model.

h Relational Data Model: It is the most commonly used data model. In this model, data
is organized in tables, where tables are termed relations. A row of a table is known as a
tuple, and a column as attribute.
h Network Data Model: Collection of records connected to each other using links. Links
are data items in terms of a memory address.

76 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 h Hierarchical Data Model: It is similar to the network data model as records are linked
in the form of a tree.
h Object-Oriented Data Model: In this model, values are stored as objects, and all
similar objects are combined to form a class.
14. Why do we need RDBMS? Explain with the help of an example.
Ans: RDBMS is needed to enforce data integrity and consistency in a database. For example,
if a customer orders a product online, RDBMS can ensure that the product and the
customer data are related correctly and that the order is only processed if the product is
in stock.
15. Write any five differences between DBMS and RDBMS.
Ans: Same as Question 11.
16. Mention all the rules to be followed for Foreign key.
Ans: A column that is used to establish a relation between two or more tables in a database
is known as Foreign Key. The Foreign key should be the Primary key of the related
table which is known as the Parent Table. The value of the Foreign key column cannot
have such values, which are not part of a column, that is a Primary key. No value can
be added, modified, or deleted from a Foreign key column if it is related to the Primary
key. For example, Courseid is a Primary key of the Course table. It is the common
column in Student and Course Tables. Courseid is the Foreign Key for Student Table.
17. What is the difference between the Primary key and the Foreign key? Explain with
an example.
Ans: A primary key is a unique identifier for a record in a table, while a foreign key is
a reference to a primary key in another table. For example, in a customer and order
database, the customer table may have a primary CustomerID key, while the order
table may have a foreign key if the CustomerID refers back to the primary key in the
customer table.
18. How are Alternate keys different from Candidate keys?
Ans: All the columns with properties to become a primary key are called Candidate Keys.
Out of all candidate keys, only one can be selected as a Primary key; the rest of the keys
are known as Alternate keys.

IT-X This is an attempt to help teachers with Answer key. YEP 77

The teachers have the discretion to choose answers and their formation.
 19. Define the following terms:
a. Degree
Ans: Total number of columns or attributes in a table is known as the Degree.
b. Tuple
Ans: In a table, value of each column value arranged in a row is known as Record of a table.
In RDBMS, records are known as Tuples.
c. Domain
Ans: A pool of data used to extract related and structured information is known as a Domain.
d. Database
Ans: A database is a collection of related tables or relations.

E. Application Based questions.

1. Aditya was ordering pizza on call. The person on the other side asked for Aditya’s
registered phone number in the beginning. What could be the reason for this?
Ans: To identify him as a registered customer and retrieve his information from their customer
database.
2. Mani has been appointed recently in a company and had to work on a database.
While observing the table, he found that there was no primary key field in the
table. Why did he feel that a primary key field is a must in the table?
Ans: Because it uniquely identifies each record in the table and ensures that there are no
duplicate records.
3. Krishan was asked maintain the data of 1000 employees and all the clients of the
organization. What can be the best way for this?
Ans: Use an RDBMS to maintain records.

78 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 UNIT-3: Database Management System
CLASS 10
Create and Edit Tables Using
11 Wizard and SQL Commands
SOLUTIONS

I. TRAIN YOUR BRAIN

A. Multiple choice questions.
1. Select the correct option to edit the data records.
Ans: Right Click on Table name→Open
2. The default column added in a table, in the absence of Primary key field is named
as ............................. .
Ans: ID
3. We may edit name of the column in ............................. view.
Ans: Design
4. The Boolean column may have ............................. or ............................. values.
Ans: True, False or Yes,No
5. To delete any row from a table, select ............................. .
Ans: Row→Delete
6. Which of the following is not considered as a database object?
Ans: Document
7. Any information can be accessed from the table by using a .................................. . .
Ans: Query
8. Which of the following datatypes will be the most suitable for Gender as M or F?
Ans: Char(1)
9. Which of the following is a method to create a table?
Ans: Table Wizard

IT-X This is an attempt to help teachers with Answer key. YEP 79

The teachers have the discretion to choose answers and their formation.
 10. Select the correct field that can be declared as a primary key.
Ans: Serial number

B. Fill in the following blanks:

1. To insert one more record in a table, open the table in ............................. view.
Ans: Data Sheet
2. Others data type is used for serialized ............................. objects.
Ans: Java
3. ............................. click on column name to set it as Primary key.
Ans: Right
4. To store time of departure for Flight table ............................. data type to be selected.
Ans: Date/Time
5. In Table wizard option we choose the type of table category from .............................
or ............................. .
Ans: Create table in Design View or Use Wizard to create table.
6. The maximum number of characters accepted by a column can be defined under
............................. field property.
Ans: Field Size
7. ............................. view is used to enter and edit records.
Ans: Datasheet
8. ............................. is a piece of software that guides users through a particular task
with a series of instructions.
Ans: Wizard
9. The option ‘Use database Wizard to Create Table’ shows two options
............................. or ............................. .
Ans: Business, Personal

80 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 10. All the fields having fixed but character data must be selected as .............................
datatype.
Ans: Text

C. Write T for True statements and F for False statements.

1. Database Object Pane consists list of all tables in a database.
Ans: True
2. Character is a valid data type in LibreOffice Base.
Ans: True
3. Libre Office Base uses HSQLDB DBMS.
Ans: True
4. Database is a type of object in LibreOffice Base.
Ans: True
5. The default format for Date is mm/dd/yy in LibreOffice Base.
Ans: True
6. Design view is used to create and edit the table structure.
Ans: True
7. Any field can be declared as a primary key field.
Ans: False
8. A Table is the main object of any database used to store information.
Ans: True
9. Float data types are used for storing data in binary form.
Ans: False
10. Datestamp is a combination of both the date and the time.
Ans: True

IT-X This is an attempt to help teachers with Answer key. YEP 81

The teachers have the discretion to choose answers and their formation.
 D. Answer the following questions.
1. What is Table wizard?
Ans: Table wizard is a tool in LibreOffice Base that guides users through the process of
creating a new table. It allows users to choose the type of table they want to create, the
fields to include in the table, and their data types.
2. Name the two ways to create a Table.
Ans:
1. Creating table in Design View.
2. Creating table using Table Wizard.
3. Name four database objects.
Ans:
1. Table: A table is a set of related values, organized in rows and columns, where rows are
known as Records and columns are referred to as Fields. Tables have a defined number
of columns, but any number of rows can be added. Each row in a table is identified by
the values appearing in a particular column, known as the Key field.
2. Queries: A query means filtering data as per a given criterion. In LibreOffice Base, you
may extract information from one or more than one table and filter that information as
per the user’s requirement.
3. Forms: Form is a systematic way of storing information in a predefined layout. It gives
a user-friendly interface to a user to enter, view and edit data directly in database objects
such as tables.
4. Reports: A report is summarized information in a predefined format to generate overall
work outcomes.
4. Name any two numeric data types supported by LibreOffice Base.
Ans: Integers (Whole numbers) and floating-point (Decimals and Real numbers).
5. Write the steps to set a Primary key for a table.
Ans:
1. Open the table in Design View.

82 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 2. Click on the field that you want to set as the Primary key.
3. Click on the Primary Key button in the toolbar.
4. Save the changes to the table.
6. Differentiate between Numeric and Text data type with example.
Ans: A numeric datatype is used to store numbers like int, float, real etc. On the other hand
Text datatype is used to store Alphanumeric values or strings of characters like CHAR
and VARCHAR.
7. Write the steps to create a Table using Design view.
Ans:
Step 1. Select the Tables option from the database objects pane.
Step 2. Click on the Create Table in Design View button in the toolbar.
Step 3. Add fields to the table by typing the field names and selecting the appropriate data
type from the drop-down menu.
Step 4. After completing the above steps, Select Save Icon from the top left or File→Save as
an option.
8. Write the steps to create a Table using Table wizard.
Ans:
Step 1. After selecting the Open database Option from the starting dialog box, select the
second option ‘Use database Wizard to Create Table’.
Step 2. It will show you two options Business or Personal. As per your requirement select the
option.
Step 3. In a drop-down menu, it will give you the list of tables with a predefined column list.
Select the type of table which is nearer to your choice.
Step 4. LibreOffice Table wizard will give a suggested fields list for the table you have
selected.
Step 5. You may select any number of fields for your table or you may add your own fields
as per the requirement.
Step 6. You may select and change the data types as well for any column.

IT-X This is an attempt to help teachers with Answer key. YEP 83

The teachers have the discretion to choose answers and their formation.
 Step 7. Once done with all column detail press FINISH button.
9. Write the steps to add one more column Bus_fee in Student info table.
Ans:
Step 1. Open the "Student info" table in Design View.
Step 2. Click on the column after which you want to add the new column.
Step 3. Click on the "Insert Rows" button in the toolbar.
Step 4. Type "Bus_fee" as the column name.
Step 5. Select the appropriate data type.
Step 6. Save the changes to the table.
10. List all types of Field formats for numbers and text.
Ans:
Numbers datatype:-
h Integer:- TINYINT, SMALLINT, INT, BIGINT
h Floating point:- DECIMAL OR NUMERIC , DOUBLE OR REAL
Text datatype:- VARCHAR, VARCHAR_IGNORECASE, CHAR or CHARACTER,
LONGVARCHAR

E. Application based questions.

1. Ranjana has to declare the datatype for the field Name. He is confused between
char() and varchar(). Suggest him the appropriate datatype with the reason.
Ans: The appropriate datatype for the field Name would be VARCHAR. This is because
VARCHAR is a variable-length character string, which means it can store any number
of characters up to a certain limit.
2. Arjun is creating the structure of a table. Help him define the datatypes for the
following fields:
Ans: a. Sno Integer
b. Date of birth Date
c. Salary Floating (decimal)
d. Interest rate Float (decimal)

84 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 UNIT-3: Database Management System
CLASS 10
12 Perform Operations on Table

SOLUTIONS

I. TRAIN YOUR BRAIN

A. Multiple choice questions.
1. Select the correct option to edit the database structure.
Ans: Right Click on Table name→Edit
2. Sorting option is available in ............................. menu.
Ans: Data
3. ............................. field property is used to display numeric value with currency
symbol.
Ans: Format example
4. Choose the correct option to delete a record in a table.
Ans: Edit→Delete record
5. The property that determines the length of data to be inserted in the field is.
Ans: Length
6. ............................. properties are rules and formats that can be applied to a column.
Ans: Field
7. The key used to maintain referential integrity is ..............................
Ans: Foreign key
8. Which of the following is not a type of relationships?
Ans: One-many to many-one

IT-X This is an attempt to help teachers with Answer key. YEP 85

The teachers have the discretion to choose answers and their formation.
 9. The property that helps you to make the entry necessary in the field is
............................. .
Ans: Entry required
10. ............................. are also called data validation rules and used to maintain the
consistencies of a data in a database.
Ans: Field properties

B. Fill in the following blanks:

1. The record can be added in a table by opening it in ............................. view.
Ans: Datesheet view
2. ............................. property helps in making the entry necessary in the field.
Ans: Entry required
3. ............................. key is used to maintain the referential integrity of a database.
Ans: Foreign Key
4. Field properties are used to maintain data ............................. .
Ans: Consistency
5. All icons for Sorting are available in ............................. tool bar.
Ans: Data
6. Insertion/Deletion or Updatation in rows can be done in ............................. view.
Ans: Datasheet View
7. ............................. is arrangement of data in ascending or descending order.
Ans: Sorting
8. ...................... property determines the length of data that can be inserted in a field.
Ans: Length

86 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 9. The sorting performed on the basis of more than one columns is known as
............................. .
Ans: Multi-level sorting
10. ............................. key is used to set the relation between two or more tables.
Ans: Foreign

C. Write T for True statements and F for False statements.

1. LibreOffice does not allow modifications in record in a table.
Ans: False
2. Format Example is the property used to select the format of an entry in a column.
Ans: True
3. Sorting arranges the data in table on the basis of selected row.
Ans: False
4. Both the tables should have primary key column in one-to-one relationship.
Ans: True
5. There are five types of relationships between two tables.
Ans: False
6. Both tables must have primary key columns in one to many relationship.
Ans: True
7. You can create a relationship between any two tables by selecting the Relationships
option from the Tools menu.
Ans: True
8. Inconsistent data means multiple mismatching copies of the same data.
Ans: True
9. Records cannot be deleted from a primary key table, if there are any matching
related records available in the associated table(s).
Ans: True

IT-X This is an attempt to help teachers with Answer key. YEP 87

The teachers have the discretion to choose answers and their formation.
 10. Referential integrity allows the user to relate two tables and avoid the repeated
information to store.
Ans: True

D. Answer the following questions.

1. What do you mean by sorting data in a table?
Ans: Sorting means arranging data in a table in either ascending order or descending order on
the basis of the selected column.
2. Differentiate between Auto value and Default value of the field.
Ans: In Auto value intrinsic value will be assigned to each new record automatically. In
Default Value property let’s you to enter a default value for the field.
3. Write a short note on Referential Integrity.
Ans: Referential integrity is a rule in RDBMS that ensures the accuracy and consistency of
data within a relationship and prevents users from entering inconsistent data.
4. Draw the icons used for sorting the data.

Ans:

5. Mention any two field properties that can be defined with the data type column.
Ans:
1. Length: This property determines the length of data that can be inserted in this field. If
it’s a decimal field, then the maximum length of the number has to be entered. The value
will be corrected accordingly when it exceeds the maximum for this database.
2. Default Value: This property lets you enter a default value for the field.
6. Explain the different Field properties available in LibreOffice.
Ans:

88 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 1. Auto Value: Choose ‘Yes’, if this field should contain Auto Incremented value. You
cannot enter data in fields of this type. An intrinsic value will be assigned to each new
record automatically (resulting from the increment of the previous record).
2. Length: This property determines the length of data that can be inserted in this field. If
it’s a decimal field, then the maximum length of the number has to be entered. The value
will be corrected accordingly when it exceeds the maximum or this database.
3. Default Value: This property let’s you to enter a default value for the field. If you don’t
enter data in the table, the given value or string is automatically inserted in new record
for the selected field. It should, therefore, correspond to the cell format that needs to be
entered below.
4. Decimal Value: For Decimal or Float type values, this property specifies the number of
decimal places permitted in the field.
5. Entry Required: This property will help you to make the entry necessary in the field.
Choose ‘Yes’, the field must contain data and cannot be left blank. For Primary key
column it is automatically set to ‘Yes’. By default it is ‘NO’.
6. Format Example: This property is used to select the format of an entry in a column.
Various formats are available such as numeric, decimal, date, time, currency , percent
and text alignments.
7. Explain the three types of relationships between tables.
Ans:
1. One-to-One Relationship: Both tables must have primary key columns in this
relationship. For example, each record of a Student_Info table is related to each record
of the Mail_list table.
2. One to Many Relationship: In this relationship, one of the tables must have a primary
key column. It signifies that one column of the primary key table is associated with all
the columns of the associated table. For example, Each row of a Student table is related
to many rows of a Marks table.
3. Many to Many Relationship: In this relationship, no table has the primary key column.
It signifies that all the columns of the primary key table are associated with all the
columns of the associated table. For example, many rows of Teacher table, are related
with many rows of Student table.

IT-X This is an attempt to help teachers with Answer key. YEP 89

The teachers have the discretion to choose answers and their formation.
 8. What do you mean by Form? How is it different from a Report?
Ans: In a database, a form is a graphical interface that allows users to enter and view data in
a structured manner. It is different from a report in the sense that a form is used to enter
and modify data while a report is used to display data in a formatted manner.
9. What is the importance of Referential integrity in a database?
Ans: Referential integrity helps to avoid:

h Adding records to a related table, if there is no associated record available in the primary
key table.
h Values can’t be changed in a primary, if any dependent records are present in the
associated table(s).
h Records cannot be deleted from a primary key table, if there are any matching related
records available in the associated table(s).
10. List all types of Field formats for numbers and text.
Ans: Various formats are available such as numeric, decimal, date, time, currency, percent
and text alignments.

E. Application based questions.

1. Riya has to arrange the data in the table, on the basis of the field Salary. She wants
to have the details of employee with the highest salary on the top and then lower…
and so on. Help her with the steps to perform this task.
Ans: Sorting option in Data Tab
2. Rohan has created the structure of two tables namely Products and Stock. He has
added 10 records in both the tables. Can he establish the one to many relationship
between these tables? If yes, explain how.
Ans: Yes, he can do this by setting relationship between table in Relationship window.

90 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 UNIT-3: Database Management System
CLASS 10
13 Retrieve Data Using Query

SOLUTIONS

I. TRAIN YOUR BRAIN

A. Multiple choice questions.
1. Operator used to check the range of numbers with select statement is
............................. .
Ans: BETWEEN
2. ............................. command will add a record in a table.
Ans: Insert Into
3. We may directly run the SQL statement in ............................. view of Query.
Ans: SQL
4. ............................. is the shortcut key to run a query.
Ans: F5
5. Delete statement removes ............................. .
Ans: Only Table Rows
6. % symbol used with LIKE clause represents ...................... in a pattern matching.
Ans: Zero, one or multiple characters
7. Which of the following database objects is used to retrieve the data from the
database?
Ans: Query
8. Which of the following clause can be used with select command?
Ans: Where

IT-X This is an attempt to help teachers with Answer key. YEP 91

The teachers have the discretion to choose answers and their formation.
 9. The clause used to display the unique values is ............................. .
Ans: DISTINCT
10. The clause used to perform functions on similar data is .............................
Ans: GROUP BY

B. Fill in the following blanks:

1. % and ............................. are the wild card characters used with LIKE.
Ans: _Underscore
2. ............................. clause is used to put a restriction on the number of rows returned
from a query.
Ans: LIMIT
3. ............................. character is used to display all rows from a table, when used with
SELECT.
Ans: *
4. ............................. clause is used to arrange table in alphabetic order as per column
specified.
Ans: ORDER BY
5. ............................. command is used to increase the value of a numeric value.
Ans: Update
6. The full form of SQL is ............................. .
Ans: Structured Query Language
7. ............................. refers to filtering data as per given criterion.
Ans: Filtering
8. SQL commands are categorized as ............................. or .............................
Ans: DDL, DML

92 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 9. ............................. commands are related to creation, modification or updating of
database and Table structure.
Ans: DDL
10. ............................. command is used to add or append rows in a table.
Ans: Insert

C. Write T for True statements and F for False statements.

1. Delete commands remove the table structure.
Ans: False
2. Select is an example of DDL.
Ans: False
3. Symbols used to define conditions are Operators.
Ans: True
4. AND and OR are Logical operators.
Ans: True
5. % and – are the two wild card characters.
Ans: True
6. NOT is an example of relational operator.
Ans: True
7. In SQL <> checks the equality.
Ans: False
8. The default order for sorting is Ascending.
Ans: True
9. Select command displays the rows of a table.
Ans: True

IT-X This is an attempt to help teachers with Answer key. YEP 93

The teachers have the discretion to choose answers and their formation.
 10. FROM clause is used to specify the Field name.
Ans: False

D. Answer the following questions.

1. What do you mean by filtering?
Ans: Filtering means that the query uses criteria you provide to hide some data and display
only the required data.
2. Name the three ways in which Query can be generated.
Ans:
1. Creating Queries using Query Wizard.
2. Creating and Editing Queries in Design View.
3. Create and Edit Query in SQL View.
3. What is the use of NOT BETWEEN clause.
Ans: NOT BETWEEN will display records which are having values beyond the defined
range.
4. What is SQL?
Ans: SQL is the most popular query language used by most of the DBMS and RDBMS. It
is compatible with almost all platforms. It is easy to write statements that uses simple
English words and is not case sensitive.
5. Define the following terms:
a. Form
Ans: Form is a systematic way of storing information in a predefined layout. It gives a user-
friendly interface to a user to enter, view and edit data directly in database objects such
as tables.
b. Report
Ans: Report is a summarized form of your data in a presentable and printable form. LibreOffice
Base lets the user to create Report not only to display data in a formatted way but also
gives the summary of columns, wherever necessary such as weekly Reports, Monthly
Reports, Quarterly Reports, or Annual Reports/bills.

94 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 c. Condition
Ans: Criterion or condition is an expression that you specify on a column, that consist of a
column name, an operator and a value to compare.
d. Query
Ans: A query means filtering data as per the given criterion. In LibreOffice Base you may
extract information from more than one table and filter that information as per user’s
requirement.
6. Differentiate between DDL and DML commands.
Ans: DDL (Data Definition Language): All statements in this category are related to database
schema or structure. All commands related to creation, modification or updating of
database structure comes under this category. One of the DDL statement is Create
Table. On the other hand DML(Data Manipulation Language): All statements in this
category are related to records or tuples. All commands related to manipulate data such
as insertion, displaying, updation, or deletion of data. Some of the DML statements are
Insert, Update, Delete and Select.
7. What is the purpose of LIKE clause? Explain with example.
Ans: LIKE is used for pattern matching. The two wild cards are used: %(percent) and _
(underscore).% (percentage) symbol represent one or more character in the expression
and _ (underscore) represent only one character in the pattern.
8. Write the steps to create a query using SQL view.
Ans:
Step 1. Open SQL view by selecting ‘Create Query in SQL view’ from Database Object
Pane.
Step 2. Select Insert→Query SQL View or Click on the Query icon.
Step 3. In SQL view you start writing the SQL statement in the blank area and press the icon
to check the SQL statement, if there is any error then a dialog box appears and you
may correct your query.
Step 4. To run the Query click on Run Query or Press F5 to display the result.

IT-X This is an attempt to help teachers with Answer key. YEP 95

The teachers have the discretion to choose answers and their formation.
 UNIT-3: Database Management System
CLASS 10
Create Forms and Reports
14 Using Wizard
SOLUTIONS

I. TRAIN YOUR BRAIN

A. Multiple choice questions.
1. ........................................ header is printed on the top of every page of Report.
Ans: Report page header
2. The created report can be edited through ........................................ .
Ans: Report wizard
3. The ........................................ level helps in arranging the data in ascending or
descending order.
Ans: Sorting
4. ........................................ are the graphical elements of any GUI interface.
Ans: Controls
5. ...................................... is the summarized information of a table in printable form.
Ans: Report
6. It is advisable to group your data up-to ........................................ levels while
creating a report.
Ans: 4
7. Which of the following is not a type of data entry for the form?
Ans: Data
8. Creating Forms in design view lets the user to specify the record source, controls
and ........................................ properties.
Ans: Control

96 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 9. In the final step, the name of the form is given and ........................................ button
is pressed.
Ans: Finish
10. The form can be designed from Scratch using ........................................ view.
Ans: Design

B. Fill in the following blanks:

1. ........................................ is printed at the bottom of every page of Report.
Ans: Footer
2. The Report wizard can be used by clicking on ........................................ from
Database Object pane.
Ans: Reports
3. ........................................ is a summarized form of data in a presentable and printable
form.
Ans: Reports
4. ........................................ is a systematic way of storing information in a predefined
layout.
Ans: Table
5. For creating a form, click on Form from ........................................ pane.
Ans: Database object
6. ........................................ view gives you the freedom of selecting any type of control.
Ans: Design
7. You may design Report from the scratch using ........................................ View.
Ans: Design
8. Design view can be opened by selecting ‘Create Report in Design view’ from ........
................................ Pane.
Ans: Database object

IT-X This is an attempt to help teachers with Answer key. YEP 97

The teachers have the discretion to choose answers and their formation.
 9. ........................................ gives a user-friendly interface to a user to enter, view and
edit data directly in database objects.
Ans: Form
10. ........................................ wizard guides the user with the help of predefined steps to
create Forms.
Ans: Form

C. Write T for True statements and F for False statements.

1. The various controls can be inserted from toolbar.
Ans: True
2. Header is printed at the bottom of every page of Report.
Ans: False
3. While creating form, FINISH is clicked in the last step to start the Form wizard.
Ans: False
4. There is no icon for creating a Report in Design view.
Ans: False
5. To start the Form in Design view the option is present in the View menu.
Ans: True
6. Report can be designed using Report wizard or in a Design View.
Ans: True
7. You can create a Report without creating table.
Ans: True
8. You cannot change the orientation from default Landscape to Portrait.
Ans: False
9. User may change the styles and properties for the Controls.
Ans: True

98 YEP This is an attempt to help teachers with Answer key. IT-X

The teachers have the discretion to choose answers and their formation.
 10. You can restrict the data for deletion, addition or modification in records.
Ans: True

D. Answer the following questions.

1. Write the three ways to create a blank form in Design view.
Ans: There are different ways to start the creation of a form from the scratch:

h Click on Form from Database Object Pane from the left and then select the option either
Create Form in Design view’ or ‘Use Wizard to Create Form’.
h Select Insert Form option, it will take you to Design view with a blank Form.
h Click on Form icon from standard toolbar, it will take you to Design view with a blank
Form.
2. What do you mean by Controls?
Ans: Controls are the graphical elements of any GUI interface. User may change the styles
and properties for these elements.
3. Why is it advisable to group the data up to four levels?
Ans: But it is advisable, to group your data up-to four levels otherwise your data will be
segregated in small chunks and create confusion to understand the information.
4. Differentiate between the Report page header and footer.
Ans: Report Page Header is printed on the top of every page of the report and Footer at the
bottom of the report.
5. Define the following terms:
a. Form: Form is a systematic way of storing information in a predefined layout. It gives
a user-friendly interface to a user to enter, view and edit data directly in database objects
such as tables.
b. Report: Report is a summarized form of your data in a presentable and printable form.
LibreOffice Base lets the user to create Report not only to display data in a formatted way
but also gives the summary of columns, wherever necessary such as weekly Reports,
Monthly Reports, Quarterly Reports, or Annual Reports/bills.

IT-X This is an attempt to help teachers with Answer key. YEP 99

The teachers have the discretion to choose answers and their formation.
 6. Write the steps to create a Report using the Report wizard.
Ans:
Step 1. To use the Report wizard, Click on Reports from Database Object Pane from the left
and then select the ‘Use Wizard to Create Report’ option.
Step 2. From the given dialog box select the Table based on which you want to create a
Report, select the Field lists to be included in the Report. Click on NEXT button.
Step 3. In the next step, you may change the labels or headings of all specific columns or
fields. It may give you the change to use any heading that you may think is appropriate
for your data. Click on NEXT button.
Step 4. Now you can group your data on the basis of one or more columns. You can select any
level of grouping. But it is advisable, to group your data up-to four levels otherwise
your data will be segregated in small chunks and create confusion to understand the
information. Click on NEXT button.
Step 5. In this step, you may select the desired layout for your Report. You may change the
orientation from default Landscape to Portrait. The placements of column headings
in a Report and the number of columns will be visible in a row, depending on the
selected layout of the Report.
Step 6. The last step is to specify the name of the report and click on FINISH button. Your
report will be ready for the analysis.
7. Mention different ways to create a Report in Design view.
Ans: Design view can be opened in many ways as follows:
Step 1. By selecting ‘Create Report in Design view’ from Database Object Pane.
Step 2. Select Insert→Report.
Step 3. Click on Report icon. If you have already created a Report using report wizard, then
Right click on the Report name from the Database Objects List Pane and select Edit
option. It will open your report in Design View for editing.
8. Write the steps to create a Form in Design view.
Ans: CREATING FORM IN DESIGN VIEW

100 YEP This is an attempt to help teachers with Answer key. IT-X
The teachers have the discretion to choose answers and their formation.
 Step 1. Creating Forms in design view lets the user to specify the record source, controls and
control properties.
Step 2. We may design Form from the scratch using Design View or edit the Forms created
through Form Wizard.
Step 3. Design view window can be opened by selecting ‘Create Form in Design View’ from
Database Object Pane or by Select Insert→Form or Click on Form icon.
Step 4 If you have already created a Form using Form wizard then Right click on the Form
name from the Database Objects List Pane and select Edit option, it will open your
form in Design View for editing.
9. How are Forms different from Reports?
Ans: Forms are used for data entry, modification, and retrieval directly in database objects,
while reports are used for presenting and summarizing data in a presentable and printable
format.
10. Write the steps to create a Form using the Form Wizard.
Ans:
Step 1. To use the Form wizard, Click on Form from Database Object Pane from the left and
then select the ‘Use Wizard to Create Form’.
Step 2 From the given dialog box select the Table for which you want to create a Form and
also select the Field lists to be included in the Form. After including the required
fields, click on NEXT button.
Step 3 You may select skip and move to the next step, as it will ask if you want to include
this Form as a sub-form for any query. Click on NEXT Button.
Step 4. Now select the appropriate option as required to arrange all controls on the Form
from the given layouts and alignment options. You may see the changes with every
selection side by side. Try out all layouts and once you are satisfied with the layout,
click on NEXT Button.
Step 5. The next step will allow you to set the data entry conditions. You may either use this
form only to enter new data in the table or to display the data. You can restrict the
data for deletion, addition or modification in records.

IT-X This is an attempt to help teachers with Answer key. YEP 101
The teachers have the discretion to choose answers and their formation.
 Step 6. To apply different styles and change background colour , go to next step and select
style and color from the given options. Click on NEXT button.
Step 7. In the final step, give name to your form. The last step is to Click on FINISH button to
close the Form Wizard. It will save your Form as a object and show it in the Database
Object List Pane.

E. Application based questions.

1. Neha has information of around 50 people who have registered for a contest. How
can she store the information in a systematic predefined layout?
Ans: Use base of libre office.
2. Rajan has data stored in the form of information with him. He needs to present
this and print the same. Which object should he use for this purpose and why?
Ans: Rajan can use the Report object to present and print his data in a presentable and
organized manner. A Report object is specifically designed to present data from one or
more tables or queries in a professional and easily readable format.

102 YEP This is an attempt to help teachers with Answer key. IT-X
The teachers have the discretion to choose answers and their formation.