Students can access the CBSE Sample Papers for Class 10 IT with Solutions and marking scheme Set 7 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 10 IT Set 7 With Solutions
Time Allowed: 2 Hours
Maximum Marks: 25
TERM-1
General Instructions:
- Please read the instructions carefully.
- This question paper is divided into 3 sections, viz., Section A, Section B, and Section C.
- Section A is of 5 marks and has 6 questions on Employability Skills.
- Section B is of 15 marks and has 20 questions on Subject Specific Skills.
- Section C is of 5 marks and has 7 Competency-Based Questions.
- Do as per the instructions given in the respective sections.
- Marks allotted are mentioned against each section.
- All questions must be attempted in the correct order.
Section – A (5 marks)
(Employability Skills)
Answer any 5 questions out of the given 6 questions.
Answer any 5 questions out of the given 6 questions.
Question 1.
There are many reason why interpersonal communication may fail. While communicating, the message may not be received exactly the way the sender intended and therefore it is important that the communicator seeks _______ to check that their messageis clearly understood. [1]
(a) Description
(b) Feedback
(c) Channel
(d) Sign
Question 2.
Which one of the following is not a barrier to effective communication? [1]
(a) Physical barrier
(b) Linguistic barrier
(c) Interpersonal barrier
(d) Subjective barrier
Question 3.
To perform well at work and life in general, you must be able to manage and improve yourself in various skills. Which of the following skills helps you to prioritize the things you have to do remove waste and redundancy from work? [1]
(a) Responsibility
(b) Time management
(c) Self-awareness
(d) Adaptability
Answer:
(b) Time Management
Explanation:
Time management is the process of planning, organizing, and prioritizing one’s tasks, activities, and responsibilities in a way that allows for the efficient and effective use of time. It involves allocating and utilizing the time to achieve specific goals and meet deadlines to fulfill commitments.
Question 4.
Managing stress is about making a plan to be able to cope effectively with daily pressures. Always keep in mind the ABC of stress management. The acronym ABC stands for: [1]
(a) Ability, Burden, Concise
(b) Adore, Belief, Cause
(c) Adversity, Beliefs, Consequences
(d) Adapt, Balance, Cooperate
Answer:
(c) Adversity, Beliefs, Consequences
Explanation:
The ABC of stress management stands for Adversity, Beliefs, and Consequences, each of which means:
- Adversity: Adversity refers to the external events or situations that trigger stress. These are the challenges, difficulties, or stressors you encounter in life, such as a tight deadline at work, a conflict with a friend, or a financial problem.
- Beliefs: Beliefs represent the thoughts about the adversity and your responses to the stressful situation.
- Consequences: Consequences are the emotional, behavioural, and physiological responses that result from your beliefs about the adversity.
Question 5.
Neha is receiving several mails from companies who are advertising a product or trying to attract her to their websites. Such type of mails are called __________ [1]
(a) Advertising mails
(b) Bulk mails
(c) Spam mails
(d) Labelled mails
Answer:
(c) Spam Mails
Explanation:
Spam mails are unwanted or unsolicited messages sent via email. These messages are typically sent in bulk to a large number of recipients, with the primary purpose of promoting products, services, or content, often for commercial or fraudulent purposes.
Question 6.
A computer automatically runs a basic program called __________ as soon as it is switched on or the power button is pushed on. [1]
(a) BIOS (Basic Input/Output System)
(b) !OS (Input/Output System)
(c) BOSS (Basic On System Startup)
(d) PCS (Power On System)
Answer:
(a) BIOS (Basic Input/Output System)
Explanation:
The BIOS, or Basic Input/Output System, is a software component in a computer that resides in ROM. It performs essential functions as we switch on the computer. It initializes and manages hardware components, conducts self-tests, and facilitates the loading of the Operating System from storage into memory. It also provides a basic set of instructions for input and output operations, and enables computer to communicate with peripheral devices like keyboards and monitors.
Section – B (15 marks)
Answer any 4 questions out of the given 6 questions.
Question 7.
Styles help to improve consistency in a document. Identify the style that is used to format graphic and text frames, including wrapping type, borders, backgrounds and columns. [1]
(a) Numbering
(b) Character
(c) Graphics
(d) Frame
Answer:
d) Frame
Explanation:
In Open Office Writer, “Frame Style” refers to a predefined set of formatting attributes and properties that can be applied to frames. A frame is a container used to hold various types of content within a document, such as images, text boxes, or other objects.
A typical word processor allows following types of styles:
- Paragraph style
- Character style
- Page style
- List style
- Table style
Question 8.
Arguments passed to a macro from Calc are always _________ [1]
(a) Strings
(b) References
(c) Numbers
(d) Values
Answer:
(d) Values
A macro is a set of recorded or written instructions that automate tasks or perform specific actions within a spreadsheet. Macros allow you to automate repetitive tasks.
Arguments in Calc macros refer to the values or variables that you pass to a macro when calling it. Arguments allow you to provide specific input to the macro, which it can then use to perform its tasks.
Question 9.
In a document __________ is used to apply a style to many different areas quickly without having to go back to the Styles and Formatting window and double-click every time. [1]
(a) Fill format mode
(b) Formatting window
(c) Painter mode
(d) Text wrapping
Answer:
(a) Fill format mode
Explanation:
The Fill Format method is useful when you need to format many scattered paragraphs, words, or other items with the same style.
Text wrapping in Open Office Writer refers to the way text flows around or interacts with other objects, such as images, shapes, or tables, within a document. It determines how the text adjusts its position and layout in relation to these objects. Text wrapping options allow you to control the placement of text around an object to create visually appealing and organized documents.
Question 10.
Tanu explained his class that to apply an existing style, except for _______ position the insertion point in the paragraph, frame or page and then double-click on the name of the style in one of these lists. [1]
(a) Window style
(b) Character style
(c) Paragraph style
(d) Cell style
Answer:
(b) Character style
Explanation:
Character styles are applied to groups of characters. They are mainly used when you want to change the appearance of parts of a paragraph without affecting other parts. To apply a predefined character style the text is selected on which the style is to applied.
Question 11.
The ______ window shows the types of styles available for the OpenOffice (OpenOffice.org) component you are using. [1]
(a) Styles and Formatting
(b) Font and Formatting
(c) Insert
(d) Edit
Answer:
(a) Styles and Formatting
Explanation:
The Style and Formatting window provides all the available styles to choose from.
Question 12.
In Writer _________ refers to the reference point for the graphics. This point could be the page or frame where the object is, a paragraph or even a character. [1]
(a) Arrangement
(b) Anchoring
(c) Framing
(d) Text wrapping
Answer:
(b) Anchoring
Explanation:
Anchoring is a feature that allows you to specify how an image or a drawing, is attached or linked to the text within your document. Anchoring determines the object’s position relative to the surrounding text and how it behaves as you edit the document.
Arrangement refers to the layout or positioning of objects such as text boxes, images, or shapes on a page. you can arrange these objects in various ways, like stacking them, aligning them, or distributing them evenly.
Alignment in Open Office Writer refers to the positioning of text within a paragraph or the alignment of objects on the page. You can align text to the left, right, center, or justify, depending on your formatting preferences.
Question 13.
__________ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily. [1]
(a) Summation
(b) Data Consolidation
(c) Data Format
(d) Data Chart
Answer:
(b) Data consolidation
Explanation:
Data consolidation in a worksheet refers to the process of combining data from multiple worksheets into a single summary sheet. This can be useful when you have data distributed across different sheets, workbooks, or files, and you want to analyze or present it m a mote organized and consolidated manner.
Question 14.
Two other toolbars can be opened from Picture Toolbar are: _________ the _________and. [1]
(a) Edit picture, Colour picture
(b) Format, drawing
(c) Graphic Filter toolbar, Colour toolbar
(d) Floating toolbar, Colour toolbar
Answer:
(c) Graphic filter toolbar, Colour toolbar
Explanation:
The ‘Picture’ toolbar appears when a picture is selected which further provides Graphic filter toolbar and Color toolbar.
The graphic filter toolbar is used to apply effects on the selected image. The four type of graphic filters in OpenOffice Writer are – Invert, Smooth, Sharpen, and Posterize.
Question 15.
If you are continually working with the same range, then you may give a name to the range using ________ option under Data Menu. [1]
(a) Define data
(b) Define range
(c) Define reference
(d) Define address
Answer:
(b) Define range
Explanation:
A range is a group of two or more cells in a worksheet. The cells in a range can be adjacent or non-adjacent. A range can be given a meaningful name for the following reasons:
- Giving a meaningful name enhances its readability.
- Ranges associated to a name are shown in the Navigator which allows quick navigation to the associated ranges.
Question 16.
In Calc, 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 ________ groups of array to which to apply a function. [1]
(a) two
(b) three
(c) four
(d) five
Answer:
(b) Three
An array formula is the one that works on the individual values in a range of cells rather than the cell range as a whole The result of an array formula is also on an array.
Question 17.
Solve option under the Tools menu amounts to a more elaborate form of ________. The difference is that the Solver deals with equations with multiple. [1]
(a) Unknown variables, Goals Seek
(b) Variables, Equation
(c) Goal Seek, Unknown variables
(d) Subtotal, Goal seek
Answer:
(c) Goal Seek, Unknown variables
Explanation:
Goal seek is used to determine the value that you need to enter in a single Explanation: Goal seek is used to determine the value that you need to enter in a single.
Question 18.
Usually, you run a formula to calculate a result based upon existing values. By contrast, using _________ you can discover what values will produce the result that you want. [1]
(a) Subtotal
(b) Scenario
(c) Sort Lists
(d) Goal Seek
Answer:
(d) Goal Seek
Scenario is a what-if analysis tool that enables users to explore various possible outcomes by changing input values and observing the impact on calculated results.
Question 19.
Rama and two of her friends are doing survery of genderwise employment rates of their locality as a school project using Spreadsheet. They all want to work simultaneously to complete it on time. What option they should use to access the same Spreadsheet to speed up their work? [1]
(a) Consolidate Worksheet
(b) Shared Worksheet
(c) Link Worksheet
(d) Lock Worksheet
Answer:
(b) Shared worksheet
Explanation:
A shared worksheet, also referred to as a collaborative worksheet, is a spreadsheet that allows multiple users to work on it simultaneously. In this type of worksheet multiple individuals need to contribute to or review data in reaL-time.
A consolidated worksheet refers to a sheet that combines and summarizes data from multiple source sheets into a single destination while applying functions such as sum, average, count, max, etc. This consolidation process is often used to analyze and present data from different departments, regions, or categories in an organized manner.
Question 20.
In Calc, you can use a cell reference in one or several formulas to refer to: [1]
(a) Data from one or more contiguous cells on the worksheet
(b) Data contained in any Software
(c) Data contained in any format in databases
(d) Images in picture gallery
Answer:
(a) Data from one or more contiguous cells on the worksheet.
Explanation:
A cell reference is a way to identify a specific cell within a worksheet. It is a combination of column and row of a cell.
Example:
A5, C8, etc. Cell references are important for creating formulas and performing calculations in spreadsheets.
There are three types of cell references in a spreadsheet.
Relative cell reference: In a relative celt reference, the position of the cell is specified relative to the position of the formula cell. When you copy a formula containing a relative reference to another cell, the reference adjusts based on the relative position of the new formula cell
Example:
C9, B4 etc.
Absolute cell reference: In an absolute cell reference, the position of the cell is fixed and does not change when the formula is copied to another cell. Absolute references are denoted by the use of dollar signs ($).
Example:
$A$6.
Mixed cell reference: In a mixed cell reference one part (either the column or the row) is absolute, and the other part is relative.
Example:
$B5, A$7.
Question 21.
Which one of the following is an example of RDBMS? [1]
(a) Mongo DB
(b) Windows registry
(c) Publisher
(d) Oracle
Answer:
(d) Oracle
Explanation:
RDBMS stands for Relational Database Management System. It is a type of database management system that organizes data into multiple tables with rows and columns. These tables are linked via common fields.
Question 22.
The _______ has evolved since the 1960s to ease increasing difficulties in designing, building and maintaining complex information systems. [1]
(a) Knowledge concept
(b) Formula concept
(c) Database concept
(d) Forms concept
Answer:
(c) Database concept
Explanation:
A database is a structured and systematic way to store information that can be easily accessed, managed, and updated. The data is stored in form of a table with rows and columns.
Question 23.
Writer’s table of contents feature lets you build an automated table of contents from the __________ in your document. [1]
(a) Template
(b) Style
(c) Headings
(d) Tables
Answer:
(c) Headings
Explanation:
Table of Contents is a feature that automatically generates a list of entries, typically chapter or section headings, along with corresponding page numbers. The purpose of a Table of Contents is to provide a quick reference guide to the structure and content of a document, allowing readers to easily navigate to specific sections.
Question 24.
In Calc, to create the reference with the mouse: [1]
(a) Both Spreadsheets need not be open.
(b) Select the cell in which the formula is going to be entered.
(c) There is no need of the *=’ symbol.
(d) Cell reference is not required.
Answer:
(a) Select the cell in which the formula is going to be entered.
Explanation:
You can create cell references using the mouse by selecting the cells you want to reference. For creating cell reference with mouse, you first have to select the cell in which you want to create the formula using references of other cells. Then following the given steps for creating references:
To select a single cell, click on the cell you want to reference. The selected cell will be highlighted.
To select multiple cells, click and hold the left mouse button on the first cell, drag the mouse to cover the desired range, and then release the mouse button.
Question 25.
_________ 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 or even to websites. [1]
(a) Tables
(b) Goal Seek
(c) Auto Sum
(d) Hyperlinks
Answer:
(d) Hyperlink
Explanation:
A hyperlink is a reference or element in a document or web page that, when clicked or activated, directs the user to another location or resource. The hyperlink can be created to navigate to another webpage, file, chart or any other element.
Question 26.
Any settings that can be added to or modified in a document can be saved in a template. Which of the settings below cannot be included in Writer’s Document and saved as a template for later use? [1]
(a) Styles for later use
(b) Printer settings
(c) Format and setting of tables
(d) Formula settings
Answer:
(d) Formula settings
Explanation:
In general, templates in OpenOffice Writer primarily focus on document formatting, styles, layout, and content structure. They serve as a way to create a standardized starting point for new documents. Formulas, on the other hand, are often associated with spreadsheet applications like OpenOffice Calc.
Section – C (5 Marks)
(Competency-Based Questions)
Answer any 5 questions out of the given 7 questions.
Question 27.
Remakant is running a business and has to send letters to a number of delegates. A ________ can also be a quick way to take a list of people’s mailing addresses and generate labels or envelopes with the address for different persons on each label or envelope. [1]
(a) Mail Marge
(b) E-mail
(c) Paragraph
(d) Style
Answer:
(a) Mail merge
Explanation:
Mail merge is a process that allows you to personalize and generate multiple documents, emails or letters using a template and a set of data records. It is commonly used in word processing software to produce a batch of similar documents or emails that are personalized with the individual names and addresses.
The key components of a mail merge includes a main document (or template) and a data source that usually consists of names.
Question 28.
Vineeta has to prepare a report on her research work in which she needs to include images with text. Which feature helps to balance the relation of graphics to the surrounding text, which may wrap around the graphic on one side or both sides, be overprinted behind or in front of the graphic or treat the graphic as a separate paragraph or character? [1]
(a) Arrangement
(b) Alignment
(c) Table of content
(d) Text wrapping
Answer:
(d) Text wrapping
Explanation:
In OpenOffice Writer, the text wrapping feature for graphics allows you to control how text flows around or interacts with an inserted image or drawing. This is particularly useful when you want to position an image within the text and have the text flow around it in a specified way.
Question 29.
Jagriti has inserted an image in a document. She wants to resize the image. Which option of the word processor image format should be selected to let the two dimensions (height and width) change so that the proportion is maintained, allowing for a scaled resizing? [1]
(a) Keep ratio
(b) Keep aspect
(c) Crop
(d) Contrast
Answer:
(a) Keep ratio
Explanation:
Keep ratio refers to the preservation of the original proportional relationship between the width and height of an image when making adjustments or resizing. Keeping the ratio ensures that the image does not become distorted or stretched unnaturally.
Question 30.
Statement I: The data from the consolidation ranges and target range are saved when you save the worksheet.
Statement II: If you later open a worksheet in which consolidation has been defined, this data will not be available again. Consider above two statements, and identify the correct one. [1]
(a) Statement I is wrong
(b) Statement II is wrong
(c)Both the Statements I and II are wrong
(d) Both the Statements I and II are correct
Answer:
(b) Statement II is wrong.
Explanation:
The statement II is false because the data will still be available even when you open the worksheet later.
Question 31.
In Spreadsheets,
Statement I: To consolidate by row labels or column labels, the label must be contained in the selected source ranges.
Statement II: The text in the labels must be identical, so that rows or columns can be accurately matched.
Statement III: If the row or column label does not match any that exist in the target range, it will be appended as a new row or column.
Consider the above three statements, and identify the correct one. [1]
(a) Only Statements I and II are correct
(b) Only Statements II and III are correct
(c) Only Statement II is correct
(d) All the Statements are correct
Answer:
(d) All statements are correct
Explanation:
The consolidation essentially requires that the labels in the source ranges are identical or similar for proper consolidation. If the text in the labels is not identical, you might face challenges in consolidating the data accurately.
Question 32.
Malini wants to store a huge amount of information about her zone in a database. Should not be repeated in her file. Her friend Gargi explained the various benefits of storing data in RDBMS. It helps in preventing/controlling duplication of data. Which of the following terms is used to refer to duplication data?
(a) Data sharing
(b) Data privacy
(c) Data redundancy
(d) Data integrity
Answer:
(c) Data redundancy
Explanation:
- Data Privacy: Data privacy refers to the protection of individuals’ personal information and the control individuals have over how their data is collected, used, and shared. It involves safeguarding sensitive data from unauthorized access, ensuring its accuracy, and respecting individuals’ preferences regarding the handling of their information.
- Data Integrity: Data integrity refers to the accuracy, consistency, and reliability of data throughout its lifecycle. It ensures that data remains unchanged and uncorrupted during storage, processing, or transmission. The goal of maintaining data integrity is to preserve the quality and reliability of information, allowing it to be trusted and used effectively for decision-making, analysis, and other purposes.
Question 33.
Rohan has 7 50,000 that he wants to invest in two mutual funds for one year. Fund Aisa low risk fund with an 18% interest rate and Fund B is a higher risk fund with 21% interest rate. Which feature, of spreadsheets (Calc) will be help him to decide?
(a) Solver
(b) Subtotal
(c) Linking sheets
(d) Macros
Answer:
(a) Solver
Explanation:
A solver is a more elaborate form of Gcal Seek that allows you to solve mathematical problems with multiple unknown variables and a set of constraints on the variables by goal-seeking methods.
TERM-2
General Instructions:
- Please read the instructions carefully.
- This question paper is divided into 03 Sections, viz., Section-A, Section-B, and Section-C.
- Section A is of 5 marks and has 6 questions on Employability Skills.
- Question numbers 1 to 4 are one mark questions. Attempt any three questions.
- Question numbers 5 and 6 are two marks questions. Attempt any one question.
- Section B is of 12 marks and has 12 questions on Subject Specific Skills.
- Question numbers 7 to 12 are one mark questions. Attempt any four questions.
- Question numbers 13 to 18 are two marks questions. Attempt any four questions.
- Section C is of 8 marks and has 3 Competency-based questions.
- Question number 19 to 21 are four marks questions. Attempt any two questions.
- Do as per the instructions given in the respective sections.
- Marks allotted are mentioned against each section/question.
Section – A (5 marks)
(Employability Skills)
Answer any 3 questions out of the given 4 questions. (1 x 3 = 3)
Question 1.
Name the person who combines factors in a creative manner to generate value for customers and create wealth. [1]
Answer:
Entrepreneur
Explanation:
Entrepreneurs are known for integrating various elements, such as ideas, resources, and opportunities, in novel and innovative ways. They are creative as they think outside the box and come up with inventive solutions. They create products or services that offer value, solve problems, or enhance the lives of their target audience. Entrepreneurial activities are often aimed at creating economic value and wealth. This involves not only generating revenue but also building a profitable and sustainabLe business.
Question 2.
Name the skill that helps anyone to lead, guide and supervise people who work for the business. [1]
Answer:
Leadership
Explanation:
Leadership is a multifaceted skill that involves a combination of these and other qualities. Successful leaders continuously develop and refine their skills to meet the evolving needs of their team and the business. Leaders possess a combination of traits, qualities, and skills that enable them to influence and inspire others. The ability to make informed and timely decisions is crucial for effective leadership. Leaders inspire and motivate their team to achieve their best performance.
Question 3.
Name any two elements of nature. [1]
Answer:
Water, Earth, and Air.
Explanation:
Entrepreneurs can use natural resources to create new products and services, generate jobs, and stimulate economic growth and development. The efficient and sustainable use of these resources is crucial for both the success of the business and the well-being of the environment.
Question 4.
Give any one method that we can adopt to promote Sustainable Development. [1]
Answer any 1 question out of the given 2 questions. (2 x 1 = 2)
Question 5.
Differentiate between Agricultural Entrepreneurship and Small Scale Entrepreneurship with one point only. [2]
Answer:
Agricultural Entrepreneurship | Small Scale Entrepreneurship |
It focuses specifically on entrepreneurial activities related to agriculture, involving the cultivation of crops, raising livestock, agribusiness, and related activities. | Small-scale entrepreneurship refers to small businesses and startups operating on a smaller scale in terms of workforce, revenue, and market reach. |
Agricultural entrepreneurs deal with the unique challenges and opportunities within the agricultural sector, such as crop management, livestock farming, and agro-processing.
Small scale entrepreneurship ventures can span diverse fields, including retail, services, manufacturing, and technology, among others.
Question 6.
In our daily life we can contribute to create a Sustainable Society by following 4Rs’ and 1U of Sustainability. Explain any one term out of 4Rs’ and 111. [2].
Section-B (12 Marks)
Answer any 4 questions out of the given 6 questions. (4 x 1 = 4)
Question 7.
________ is an organization which provides you with access to the internet via a dial-up or direct or wireless connection. [1]
Answer:
ISP
Explanation:
ISP stands for Internet Service Provider. BSNL, Airtel, Jio are among the major ISPs in India.
Question 8.
Name the software or hardware security device that analyzes the network traffic and determine if the traffic should be allowed or not. [1]
Answer:
Firewall
Explanation:
A firewall is a network security device or software that monitors and controls incoming and outgoing network traffic based on predetermined security rules. It acts as a barrier between a trusted internal network and untrusted external networks, such as the internet. The primary purpose of a firewall is to establish a security perimeter and prevent unauthorized or malicious access to or from the protected network.
Question 9.
__________ is the immediate assistance provided to the injured to save life and minimize health loss till the proper medical aid/facility is provided. [1]
Answer:
First Aid.
Every organization must have a first aid kit which should include necessary items such as Hydrogen Peroxide, Calamine lotion, Aspirin etc. These items should be regularly checked for the expiry and replaced whenever required.
Question 10.
When primary key constraint is applied on one or more columns then it is known as ___________. [1]
Answer:
Composite primary key
Explanation:
A composite primary key is a combination of two or more columns that uniquely identifies each row in a table. When a table has a composite primary key, it means that the primary key consists of two or more columns. The combination of values in these columns must be unique for each record in the table.
A primary key is a special database constraint that uniquely identifies each record in a table. It ensures that there are no duplicate rows and provides a way to establish relationships between tables.
Question 11.
A row that represents a single data item in a table is known as ________, __________. [1]
Answer:
Record or tuple
Explanation:
A table in a database consists of rows and columns. A row is a horizontal element and holds a single group of related data within a table. It is also known as a tuple.
Columns are vertical and hold a list of values all from the same field. These are also known as attributes.
Question 12.
Explain the term Sorting. [1]
Answer:
Sorting refers to arranging the table data in increasing or decreasing order.
The SQL command ORDER BY is used to sort the records. By default, the records are arranged in ascending order, but using the keyword DESC, you can arrange them in descending order.
Answer any 4 questions out of the given 6 questions. (2 x 4 = 8)
Question 13.
Write any four rules which is to be followed for creating strong passwords. [2]
Answer:
- Use combination of letters, symbols and digits to create a password.
- Do not use date of birth or any easily identifiable words.
- Generate random password.
- Avoid using the words that are close to your likes or dislikes. These words are easily identifiable by friends.
Question 14.
What is the special name given to the discussion style site used by non-technical (or technical) users for creating personal web pages? Give any two examples of websites that help us to create such discussion style sites for free. [2]
Answer:
Blog Websites to create blogs are www.wordpress. com and www.blogger.com
A blog is a type of website or an online platform where individuals, groups, or organizations share information, opinions, and updates on various topics. The term blog is a shortened form of weblog. Blogs are often characterized by a series of posts or articles presented in reverse chronological order, with the newest content appearing at the top of the page.
Question 15.
Differentiate between LAN and WAN with two points only. [2]
Answer:
LAN | WAN |
It stands for Local, Area Network. | It stands for Wide Area Network. |
It connects computers and peripherals in limited geographical area. Example: School, office, building, etc. | It connects devices in large areas such as metropolitan area, across regional or national boundaries. Example: Internet. |
It offers high speed data transfer and uses ethernet cables to connect devices. | The data transfer rate is very slow as compared to LAN and it uses telephone lines, or wireless mediums to connect devices. |
Question 16.
Explain any two types of relationship that can be created in tables. [2]
Answer:
The database tables support the following types of relationships:
- One to One: In this relationship both tables of the relational database must have primary key columns. Each record in one table is directly related to a single record in another table, and vice versa. This relationship is established using a common key, typically a primary key in one table and a foreign key in the other.
- One to many: A one-to-many relationship is a type of association between two tables where each record in the primary table can have multiple related records in the secondary table, but each record in the secondary table is associated with only one record in the primary table. This relationship is often established using primary and foreign keys.
- Many to many: A many-to-many relationship in relational databases refers to an association between two tables where each record in one table can be related to multiple records in the other table, and vice versa.
Question 17.
What is the difference between Forms and Reports? [2]
Answer:
Form | Reports |
Form provides user friendly interface to view, add and modify data in both tables and queries. | Forms are created for the ease of data entry. They often include text boxes, drop down lists, radio buttons, and check boxes to facilitate data input. |
Reports are used to present data in structured and organized format from one or more tables or queries. | Reports focus on conveying information. They include features like tables, charts, and graphs to present data in a visually appealing manner. |
Question 18.
Identify any two Column name/Attribute and their data types from a given table: PLAYER [2]
P ID | PNAME | RUNS | GENDER | DOB |
P101 | SACHIN | 13000 | M | 10/04/2001 |
P102 | KAPIL | 700 | M | 12/02/1998 |
P103 | SAURABH | 12000 | M | 13/04/2001 |
P104 | VI RAT | 12500 | M | 17/03/2005 |
Answer:
The attributes and their data types are as follows:
Attribute Name | Data Type |
PID (Primary key) | Char (4) |
Pname | Varchar (10) |
Runs | Int (5) |
Gender | Char (1) |
DOB | Date |
Section – C (8 Marks)
(Competency-Based Questions)
Write any 2 questions out of the given 3 questions:
Question 19.
Aryan is too much worried when he came to know that someone has withdrawn all money from his uncle’s bank account. He was not able to understand how this could happen when he has not given his ATM card to anyone.
(A) Suggest him a way by which he can be assured that he is doing secured online transaction. [1]
Answer:
He should ensure that the URL of the website must have lock icon at the beginning and starts with HTTPS.
(B) Which type of software he needs to install in his computer to protect his computer from malware? [1]
Answer:
He can use a good antivirus software to protect his computer from malware.
(C) Help him to understand about Phishing. [1]
Answer:
Phishing is a type of cyberattack in which attackers use fraudulent communication, often disguised as a trustworthy entity, to trick individuals into revealing sensitive information, such as passwords, credit card numbers, or personal details. The primary goal of phishing is to exploit human psychology and manipulate individuals into taking actions that compromise their security.
(D) He also thinks cookies are harmless. Explain him how cookies can also cause harm to him. [1]
Answer:
Cookies are small pieces of data stored on a user’s device by a web browser while the user is browsing a website. The cookies can be harmful as these store login details, details of a shopping cart, visited pages in a website, details of bank accounts etc. They could be used by unauthorized users to track and possibly gain access to personal information.
Question 20.
Due to pandemic everyone was bound to stay at home. But, due to internet the whole world was connected. [4]
(A) What is meant by World Wide Web? Also write any two web browsers names that you know.
Answer:
World Wide Web (abbreviated as WWW or W3) is commonly known as the Web. It is a system of interconnected documents and resources, linked by hyperlinks and URLs (Uniform Resource Locators). The World Wide Web is a vast information space accessible over the internet allowing users to navigate and interact with text, images, videos, and other multimedia content Two popular web browsers are: Google Chrome and Mozilla Firefox.
(B) Explain how data is transferred over internet.
Answer:
The data transfer on the internet is done through the following steps:
- Data transfer begins with a sender, who wants to share information, and a receiver, who is supposed to receive that information.
- The data to be sent is divided into smaller chunks or packets. These packets are like digital envelopes containing pieces of the information.
- Each packet includes a header that contains important information, such as the destination address, source address, and the order of the packet in the sequence.
- The packets travel across the internet using various means, including wired (fiber-optic cables) or wireless (satellites, radio waves) connections.
- Upon reaching the destination, the packets are reassembled in the correct order. The packet headers help in this reconstruction.
Question 21.
Consider the following table:
ADMNO | NAME | GRADE | DOB | MARKS | HOUSE | GENDER |
1001 | RUPAL | 9 | 10/04/2006 | 76 | GREEN | M |
1002 | RASHMl | 9 | 08/12/2005 | 87 | RED | F |
1003 | ARNAV | 10 | 25/05/2004 | 81 | GREEN | M |
1004 | SUMONA | 9 | 23/08/2005 | 68 | RED | F |
1005 | ARUN | 9 | 16/07/2005 | 72 | GREEN | M |
1006 | TIA | 9 | 22/09/2005 | 91 | BLUE | F |
1007 | ROSHAN | 10 | 26/08/2004 | 89 | BLUE | M |
Write SQL Commands:
(A) To display the details of all students of Green House. [1]
Answer:
SELECT * FROM Student WHERE House= “GREEN”.
(B) To increase the marks by 5 whose ADM NO is 1005. [1]
Answer:
UPDATE Student SET Marks= Marks+5 FROM Student WHERE Admno=1005.
(C) To display the details of all students whose MARKS are less than 80. [1]
Answer:
SELECT * FROM Student WHERE Marks <80.
(D) Display the list of all students in descending order of MARKS. [1]
Answer:
SELECT * FROM Student ORDER BY Marks DESC.