CBSE Sample Papers for Class 10 IT Set 1 with Solutions

Students must start practicing the questions from CBSE Sample Papers for Class 10 IT with Solutions Set 1 are designed as per the revised syllabus.

CBSE Sample Papers for Class 10 IT Set 1 with Solutions

Time Allowed: 2 Hours
Maximum Marks: 50

General Instructions:

• Please read the instructions carefully.
• This (Question Paper consists of 21 questions in two sections: Section A & Section B.
• Section A has Objective type questions whereas Section B contains Subjective type questions.
• Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted (maximum) time of 2 hours.
• All questions of a particular section must be attempted in the correct order ;
• Section A – Objective Type Questions (24 Marks):
  • This section has 05 questions.
  • Maries allotted are mentioned against each question/part:
  • There is no negative marking.
  • Do as per the instructions given.
• Section B – Subjective Type Questions (26 Marks):
  • This section has 16 questions.
  • A candidate has to do 10 questions.
  • Do as per the instructions given.
  • Marks allotted are mentioned against each question/part.

Section – A (24 marks)

Question 1.
Answer any 4 out of the given 6 questions on Employability Skills. [1]
(A) ……………………. operating system enables multiple users to work on the same computer at different times or simultaneously.
(a) multiprogramming.
(b) multiprocessors.
(c) multi-user.
(d) multi-tasking.
Answer:
(c) multi-user

Explanation:
A multi user operating system is an operating system that allows more than one user working on different computers to access the resources of single system’s Operating system simultaneously. The systems of users are connected through a network. The OS takes care of each user’s requirements and fulfills them without affecting other users in the network.

(B) ……………………. is a series of postures and breathing exercises practiced to achieve control of body and mind. [1]
(a) Meditation
(b) Nature Walk
(c) Yoga
(d) Physical Exercise
Answer:
(c) Yoga

Explanation:
Yoga is a type of physical exercise that helps in stress management by relaxing our body and mind. [1]

(C) From the following statements, which one is not correct about the Qualities of an entrepreneur
(a) Successful entrepreneurs adapt the habit of hard work from a very early stage.
(b) Entrepreneur should not think optimistically about the future of the business.
(c) Confident entrepreneur must not deviate from his/her decisions too early in case success is delayed.
(d) Entrepreneurs like to function at their own will and rules.
Answer:
(b) Entrepreneur should not think optimistically about the future of the business

Explanation:
Entrepreneurs should always be optimistic. The entrepreneurs who are optimistic are most likely to succeed. Optimism builds up the self-confidence which itself is a key factor to success.

(D) To remove the files of temporary folder, we type in Run dialog box after pressing “Windows button + R” on the keyboard. [1]
(a) #temp#
(b) %temp%
(c) e $temp%
(d) &temp&
Answer:
(b) %temp%

Explanation:
Running %temp% from the Run dialog box will open the Temp folder in Windows. The Temp folder is a directory or location in Windows to store temporary files. These temporary files are created by windows or programs on your computer to hold data temporarily while it is being updated permanently in a file. Clearing this. folder frees up the storage space occupied by these files on disk.

(E) ……………………. is not the quality of self-confident people. [1]
(a) Dependent
(b) Positive Attitude
(c) Hard Working
(d) Commitment
Answer:
(a) Dependent

Explanation:
Self-confidence is a quality that refers to the ability of a person that finds himself/ herself capable of doing the tasks on own. It means that the person has belief in themselves. Thus dependency is not a quality of a self-confident person.

(F) From the following statements, which one is not the positive impact of Entrepreneurship on society: [1]
(a) Stimulates Innovation and Efifciency
(b) Creates Jobs and Employment Opportunities
(c) Solves the problems of the society
(d) Discourages welfare of the society
Answer:
(a) Discourages welfare of the society

Explanation:
An entrepreneur works for the welfare of the society by finding innovative solutions to practical and financial problems. An entrepreneur also creates new job opportunities and thus provides financial support to the society. It also provides solutions to the needs of society with its creative ideas.

Question 2.
Answer any 5 out of the given 6 questions.
(A) key is used to reduce repetitive strain, [1]
(a) Sticky
(b) Serial
(c) Mouse
(d) Toggle
Answer:
(a) Sticky

Explanation:
‘Sticky keys’ is an accessibility feature for the users with mobility issues. It helps the users that have trouble pressing two keys at once. It enables the users to press a key such as Ctrl, Shift, Alt etc. and have it remain active until another key is pressed.

(B) ……………………. means that the query uses criteria you provide to hide some data and display only required data. [1]
(a) Filtering
(b) Report
(c) Sorting
(d) Forms
Answer:
(a) Filtering

Explanation:
Filtering is a process to view records only that you want to display in a database. Filtering can be used to display specific records in a query, form, report or table.

(C) Which of the following application is not appropriate to store data about ABC Bank customers? [1]
(a) Open Offce Base
(b) Open Offce Writer
(c) MS Access
(d) MS Excel
Answer:
(a) Open Office Writer

Explanation:
Open Office Writer is a word processor. A word processor is not able to store records. It is used to create text documents such as letters, notices etc.

(D) When you open a new spreadsheet, by default, it has a sheet named …………………… which is managed using tabs at the bottom of the spreadsheet.
(a) Sheet1
(b) Worksheet1
(c) Untitled1
(d) New Sheet1
Answer:
(a) Sheet1

Explanation:
Sheet 1 is the default name of the first sheet of any workbook. The name of the sheet is given on the tab at the bottom of the sheet which can be renamed by right clicking on the tab.

(E) In a word processor, ……………………. option is selected for a scaled resizing of an image. [1]
(a) Original Size
(b) Image Size
(c) Keep ratio
(d) Relative
Answer:
(c) Keep ratio

Explanation:
The image inserted in a word processor can be resized using the sizing handles. By clicking on ‘Keep Ratio’ the height and width ratio of the image is locked. After this when the image is pulled from the corner handles, the ratio is fixed.

(F) Multiple copies of the same file leads to ……………………. [1]
(a) Data Inconsistency
(b) Data Redundancy
(c) Data Consistency
(d) Foreign Key
Answer:
(c) Data Redundancy

Explanation:
The condition when the same piece of data is stored in two or more separate places in a database, is called data redundancy. The use of primary keys in a database can reduce data redundancy.

Question 3.
Answer any 5 out of the given 6 questions
(A) It is a reference point for the graphics which is created while positioning any image. This point could be the page, or frame where the object is either a paragraph, or even a character in a word processor. [1]
(a) Wrap Text
(b) Anchoring
(c) Alignment
(d) BookMark
Answer:
(c) Anchoring

Explanation:
In a word processor when you anchor an image or graphic with some paragraph or margin, it means that you are associating the image to it. The image or graphic will not move unless the associated object is moves.

(B) Identify the property which help to set the number of characters in text/ varchar type field of a table in DBMS, [1]
(a) Entry Required
(b) Size
(c) Default Value
(d) Length
Answer:
(d) Length

Explanation:
The ‘Length’ property specifies the size of Char and Varchar fields in a database. In the Char and Varchar column the value of length can be from 0 to 255.

Related Theory:
The size of a Char column is fixed to the length you declare at the time of designing the table whereas the Varchar column is of variable length strings.

(C) ………………………. is designed to help users with auditory impairments. [1]
(a) Sound Sentry
(b) Serial key
(c) High Contrast
(d) Show Sounds
Answer:
(a) SoundSentry

Explanation:
Sound sentry is an accessibility feature that is provided for the users with . hearing impairments. It is a technique that provides a visual alert when a sound alert is played. The settings can be changed to a blinking title bar or screen flash at the time when the,computer generates sound.

(D) State whether True or False:
“It is not possible to create a default template in a Word processor” [1]
(a) True
(b) False
Answer:
(b) False

Explanation:
By default the documents in a word processor are created as a blank document or based on its own default template. But you can also create a default template in the word processor. Doing this, you will be able to create your files based on your own template.

(E) Reviewers and authors can add their …………………. to explain their changes in the cell of Spreadsheet [1]
(a) Comments
(b) Worksheet
(c) Hyperlink
(d) Macros
Answer:
(a) Comments

Explanation:
Comments are the notes that can be inserted to any cell in a spreadsheet. It is useful tor the reviewers to add notes or suggestions for changes in any cell.

(F) In Calc, Arguments passed to a macro from Calc are always ……………………. .
(a) Cell Reference
(b) Both a and b
(c) Value
(d) Sheet Reference
Answer:
(b) value

Explanation:
Macros are the recorded keystrokes of the tasks that are performed frequently in a spreadsheet The macros can also be used as functions by passing values in it These vaLues are called arguments.

Question 4.
Answer any 5 out of the given 6 questions. [1]
(A) Identify the website that offers offline blog service for free.
(a) Blogdesk
(b) Qumana
(c) WordPress
(d) both a and b
Answer:
(d) both a and b

Explanation:
An offline blog editor is a tool that allows the bloggers to create blog posts without an internet connection. These blogs can be published later using internet. BlogDesk, Qumana, BlogJet, Bits, Microsoft Word are some of the offline blog editors.

(B) John has written a book consisting of fifteen chapters. He wanted to make the index of the book. Suggest him the option used to create the index automatically in a word processor. [1]
(a) fables
(b) Columns .
(c) Mail Merge
(d) Table of Content
Answer:
(d) Table of Content

Explanation:
A table of contents in a word processor is a list of headings in the order they are given in the document with their relative page numbers. It gives users an overview of the document’s contents and organization.

(C) The length of the field value of text data type is ………………. characters by default in DBMS. [1]
(a) 10
(b) 25
(c) 20
(d) 50
Answer:
(d) 50

Explanation:
The text field in the database is used to store alphanumeric text such as name, address etc. Its default size is 255 characters. The value of the text field ranges from 0 to 255 characters.

(D) A healthy lifestyle helps to keep and improve people’s health and well-being. It does not include: [1]
(a) healthy eating habits
(b) physical activities
(c) stress management
(d) less sleep
Answer:
(d) less sleep

Explanation:
A good sleep is required to relax and recharge the brain so that it is ready to function again the next day. It also reduces the stress caused by routine tasks.

(E) In a spreadsheet using to create a hyperlink to a web FTP or Telnet, click on the icon available in Hyperlink dialog box. [1]
(a) browser
(b) Internet
(c) hyperlink
(d) mail & news
Answer:
(c) Internet

Explanation:
In a spreadsheet one worksheet can be linked to another worksheet or document. For this you have to create a document hyperlink, clicking on opens the linked document or a sheet. To create a link you have to click on Insert → Hyperlink.

(F) A ………………. refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate. [1]
(a) Cell reference
(b) Sheet Reference
(c) Block
(d) Autofill
Answer:
(a) Cell Reference

Explanation:
A cell reference, in a spreadsheet, refers to a different cell or cell range in the active or different worksheet It is given to use the values of the cell or cell range referred to.

Question 5.
Answer any 5 out of the given 6 questions.
(A) identify the mode, where we can modify in the structure of table? [1]
(a) Datasheet view
(b) Design view
(c) Structure view
(d) All of the above
Answer:
(c) Design view

Explanation:
The Design View is a view which allows the user to create and modify the structure of a table. In this view you can add new fields, modify the properties of existing fields and also delete the existing fields.

Caution:
Deleting an existing field will also delete the data stored in that field.

(B) BSNL stands for …………………. [1]
(a) Bihar Sanchar Nigam Limited
(b) Bharat Samachar Nigam Limited
(c) Bharat Sanchar Nigam Limited
(d) None of the above
Answer:
(c) Bharat Sanchar Nigam Limited.

Explanation:
BSNL is a telecom service providing company. It provides wired and wireless telephone and internet services.

(C) ………………… function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily. [1]
(a) Data Combination
(b) Data Consolidation
(c) Data Merging
(d) Data Concatenation
Answer:
(c) Data Consolidation

Explanation:
Data consolidation in a spreadsheet refers to the process of collecting and integrating data from separate worksheets and into a single worksheet Functions like Sum, Average, Count, Max, Min etc. are used on data in the process.

(D) ………………. store data in a single table which is suitable to store less amount of Data. [1]
(a) Flat File (b) Relational
(c) Mini File (d) Single File
Answer:
(a) Flat File

Explanation:
A flat file is a database that stores data in a plain text file. Each line of the text file holds one record. The fields are separated by delimiters, such as commas or tabs. A flat file database cannot contain multiple tables like a relational database can.

(E) In a word processor, by default, evaluates …………………… levels of headings when it builds the table of contents. [1]
(a) 3
(b) 10
(c) 7
(d) 12
Answer:
(a) 3 (As per MS Word)
(b) 10 (As per Libre & OpenOffice -Writer) (Any of the given options)

Explanation:
In MS Word the 3 levels of headings are evaluated by table of contents whereas in Libre & OpenOffice – Writer 10 levels of headings are evaluated as table of contents. Thus, both the answers are correct

(F) In ……………………. Networks, all computers have an equal status and each terminal has an equally competent CPU. [1]
(a) MAN
(b) WAN
(c) Client Server
(d) P2P
Answer:
(d) P2P

Explanation:
P2P stands for Peer-to-Peer. It is a type of network architecture where computers connected to each other share files and data without the need of a central server. In this type of network each computer functions as both client and server

Section – B (26 Marks)
Answer any 3 out of the given 5 questions on Employability Skills
Answer each question in 20 – 30 words.

Question 6.
What are the advantages of the ability to Work Independently? [2]
Answer:
The advantages of the ability to Work Independently:

• Ensures greater learning.
• Individuals feel more empowered and responsible.
• It provides flexibility to choose and define working hours and working mechanisms.
• Failure and success of the task assigned are accounted by individuals.
• Individuals become assets to organizations, groups and nations at large, vi. It ensures creativity and satisfaction amongst individuals

Detailed Answer
The advantages of the ability to Work Independently are as follows:

• Reduces conflicts that might occur while working in a team due to competition between co-workers.
• Increases efficiency as no one can slow down or get into the way of an individual.
• Chance to become your own boss as no one is in-charge or authority to whom one has to reply.
• The credit of failure or success of the task goes only to the individual and not to the whole team.
• An individual feels more responsible and empowered as well.
• Working hours can be flexible for an individual.

Question 7.
Name the Stress causal agents. [2]
Answer:
The Stress causal agents are:

• MENTAL,
• PHYSICAL,
• SOCIAL,
• FINANCIAL

Detailed Answer:
The causal agents of stress are:

• Mental: Mental stress may occur due to conflicts, frustration, internal or social pressure etc.
• Physical: Physical stress occurs due to overexertion, some kind of illness or failure to get enough sleep
• Social Socialstress is caused due to external factors such as disturbed relationships, conflicts with others, death or illness in family etc.
• Financial: Financial stress occurs due to money problems.

Question 8.
What do you mean by Disk Defragmentation? [2]
Ans.
A disk defragmentation removes all unnecessary information that slows down the computer. It shouLd be done at regular intervals which helps the disc space to be used at an optimal level.

Detailed Answer:
When data is written on disk and there is no contiguous space on the disk to store the file, it is stored in fragments. Disk defragmentation is a process of consolidating files stored in fragments on a disk. This process removes all unnecessary information that slows down the computer. It should be done at regular intervals which helps the disc space to be used at an optimal level.

Question 9.
Explain any two Myths about Entrepreneurship. [2]
Answer:
Myths about Entrepreneurship are:
1. The misconception is that every business idea needs to be unique or special.
Each entrepreneur saw customer demand and brought a new idea into their business. A person can take an idea that is already there in the market and do something different with it.

2. The misconception we have is that a person needs a lot of money to start a business.
Every business does not need a lot of capital to start. Depending on how much more. you have or can borrow, you can put that into business with that much money. Once you make more money, you can put that into your business to make it bigger.

3. A misconception we have is that only a person having a big business is an entrepreneur.
No business is big or small. If a person is running a business to fulfill a customer’s need, they are an entrepreneur. Most businesses start small. It becomes big with hard work and creativity.

4. A misconception we have is that entrepreneurs are born, not made.
Only some people have the talent for doing business. An entrepreneur is a person who does whatever it takes to make the business successful.
Being an entrepreneur starts with a way of thinking. You must believe that anything is possible and it shall be achieved. It starts with thinking of an idea that you want to work on, making it different
(Any two out of four Myths can be explained)

Detailed Answer
Myths regarding entrepreneurship are as follows:
1. Every business idea needs to be unique or spfecial A person can take an existing idea in the market and do something different with it

2. A person needs a lot of money to start a business: Entrepreneurship is about passion, commitment and execution of ideas. Money related problems can be solved by funding, debts, loans, investors etc.

3. Entrepreneurs are born talent: Entrepreneurship starts with thinking of an idea that you want to work on and making it different. A person who is self-aware can develop certain qualities and can become an entrepreneur.
[Note: Write any 2 points.]

Question 10.
Write any four roles of Entrepreneurs.
Answer:
Any four roles of Entrepreneurs are:

• Coordinating role
• Agent’s role
• Innovator’s Role
• Risk assumption role
• Imitating role
• Capital formation role:
• Employment Generation role

Detailed Answer
Roles of an entrepreneur are defined as follows:

• Coordinating role: An entrepreneur coordinates various functions of the business involving selection of best possible factors.
• Innovator’s role: As an innovator, an entrepreneur brings new products or services to the market.
• Risk assumption role: This role of an entrepreneur benefits in economic growth. The profit earned is put back in business.
• Capital formation role: Entrepreneurs enable the formation of capital by mobilizing the wealth for the purpose of carrying business and increasing the capital of the company and developing of assets.

Answer any 4 out of the given 6 questions in 20 – 30 words each.

Question 11.
State any two purposes of using Templates in a word document. [2]
Answer:
The purpose of using templates is:

• To save the time.
• It is a predesigned document you can use to create documents quickly without having to think about formatting

Detailed Answer:
The templates are used to create documents due to following reasons:

• It saves time and effort required for formatting.
• It increases the attention of the audience by providing preformatted documents.

Question 12.
Mention any two operations that can be performed using Macros in a spreadsheet. [2]
Answer:
Macros arc used to perform different types of operations in a Spreadsheet:

• Formatting settings to be applied repeatedly in a spreadsheet
• Sorting Data
• Applying any Mathematical functions/ formulas

Detailed Answer:
The templates are used to create documents In spreadsheets, Macros are used to perform different types of operations. Such as:

• Formatting settings to be applied repeatedly in the cell range of a worksheet.
• Sorting data in a table.
• Applying any Mathematical functions/ formulas in a table.

Question 13.
What do you mean by Hyperlinks in Spreadsheets? Give the two different types of Hyperlinks that can be used in Spreadsheets. [2]
Answer:
Hyperlinks can be used in Calc to jump to a ‘ different location from within a spreadsheet: and can lead to other parts of the current file, to different files. It can be stored wthin a file as either Relative or Absolute hyperlinks.

Detailed Answer:
Document Hyperlink in a spreadsheet is defined as a reference to any location, webpage or a document that we can access by clicking the Link Using these links you can combine text as well as other spreadsheet objects such as charts, sheets, images etc. There are two types of hyperlinks in Excel: Relative hyperlink and absolute hyperlink

Question 14.
List Numeric and Alphanumeric Datatypes in OpenOffice Base. [2]
Answer:
Numeric datatypes are: Tinylnt, Smalllnt, Integer. Biglnt, Decimal, Real, Float, Double and Boolean.
Alphanumeric Datatypes are: Char(fix), Varchar, Varcharjgnorecase and Longvarchar(Memo)

Detailed Answer:
Numeric datatypes in OpenOffice Base are: Tinylnt, Smalllnt, Integer, Biglnt, Decimal, Real, Float, Double and Boolean.
Alphanumeric Data Types in OpenOffice Base are: Char, Varchar, Varcharjgnorecase and Longvarchar

Question 15.
Differentiate between Filter keys and Toggle keys in Microsoft Windows. [2]
Answer:
Filter Keys is an accessibility function that tells the keyboard to ignore brief or repeated keystrokes, making typing easier for people with hand tremors.
ToggleKeys is an accessibility function which is designed for people who have vision impairment or cognitive disabilities. When ToggleKeys is turned on computer emits sound cues when the locking keys (Caps Lock, Num Lock, or Scroll Lock) are pressed.

Detailed Answer:

Filter Keys	Toggle Keys
Filter keys is an accessibility feature that instructs the keyboard to ignore brief or repeated keystrokes in order to make typing easier for users with hand tremors,	Toggle keys are the keys on the keyboard that are operated in the same way but with opposite effect on successive occasions. E.g. Caps Lock is a toggle key, pressed to switch between upper case and lower case alphabets.

Question 16.
In which situations Online shopping could be useful? Write any two popular e-commerce websites. 2
Answer:
Online shopping could be useful in situations when:

• A customer does not have sufficient time to visit stores.
• Visiting a store is more expensive than purchasing a product online.

Two popular online transaction websites are:

• Flipkart an online shopping portal for buying consumer products.
• EBay, an online portal for buying and selling goods.

Detailed Answer:
Online shopping is purchasing goods and services through the internet. It could be useful in situations when:

• When a customer does not have enough time to visit stores. Online shopping gives an opportunity to shop from anywhere and anytime.
• Online shopping provides discount offers. At that time visiting a store is more expensive than purchasing a product online. A customer gets heavy discount offers at festival time.

Two popular online transaction websites are:

• Amazon, an online shopping portal for buying consumer products.
• Urban Company, an online portal that provides online customer services such as repairing of electrical appliances, salon services etc.

Answer any 3 out of the given 5 questions in 50- 80 words each. (4 × 3 = 12)

Question 17.
Anshita is preparing spreadsheet notes for her Term Exam. Help her to write short note on the following: [4]

1. Scenarios
2. Goal Seek
3. Solver
4. Subtotal

Answer:
Ashu must apply Goal seek to get the desired result.
1. Scenarios: Scenarios arc a tool to test ‘what- if” questions. Each scenario is named, and can be edited and formatted separately. It is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the Navigator or a drop-down list wnich can be shown beside the changing cells

2. Goal Seek: It is used to calculate a result based upon existing values. Using Goal Seek option under Tools menu, we can discover what values will produce the result that we want.

3. Solver: It is more elaborated form of Goal Seek The difference is that the Solver deals with equations with multiple unknown variables. It is specifically designed to minimize or maximize the result according to a set of rules that we define.

4. Subtotal: SUBTOTAL is a function listed under the Mathematical category when you use the function Wizard (Insert > function). Because of its usefulness, the function has a graphical interface.
SUBTOTAL totals/adds data arranged in an array that is, a group of cells with labels for columns and/or rows. Using the Subtotals dialog, you can select arrays, and then choose a statistical function to apply to them. For efficiency, you can choose up to three groups of arrays to which to apply a function.

Detailed Answer
1. Scenario: A scenario is a type of What- If anaLysis in which you can store multiple values of data in the same ceLls. This helps in comparing the results of varying input values.

2. Goal Seek: A goal seek is a type of What- If analysis tool that is used to find out the correct input value to get a desired output. The target value is first determined and the spreadsheet calculates backwards to find which input value would yieLd the given output.

3. Solver: Solver is a spreadsheet tool that can be used to determine how the desired outcome can be achieved by changing the assumptions in a model. It is a type of what-if analysis and is useful when trying to determine the best outcome on a given set of more than two assumptions.

4. Subtotal Subtotal is a feature of spreadsheets to simplify the addition process when working with huge amounts of data. It lets you do the addition of group wise data which makes it easy to understand the calculation and makes it more meaningful and presentable.

Question 18.
Tanmay is a Class X student. He has learnt Mail Merge option of a Word Processor in his computer period. But he is confused with few terms used to merge documents.
Explain the following briefly, which will help Tanmay better understand the Mail Merge options.
(i) Merge Field
(ii) Data Source
(iii) Main Document
(iv) Mention two types of data on which mail merge can be applied. [4]
Answer:
(i) Merge Field: A merge field is where you want to insert the information from a data source into a main document. Merge fields appear with chevrons (« »).

(ii) Data Source: Data source is a file that contains the names and addresses or any other information that vary with each version of a mail-merge document.

(iii) Main Document: Main document is the document which contains text and graphics. It may be a formal or an official letter.

(iv) Two types of data on which mail merge can be applied are Labels and Letters.

Detailed Answer:
(i) Merge Field: A merge field in mail merge is a placeholder that fetches data from each record from the address database or the data source. The two documents are then merged to generate personalized letters addressing the records fetched in the merge field.

(ii) Data Source: The data source is a file or database that stores information of recipients, such as name, address, etc.

(iii) Main Document: The main text document is a word processor fiLe that contains the main body of the letter, field names and merge instructions. It can also contain graphics.

(iv) Two types of data on which mail merge can be applied are Labels and Letters.

Question 19.
Consider the following table: Sales

(A) How many fields and records are there in Sales table?
(B) Write SQL commands for the following:
(i) Display Sales ID and price of all products whose discount is more than 1000.
(ii) Display the details alphabetically by product name.
(iii) Display product name and sales price after deducting the discount from the price.
Note: Sales price can be calculated as (price-discount) [4 ]
Answer:
(A) Four fields and four records are there in table Sales.

(B) SQL commands:
(i) select Salejd, Price from Sales where Discount > 1000;
(ii) select * from Sales order by Prod. Name;
(iii) select Prod.Name, Price Discount from Sales;

Detailed Answer:
(A) There are four fields and four records in the table Sales. The fields are: Salejd, Prod_ Name, Price and Discount.

(B) SQL Commands:
(i) select * from Sales order by Prod_ Name;
(ii) SELECT * FROM Sales ORDER BY Prod.Name;
(iii) SELECT Prod.Name, Price- Discount FROM Sales;

Question 20.
Your friend owns a chemist shop, he needs to keep records of the medicines with their id’s, date of purchase, expiry date, price, etc. in a database program. But he does not have any knowledge about the database. Explain to him the following to get a better understanding of the DBMS concepts.
(A) What is DBMS? Explain in brief.
(B) Name any two database programs which can be used to create a table and store the data as per the requirement.
(C) Which field can be set as a Primary Key?
(D) Is it possible to make more than one field as a primary key in your table? (Yes/No). Justify your answer. [4]
Answer:
(A) A database management system is a software package with computer programs that controLs the creation, maintenance, and use of a database. Itallows organizations to conveniently develop databases for various applications.

(B) Two databases are:
(a) Microsoft Access
(b) MySQL
(c) OpcnOffice Base

(C) Id field will be suitable for Primary Key.

(D) Yes. we can make more than one column as a primary key in a table and it is known as Composite Primary Key.

Detailed Answer:
(A) A DBMS or Database Management System is an application program designed to manage large amounts of data and run operations on them. It enables users to create and maintain databases by adding, modifying, deleting records in it. It also allows us to create reports, queries and arrange’data in specific order.

(B) The database programs that can be used to work on databases are: Microsoft Access, MySQL, OpenOffce Base.

(C) A primary key is a field that contains a unique data item for each record. Thus, the Id field will be suitable for Primary Key.

(D) Yes, we can make more than one column as a primary key in a’ table and it is known as Composite Primary Key.
[For Visually Impaired Students]

Question 21.
Vicky is a student of class X. He used to get the work based on internet surfing, But he is not aware of the internet and its terminology. Being a friend of Vicky, help him in finding the answers of the following questions.
(A) What do you mean by Internet Service Provider?
(B) Expand the following terms:
i. WAP
ii. W3
(C) Mention any two advantages of Networking.
(D) What is a Blog? Name any two Online Blogs. [4]
Answer:
(A) Networks in which all computers have an equal status are called peer to peer networks whereas in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called client server networks.

(B) Expand the following terms:
(i) Wireless Access Point
(ii) WWW (World Wide Web)

(C) Advantages of Networking are:

• Data Sharing: One of the most important uses of networking is to allow the sharing of data.
• Files Transfer: Users can send text files, spread sheets, documents, presentations, audio files, video files, etc. to other users.
• Hardware Sharing: Hardware components such as printers, scanners. etc. can also be shared. For example, instead of purchasing 10 printers for each user, one printer can be purchased and shared among multiple users thus saving cost.
• Internet Access Sharing: You can purchase a single Internet connection and share it among other computers in a network, instead of purchasing multiple Internet connection for each computer. This is very commonly found in Internet cafe (browsing centres), schools, colleges, companies, etc.
• Usage of network based applications: Such as web browsers, email clients, chat application, audio & video calling, etc. is another advantage. (Any two)

(D) A blog is a discussion style site used by non-technical or technical users for creating personal web pages. Blogs are similar to an online personal diary and simple to use. The advantage of offline blog is, it can be created first and later publish the content when an active internet connection is available.

Detailed Answer:
(A) An Internet Service Provider is a company that provides internet connection and related services to the individuals and organizations. E.g„ Airtel, BSNL, MTNL, Reliance etc.

(B) (i) Wireless Access Point
(ii) WWW (World Wide Web)

(C) Some of the advantages of networking are as follows:

• Data Sharing: The users connected to the internet can share data with each other.
• Files Transfer: Users can send important files such as spreadsheets, documents, videos, image files etc. over the network.
• Hardware Sharing: The Internet also allows sharing of hardware resources. E.g. printer, disk drives etc. it reduces the infrastructure cost.
• Internet Access Sharing: The Internet access can also be shared among users. A single internet connection can be used by all the users connected to the internet.
• Usage of network-based applications: Usage of network-based applications such as web browsers, email clients, chat, audio-video calling etc. are some other advantages, of the network.
  Note: Write any two.

(D) Blog is a kind of website which is also termed as webblog. It is an online diary or journal where entries are posted in reverse chronological order.
[Visually Impaired]

Question 21.
Define the following:
(A) Sorting (with respect to DBMS)
(B) Referential Integrity
(C) Many-to-Many Relationship(with respect to DBMS)
(D) Foreign key [4]
Answer:
(A) Sorting Data Sorting means to arrange the data in either ascending order of descending order. Select the eolumn(s) then click on sort buttons. The data will be displayed accordingly.

(B) Referential Integrity Referential integrity is used to maintain accuracy and consistency of data in a relationship. In Base, data can be linked between two or more tables with the help of primary key and foreign key constraints. Referential integrity helps to avoid:

• Adding records to a related table if there is no associated record available in the primary key table.
• Changing values in a primary if any dependent records are present in associated table(s).
• Deleting records from a primary key table if there are any matching related records available in associated table(s).

(C) Many to Many Relationship: In this relationship, no table has the primary key column. It signifies that atl the columns of primary key table are associated with all the columns of associated table. Example: In the given tables EMP and DEPT, there is no primary key.

(D) Foreign key (FK): identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) tabid. The “one* side of a relation is always the parent, andprovides the PK atributes to be copied. The *many” side of a relation is aLways the child, into which the FK attributes are copied.

Detailed Answer:
(A) Sorting: Sorting refers to the arrangement of records in a meaningful order to make it easier to understand, analyze and visualize. The sorting can be done alphabetically or numerically in ascending or descending order.

(B) Referential Integrity: Referential Integrity refers to the relation between tables in a database. It is a system of rules that ensures the relationship between records in related tables are valid. It also ensures that users do not delete or change the related data.

(C) Many-to-Many Relationships: In many-to-many relationships a record in Table X can have many matching records in Table Y and a record in Table Y can have many matching records in Table X. In this relationship, no table has the primary key column. It signifies that all the columns of primary key table are associated with all the columns of associated table.

(D) Foreign Key: A Foreign key is a field (or collection of fields) in one table, that refers to the Primary key in another table. For e.g. in Student table Roll number will be a primary key. The Roll number field in the Marks table is related to the roll number field of the Student table. In this case the Roll number field of the Marks table will be called foreign key.