IT Sample Paper Class 10 2023 with Answers

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

---

Click for Sample Paper – I

Click for Sample Paper – II

---

First – IT Sample Paper Class 10 2023

Max. Time: 2 Hours                                                                                                                              Max. Marks: 50

General Instructions:

1. Please read the instructions carefully.
2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
3. Section A has Objective type questions whereas Section B contains Subjective type questions.
4. 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.
5. All questions of a particular section must be attempted in the correct order.
6. SECTION A – OBJECTIVE TYPE QUESTIONS (24 MARKS)
7. SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS)

SECTION A: OBJECTIVE TYPE QUESTIONS

Q1.	Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
i.	Which of the following is not the element of communication? a. Sender b. Receiver c. Channel d. Caller
Ans.	d. Caller
ii.	Emotional intelligence include ____________________ a. Emotional awareness b. Harnessing emotions c. Managing emotions d. All of the above
Ans.	d. All of the above
iii.	_________________, will help you in converting your weakness into strength and strength into an exceptional talent. a. Self Discipline b. Self Awareness c. Self Motivation d. Self Regulation
Ans.	b. Self Awareness
iv	___________________________ software starts working as soon as we switch on the computer. a. ROM b. BIOS c. Operating System d. Application Software
Ans.	b. BIOS
v	Ananya is a young entrepreneur. She own three companies. What qualities does she possess? a. Hard working b. Risk taking c. Decision making d. All of the above
Ans.	d. All of the above
vi	One initiative on Sustainable development was taken by Ministry of Railways in Varanasi where they introduced clay pots called _______________ to replace plastic and paper cups and to bring back taste of tradition. a. Kulhads b. Clay cups c. Tea cups d. Special cups

Q2.	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i.	Suman is working as a Data Entry Operator. She created a long document of around 15 pages. Her Manager asked Suman to change the indentation of all paragraphs and also change the font of all titles. Which of the following feature of Writer will make her task easy. a. Style b. Template c. Format Painter d. Table of Content
Ans.	a. Style
ii.	Drag and Drop method embeds (saves a copy of) the image file in the Writer document. To link the file instead of embedding it, hold down the ___________________ while dragging the image. a. Control + Shift key b. Control + Window key c. Control + Alt key d. Control + Tab key
Ans.	a. Control + Shift key
iii.	Which graphic filter increases the contrast of an image? a. Smooth b. Sharpen c. Remove noise d. Posterize
Ans.	b. Sharpen
iv.	Parth is a student of class X. He wants to use an image as a watermark in Open Office Writer. Which of the following feature of Writer will help him to create watermark? a. Filter b. Graphic Mode c. Transparency d. Color
Ans.	c. Transparency
v.	To start cropping the image, right click on it and select __________________ from the pop-up menu. a. Crop b. Wrap c. Properties d. Picture
Ans.	d. Picture
vi.	________ menu help us to group objects in Open Office Writer. a. File b. Format c. Edit d. View
Ans.	b. Format

Q3.	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i.	In Subtotal dialog of Calc, you can choose up to _______________ groups of arrays to which to apply a function. a. Two b. Three c. Four d. Five
Ans.	b. Three
ii.	Anant wants to insert a new sheet in Calc. He don’t know about, how to open Insert Sheet dialog box. Being a friend of Anant help him to find the appropriate method to open Insert Sheet dialog box. a. Select Insert —> Sheet from the menu bar. b. Right-click on the tab and select Insert Sheet. c. Click in an empty space at the end of the line of sheet tabs. d. All of the above
Ans.	d. All of the above
iii.	Aman is working in an IT company. He created a file in Calc named ‘data’. He wants to use a cell reference with keyboard to refer to data which is stored in some other Calc file named ‘stock’. He knows that cell reference using keyboard will include three parts (given below) but not aware about their sequence. So help him to find the correct sequence. 1. Path and File name 2. Cell 3. Sheet name Correct Sequence a. 1->2->3 b. 2->3->1 c. 1->3->2 d. 3->2->1
Ans.	c. 1->3->2
iv.	Which of the following option is not there on left panel of Hyperlink dialog box? a. Internet b. Mail & News c. Document d. Spreadsheet
Ans.	d. Spreadsheet
v.	Calc has the feature _____________________ to track what data was changed, when the change was made, who made the change and in which cell the change has occurred. a. Record Changes b. Resolve Conflicts c. Viewing Changes d. Save Changes
Ans.	a. Record Changes
vi.	After you have added a comment to a changed cell, you can see it by __________________ the mouse pointer over the cell. a. Right Clicking b. Hovering c. Double Clicking d. Right Double Clicking
Ans.	b. Hovering

Q4.	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i.	Database servers are dedicated computers that hold the actual databases and run only the DBMS and related software. Database servers are referred to as ______________________ a. Back-end b. Front-end c. Safe-end d. Server-end
Ans.	a. Back-end
ii.	“Client_id” is a primary key in “Client” table. “Client_id” is also present in “Sales” table. The referred field Client_id which also occurs in the Sales table is called the ___________________ a. Primary Key b. Foreign Key c. Composite Primary Key d. Alternate Key
Ans.	b. Foreign Key
iii.	Aman created a table named “BOOK” in an Open Office Base. He did not create any field as Primary Key. When he closes the window and open the table again, he found that Base had already added a field as Primary Key. What is the name of the Primary which was added by Base automatically? a. Book_id b. B_id c. ID d. B_ID
Ans.	c. ID
iv.	Which of the following statement is not correct about Row? a. Row in a table represents a set of related data. b. Every row in the table has the same structure. c. A row also called a Record or Tuple d. None of the above
Ans.	d. None of the above
v.	Ashu want to delete a record from the table in datasheet view. Help him to find the correct option. a. Select the data > right click on selected data > select the Delete option b. Select the data > right click on selected data > select the Remove option c. Select the data > right click on selected data > select the Drop option d. Select the data > right click on selected data > select the Lock option
Ans.	a. Select the data > right click on selected data > select the Delete option
vi.	Which of the following field property does not belong to Numeric data type? a. Length b. Autovalue c. Default Value d. Entry Required
Ans.	d. Entry Required

Q5.	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i.	Accessibility Options in Control Panel are used to customize the ____________ input device. a. Keyboard b. Mouse c. Both of the above d. Monitor
Ans.	c. Both of the above
ii.	DSL stands for ________________________ a. Digital Subscriber Line b. Digtal Subsciption Line c. Digital Subscriber Language d. Digitals Line
Ans.	a. Digital Subscriber Line
iii.	Which of the following is a Key Feature of an instant messaging? a. Text Messages can be sent to one or more person. b. Audio calling and conferencing. c. Video calling and conferencing. d. All of the above
Ans.	d. All of the above
iv.	Meebo is an example of _____________________ a. Web based Instant Messaging Software b. Application based Instant Messaging Software c. Google Talk d. Alexa
Ans.	a. Web based Instant Messaging Software
v.	Which of the following activity can help us to reduce the risk of Online Threats? a. Use Strong Password b. Use Antivirus and Spyware c. Use Encryption Software d. All of the above
Ans.	d. All of the above
vi.	Basic safety rules to follow at workplace are _______________________ a. Fire safety b. Falls and slips c. Electrical safety d. All of the above
Ans.	d. All of the above

SECTION B: SUBJECTIVE TYPE QUESTIONS

	Answer any 3 out of the given 5 questions on Employability Skills. Answer each question in 20-30 words (3 x 2 = 6 marks)
Q6.	Write any two ways to overcome barriers to effective communication.
Ans.	Two ways to overcome barriers to effective communication are: (Write any two) 1. Use simple language 2. Do not form assumptions on culture, religion or geography. 3. Try to communicate in person as much as possible 4. Use visuals 5. Take help of a translator to overcome differences in language. 6. Be respectful of other’s opinions.
Q7.	What do you mean by ABC of stress management?
Ans.	ABC of stress management are: A: Adversity or the stressful event B: Beliefs or the way you respond to the event C: Consequences or actions and outcomes of the event
Q8.	Differentiate between Worms and Trojan Horse
Ans.	Worms: These are viruses that replicate themselves and spread to all files once they attack a computer. This makes it very difficult to remove them. Trojan Horse: A Trojan Horse appears to be a useful software program but once it reaches a computer it starts behaving like a virus and starts destroying data.
Q9.	Write any two qualities of successful entrepreneurs.
Ans.	Two qualities of successful entrepreneurs are: (Write any two) 1. They are confident. 2. They are hard-working 3. They take risk 4. They do not give up.
Q10.	What is Sustainable Development?
Ans.	Sustainable development is the development that satisfies the needs of the present without compromising the capacity of future generations.

	Answer any 4 out of the given 6 questions in 20-30 words each (4 x 2 = 8 marks)
Q11.	Read and fill the blank spaces _________________ is used to apply a style to many different areas quickly without having to go back to the Styles and Formatting window. To quit this mode press __________ key from the keyboard
Ans.	Fill Format mode Esc
Q12.	Name any four settings which is available in Writer to control the position of graphic with respect to the text and other graphics.
Ans.	Four settings are: 1. Arrangement 2. Alignment 3. Anchoring 4. Text wrapping
Q13.	What do you mean by Cell reference in Open Office Calc?
Ans.	A cell reference 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.
Q14.	What do you mean by Relationship between tables? How can you create relationship in Base?
Ans.	A relationship refers to an association or connection between two or more tables. We can create a relationship between any two tables by selecting Relationships… option from the Tools menu.
Q15.	Define the following terms: 1. Sticky Keys 2. SoundSentry
Ans.	Sticky Keys: It is an accessibility feature to help computer users with physical disabilities, but it is also used by others as a means to reduce repetitive strain. SoundSentry: It is designed to help users with auditory impairments. SoundSentry generates visual warnings, such as a blinking title bar or a flashing border, whenever the computer generates a sound.
Q16.	What do you mean by Computer Network? Write any two advantages of Networking.
Ans.	A computer network is a collection of computers and other hardware components interconnected by communication channels (cables or satellites) that allow sharing of resources and information. Advantages of Computer Networking are: (Write any two) 1. Data Sharing 2. File Transfer 3. Hardware Sharing 4. Internet Access Sharing

	Answer any 3 out of the given 5 questions in 50-80 words each (3 x 4 = 12 marks)
Q17.	What do you mean by Table of Contents in Writer? Write the steps to insert and update the Table of Content.
Ans.	Writer’s table of contents feature lets you build an automated table of contents from the headings in your document. Steps to insert Table of Contents are: 1. Place the cursor where you want the table of contents to be inserted. 2. Select Insert > Indexes and Tables > Indexes and Tables. Steps to update Table of Contents are: 1. Place the cursor within the table of contents. 2. Right-click and select Update Index/Table from the pop-up menu.
Q18.	What do you mean by Hyperlink in Calc? Name two types of Hyperlink and define any one.
Ans.	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 or even to web sites. Two types of Hyperlink are 1. Absolute Hyperlink 2. Relative Hyperlink Absolute Hyperlink: An absolute link will stop working only if the target is moved. Relative Hyperlink: A relative link will stop working only if the start and target locations change relative to each other.
Q19.	Define the following field properties 1. Length 2. Default Value 3. Required 4. Format
Ans.	Length: This property specifies the number of characters that can be entered in Char or Varchar data type. Default Value: A value which automatically enters as soon as we start entering the new record. Required: When this property is set to yes then it will be must to insert the value in the field which means that field cannot be left blank. Format: This property help us to set the format of the data entered in the field such as 91-222-333.
Q20(a)	Structure of table “Student” is given below. Suggest the suitable data type of each column. Also suggest the suitable primary key.

Adm_no	Name	DOB
A101	Amit	12/12/2010
A103	Parth	11/08/2011
A104	Ravi	15/02/2010
A106	Ravi	11/08/2011

Ans.

(a) Data types of columns are Adm_no ————> Varchar or Char Name ————–>Varchar DOB—————->Date Suitable Primary Key is: Adm_no

Q20(b)

Consider the following table: Product

Pr_no	P_Name	Price	Qty
P1	Pen	20	7
P2	Pencil	7	6
P3	Rubber	6	8
P4	Sharpner	5	9

	Write the SQL Queries to 1. Display data of all products whose Quantity is more than 7. 2. Display total amount of all products(total amount = Price * Quantity)
Ans.	1. Select * from Product where Qty > 7; 2. Select Price * Qty from Product;
Q21.	a) What do you mean by Hazard? Name any two types of Hazards b) What is the difference between Accident and Emergency?
Ans.	a) A hazard is anything that is the source of any potential harm, damage or any kind of potential loss of health or life. The different types of hazards include: ● Physical ● Chemical ● Biological ● Mechanical b) Accident: An accident is an unplanned event that may happen all of a sudden and may lead to unwanted or unprecedented results/outcomes. Emergency: Any unexpected situation that needs immediate attention and action is called emergency

Second – IT Sample Paper Class 10 2023

General Instructions:

1. Please read the instructions carefully.
2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
3. Section A has Objective type questions whereas Section B contains Subjective type questions.
4. 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.
5. All questions of a particular section must be attempted in the correct order.
6. SECTION A – OBJECTIVE TYPE QUESTIONS (24 MARKS)
7. SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS)

Q1.	Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
i.	If you have been assigned a task by a teacher; ensure that you should take complete ownership. If you are unable to complete the task on time, you must report it and then correct it. a.  Time Management b.  Adaptability c.  Responsibility d.  Self-Awareness
Ans.	c.  Responsibility
ii.	Which of the following is not the sign of Stress? a.  Headache b.  Sleeplessness c.  Nervousness d.  Happiness
Ans.	d.  Happiness
iii.	Visual communication involves interchanging messages only through images. The following image represents ______________ message. a. No Entry b. No Parking c. Danger warning d. No mobile phone

Ans.	a. No Entry
iv.	Which of the following things we should follow to take care of our devices such as Computer or Smartphone? a. Handle devices carefully. b. Keep the devices cool. c. Do not overcharge battery of Laptop or Smartphone. d. All of the above
Ans.	d. All of the above
v.	What do entrepreneurs do when they run their business? a. Create Jobs b. Fulfill Customer Needs c. Help Society d. All of the above
Ans.	d. All of the above
vi.	Which of the following is not included in Sustainable development? a. reducing excessive use of resources. b. recycling and reuse of waste materials. c. use of technologies, which are environmental friendly. d. using maximum non-biodegradable material.
Ans.	d. using maximum non-biodegradable material.

Q2.	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i.	_______________ styles affect selected text within a paragraph, such as the font and size of text, or bold and italic formats. a. Frame b. Paragraph c. Character d. Page
Ans.	c. Character
ii.	Aman wants to insert an image from the Gallery in Writer. Help him to find the correct option to open Gallery. a. File —> Gallery b. Edit —> Gallery c. Tools —> Gallery d. Format —> Gallery
Ans.	c. Tools —> Gallery
iii.	In Writer positioning of a graphic is controlled by four settings: 1. Anchoring 2. Arrangement 3. Alignment 4. Text Wrapping All the above settings are available in ________________ menu a. File b. Edit c. Picture d. Format
Ans.	d. Format
iv.	Anshuman created a template for business reports that has company’s logo on the first page. When new document is created from this template then company’s Logo will appear on___________ a. every page of document. b. first page of document. c. last page of document. d. first and last page of document.
Ans.	b. first page of document.
v.	In Open Office Writer, we can create template in many ways. Identify the invalid way of creating template from the following. a. From a wizard b. From a document c. From Spreadsheet d. None of the above
Ans.	Ic. From Spreadsheet
vi.	By default, Writer evaluates 10 levels of headings when it builds the table of contents. Suman wants only three levels of heading in the table of contents. To change the number of levels evaluated, She will enter the desired number of headings in the _________________________________ spin box. a. Evaluate up to level b. Evaluate up to heading c. Evaluate d. Evaluate up to outline
Ans.	a. Evaluate up to level

Q3.	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i.	Which of the following is the default Function settings in Consolidate dialog box? a. Average b. Min c. Max d. Sum
Ans.	d. Sum
ii.	Which of the following option is not available in Data menu of Calc? a. Consolidate b. Define Range c. Subtotals d. Goal Seek
Ans.	d. Goal Seek
iii.	Manisha wants to refer a cell ‘F5’ of a sheet named “Computer Games”. Help her in writing the correct way. a. Computer Games.F5 b. ‘Computer Games’.F5 c. ‘Computer Games.F5’ d. “Computer Games”.F5
Ans.	b. ‘Computer Games’.F5
iv.	To open the Hyperlink dialog box in Calc, click on the hyperlink icon on the ______________ toolbar or we can also select hyperlink option from the ______________ menu. a. Formatting, Insert b. Standard, Tool c. Standard, Insert d. Formatting, Tool
Ans.	c. Standard, Insert
v.	Shared workbooks don‘t allow ____________________ a. Merging Cells b. Conditional Formatting c. Inserting Pictures d. All of the above
Ans.	d. All of the above
vi.	In Open Office Calc, ___________________ are especially useful to repeat a task the same way over and over again. a. Macros b. Style c. Template d. Subtotal
Ans.	a. Macros

Q4.	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i.	__________ are the basic building blocks of a database. a. Columns b. Tables c. Records d. Attributes
Ans.	b. Tables
ii.	Which of the following numeric data type can store only those integers that fall between 0 to 255? a. TinyInt b. SmallInt c. Boolean d. Integer
Ans.	a. TinyInt
iii.	In which view new data can be inserted in table and existing data can be updated or removed? a. Design View b. Datasheet View c. Table View d. Query
Ans.	b. Datasheet View
iv.	Anant created a table named “student” in Base. One field (Admission Number) of student table required that value will automatically incremented. Which of the following data type and field property is suitable for this task? a. Char, Auto Value b. Varchar, Auto Value c. Integer, Auto Value d. Timestamp, Auto Value
Ans.	c. Integer, Auto Value
v.	In Open Office Base, we can create a relationship between any two tables by selecting Relationships… option from the __________________ menu. a. Tools b. Insert c. View d. File
Ans.	a. Tools
vi.	To display the records containing the same type of values ___________ clause can be used with the Select SQL Command. a. Between b. Order by c. Group by d. Where
Ans.	d. Where

Q5.	Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i.	Anshu is a class 10 students. He had done the following task at home. 1. He opened the Notepad 2. He typed few lines in Notepad 3. He placed the cursor at the beginning of the text. 4. He Pressed CTRL key of his keyboard 5. He Pressed letter A of his keyboard. He was surprised to noticed that entire text gets selected. Which of the following Accessibility option was enabled? a. Filter Keys b. Sticky Keys c. Toggle Keys d. Mouse Keys
Ans.	b. Sticky Keys
ii.	Data is transmitted over the internet in the form of small pieces called ____________ a. SMS b. Packets c. Pockets d. Message
Ans.	b. Packets
iii.	Which of the following step will make your blog public? a. Publishing the blog b. Activate account in WordPress c. Adding comment box in the blog d. Writing title in the blog
Ans.	a. Publishing the blog
iv.	What we call the software or program which keeps the track of all the keys pressed from the keyboard? a. Key storage b. Keylog c. Keylogger d. Keyboard log
Ans.	c. Keylogger
v.	We can reduce the risks of cyber attack by using ___________________ a. Antivirus Software b. Firewalls c. Strong Password d. All of the above
Ans.	d. All of the above
vi.	Identify the Falls and Slips Safety rule from the following. a. Fire escape plans must be installed at proper levels. b. Workers should be trained to handle the electric equipment safely. c. Wear non slippery footwear. d. Smoke alarms must be placed at proper intervals
Ans.	c. Wear non slippery footwear.

SECTION B: SUBJECTIVE TYPE QUESTIONS

	Answer any 3 out of the given 5 questions on Employability Skills. Answer each question in 20-30 words (3 x 2 = 6 marks)
Q6.	Name any 4C’s out of 7C’s of Effective Communication.
Ans.	4C’s are (Write any Four) 1. Clear 2. Concise 3. Concrete 4. Correct 5. Coherent 6. Complete 7. Courteous
Q7.	What do you mean by Self motivation?
Ans.	Self-motivation is simply the force which pushes us to achieve our goals, feel happy and improve our quality of life.
Q8.	What is Folder? Write the extension of the following type of files a. Notepad file b. sound file
Ans.	A folder is a location where a group of files can be stored. a. Extension of Notepad file is: .txt b. Extension of Sound file is: .mp3
Q9.	What do you mean by Entrepreneurship? Write any one misconception about entrepreneur/entrepreneurship.
Ans.	Entrepreneurship is the type of self-employment where one is running a business to satisfy the needs of people and looking for ways to make the business better to make profits. Misconception is: (Write any one) 1. The misconception is that every business idea needs to be unique or special. 2. The misconception we have is that a person needs a lot of money to start a business. 3. A misconception we have is that only a person having a big business is an entrepreneur.
Q10.	What do you mean by Sustainable Development Goals?
Ans.	The Sustainable Development Goals (SDGs) are a universal call of action to end poverty, protect the planet and ensure that all people enjoy peace and prosperity.

	Answer any 4 out of the given 6 questions in 20-30 words each (4 x 2 = 8 marks)
Q11.	What is the difference between Keep Scale and Keep image size? Where do you find these options in Writer?
Ans.	When Keep scale is selected (default), cropping the image does not change the scale of the picture. When Keep image size is selected, cropping produces enlargement , shrinking, or distortion of the image so that the image size remains constant. These options are available on crop page of picture dialog box in Writer
Q12.	Write the steps to set a custom template as the default template.
Ans.	Steps to set a custom template as the default template are: 1. From the main menu, choose File > Templates > Organize. The Template Management dialog opens. 2. In the box on the left, select the folder containing the template that you want to set as the default, then select the template. 3. Click the Commands button and choose Set As Default Template from the drop-down menu.
Q13.	What is Macro? Write the argument which is passed to a function given below. =calculate(A2)
Ans.	A macro is a saved sequence of commands or keystrokes that are stored for later use. Argument is value of cell A2
Q14.	What do you mean by Reports in Open Office Base? Name the two types of reports that can be created in Base.
Ans.	A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a printable format. Two types of reports are 1. Static Report 2. Dynamic Report
Q15.	Write any two points/checklist which should be considered while making workstation.
Ans.	Checklist for Workstations are: (Write any two) 1. The workstation should provide sufficient space for the user to alter position comfortably. 2. The workstation should provide adequate lighting. 3. The workstation should have windows to alter the sunlight level. 4. The workstation should be spacious enough that it can be shared by more than one person.
Q16.	What are cookies and why they are used?
Ans.	Cookies are small text file that are created on your local computer when you visit websites. Cookies are meant for storing data based on your activity performed during your earlier visit in a website such as login details, details of a shopping cart, visited pages etc.

	Answer any 3 out of the given 5 questions in 50-80 words each (3 x 4 = 12 marks)
Q17.	Can we insert graphic to the background of the table of contents? If yes, then, which tab to be selected from Insert Index/Table dialog box? What option to be selected from the ‘As’ drop-down list? How many options are available in the ‘Type’ area? Name all the options.
Ans.	Yes we can insert graphics to the background of the table of contents. Background tab to be selected from Insert Index/Table Dialog box. Graphic option to be selected from the As drop down list. Three options are available in Type area 1. Position 2. Area 3. Tile
Q18.	Identify ‘X’ and fill the missing words in the following paragraph ‘X’ are the tool to test “what-if” questions. When we print the spreadsheet containing ‘X’, only the content of the ________1_______ ‘X’ is printed. ‘X’ can be created by selecting option from the ________2___________ menu. Aman is creating first ‘X’ in a sheet named ‘Sheet1’ then the default name of the ‘X’ will be __________3__________
Ans.	‘X’ is Scenario 1. Currently active or Active or Current 2. Tools 3. Sheet1_Scenario_1
Q19.	Define the following terms 1. Primary Key 2. Foreign Key 3. Composite Primary Key Also write any one difference between Char and Varchar data type.
Ans.	Primary Key: It is a field which is unique for each and every record. Foreign Key: It identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. Composite Primary Key: When primary key constraint is applied on one or more columns then it is known as Composite Primary Key. Char: It is a fixed length datatype Varchar: It is a variable length datatype
Q20	Consider the following table ‘Book’ and answer the queries given below.

B_id	Subject	Price	Class
102	Hindi	250	X
105	Mathematics	450	IX
109	English	270	X
122	Science	390	XI

	1. Display all the records of table in increasing order of Price. 2. Delete the record of all books of class ‘X’ 3. Insert a new record with values (195, ‘SST’, 430, ‘IX’) 4. Increase the price of all books of class ‘XI’ by Rs 70
Ans.	1. Select * from Book order by Price 2. Delete from Book where Class = ‘X’ 3. Insert into Book values(195, ‘SST’, 430, ‘IX’) 4. Update Book set Price = Price +70 where Class = ‘XI’
Q21.	Identify the following: 1. A Network in which all computers have an equal status. 2. Network in which certain computers have special dedicated tasks, providing services to other computers 3. It is a network of networks. 4. It is a software used to view Web sites.
Ans.	1. A Network in which all computers have an equal status. Peer to Peer Network. 2. Network in which certain computers have special dedicated tasks, providing services to other computers. Client Server Network 3. It is a network of networks. Internet. 4. It is a software used to view Web sites. Web Browser.

---

Disclaimer : I tried to give you the correct pattern of “IT Sample Paper Class 10 2023” , but if you feel that there is/are mistakes in “IT Sample Paper Class 10 2023“ given above, you can directly contact me at csiplearninghub@gmail.com. The above “IT Sample Paper Class 10 2023“ is created for practice of students and the entire content is from CBSE Study material.

---

Important Links of Class X

EMPLOYABILITY SKILLS

UNIT 1: COMMUNICATION SKILLS MCQ

UNIT 2: SELF-MANAGEMENT SKILLS MCQ

UNIT 3: ICT SKILLS MCQ

UNIT 4: ENTREPRENEURIAL SKILLS MCQ

UNIT 5: GREEN SKILLS MCQ

---

UNIT 1: DIGITAL DOCUMENTATION (ADVANCED) MCQ

UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED) MCQ

UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC) MCQ

UNIT-4 WEB APPLICATIONS AND SECURITY MCQ

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023

IT Sample Paper Class 10 2023