{"id":3447,"date":"2022-09-27T19:19:18","date_gmt":"2022-09-27T13:49:18","guid":{"rendered":"https:\/\/cbsepython.in\/?p=3447"},"modified":"2022-09-27T19:19:18","modified_gmt":"2022-09-27T13:49:18","slug":"information-technology-class-10-sample-question-paper","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/information-technology-class-10-sample-question-paper\/","title":{"rendered":"402 Information Technology Class 10 Sample Question Paper 2022-23"},"content":{"rendered":"<h2><span style=\"color: #000000;\">402 Information Technology Class 10 Sample Question Paper 2022-23<\/span><\/h2>\n<p><span style=\"color: #000000;\">Max. Time: 2 Hours Max. Marks: 50<\/span><\/p>\n<p><span style=\"color: #000000;\">General Instructions:<\/span><\/p>\n<p><span style=\"color: #000000;\">(1) This Question Paper consists of 21 questions in two sections: Section A &amp; Section B.<\/span><\/p>\n<p><span style=\"color: #000000;\">(2) Section A has Objective type questions whereas Section B contains Subjective type questions.<\/span><\/p>\n<p><span style=\"color: #000000;\">(3) Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions.<\/span><\/p>\n<p><span style=\"color: #000000;\">(4) All questions of a particular section must be attempted in the correct order.<\/span><\/p>\n<p><span style=\"color: #000000;\">SECTION A &#8211; OBJECTIVE TYPE QUESTIONS (24 MARKS):<\/span><\/p>\n<p><span style=\"color: #000000;\">(i) This section has 05 questions.<\/span><\/p>\n<p><span style=\"color: #000000;\">(ii) Marks allotted are mentioned against each question\/part.<\/span><\/p>\n<p><span style=\"color: #000000;\">(iii) There is no negative marking.<\/span><\/p>\n<p><span style=\"color: #000000;\">(iv) Do as per the instructions given.<\/span><\/p>\n<p><span style=\"color: #000000;\">SECTION B \u2013 SUBJECTIVE TYPE QUESTIONS (26 MARKS):<\/span><\/p>\n<p><span style=\"color: #000000;\">(i) This section has 16 questions.<\/span><\/p>\n<p><span style=\"color: #000000;\">(ii) A candidate has to do 10 questions.<\/span><\/p>\n<p><span style=\"color: #000000;\">(iii) Do as per the instructions given.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">SECTION A: OBJECTIVE TYPE QUESTIONS<\/span><\/strong><\/p>\n<p><em><strong><span style=\"color: #000000;\">1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)<\/span><\/strong><\/em><\/p>\n<p><strong><span style=\"color: #000000;\">i) __________ operating system enables multiple users to work on the same <\/span><span style=\"color: #000000;\">computer at different times or simultaneously.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) multiprogramming.<\/span><\/p>\n<p><span style=\"color: #000000;\">b) multiprocessors.<\/span><\/p>\n<p><span style=\"color: #000000;\">c) multi-user.<\/span><\/p>\n<p><span style=\"color: #000000;\">d) multi-tasking.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">ii) ___________ is a series of postures and breathing exercises practiced to achieve <\/span><span style=\"color: #000000;\">control of body and mind.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Meditation <\/span><\/p>\n<p><span style=\"color: #000000;\">b) Nature Walk <\/span><\/p>\n<p><span style=\"color: #000000;\">c) Yoga <\/span><\/p>\n<p><span style=\"color: #000000;\">d) Physical Exercise<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">iii) From the following statements, which one is not correct about the Qualities of an <\/span><span style=\"color: #000000;\">entrepreneur<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Successful entrepreneurs adapt the habit of hard work from a very early stage.<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Entrepreneur should not think optimistically about the future of the business.<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Confident entrepreneur must not deviate from his\/her decisions too early in case <\/span><span style=\"color: #000000;\">success is delayed.<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Entrepreneurs like to function at their own will and rules.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">iv) To remove the files of temporary folder, we type _____________ in Run dialog box <\/span><span style=\"color: #000000;\">after pressing \u201cWindows button + R\u201d on the keyboard.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) #temp# <\/span><\/p>\n<p><span style=\"color: #000000;\">b) %temp% <\/span><\/p>\n<p><span style=\"color: #000000;\">c) $temp% <\/span><\/p>\n<p><span style=\"color: #000000;\">d) &amp;temp&amp;<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">v) __________ is not the quality of self-confident people.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Dependent <\/span><\/p>\n<p><span style=\"color: #000000;\">b) Positive Attitude<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Hard Working <\/span><\/p>\n<p><span style=\"color: #000000;\">d) Commitment<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">vi) From the following statements, which one is not the positive impact <\/span><span style=\"color: #000000;\">of Entrepreneurship on society:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Stimulates Innovation and Efficiency<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Creates Jobs and Employment Opportunities<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Solves the problems of the society<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Discourages welfare of the society<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><em><strong><span style=\"color: #000000;\">2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)<\/span><\/strong><\/em><\/p>\n<p><strong><span style=\"color: #000000;\">i) __________ key is used to reduce repetitive strain.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Sticky<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Serial<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Mouse <\/span><\/p>\n<p><span style=\"color: #000000;\">d) Toggle<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">ii) _________ means that the query uses criteria you provide to hide some data and <\/span><span style=\"color: #000000;\">display only required data.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Filtering<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Report<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Sorting<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Forms<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">iii) Which of the following application is not appropriate to store data about ABC Bank <\/span><span style=\"color: #000000;\">customers?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Open Office Base <\/span><\/p>\n<p><span style=\"color: #000000;\">b) Open Office Writer<\/span><\/p>\n<p><span style=\"color: #000000;\">c) MS Access <\/span><\/p>\n<p><span style=\"color: #000000;\">d) MS Excel<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">iv) When you open a new spreadsheet, by default, it has a sheet named ________ which <\/span><span style=\"color: #000000;\">is managed using tabs at the bottom of the spreadsheet.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Sheet1<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Worksheet1<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Untitled1<\/span><\/p>\n<p><span style=\"color: #000000;\">d) New Sheet<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">v) In a word processor, ____________ option is selected for a scaled resizing of an <\/span><span style=\"color: #000000;\">image.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Original Size <\/span><\/p>\n<p><span style=\"color: #000000;\">b) Image Size<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Keep ratio <\/span><\/p>\n<p><span style=\"color: #000000;\">d) Relative<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">vi) Multiple copies of the same file leads to _________.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Data Inconsistency <\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data Redundancy<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Data Consistency <\/span><\/p>\n<p><span style=\"color: #000000;\">d) Foreign Key<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><em><strong><span style=\"color: #000000;\">3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)<\/span><\/strong><\/em><\/p>\n<p><strong><span style=\"color: #000000;\">i) It is a reference point for the graphics which is created while positioning any image. <\/span><span style=\"color: #000000;\">This point could be the page, or frame where the object is either a paragraph, or\u00a0<\/span><span style=\"color: #000000;\">even a character in a word processor.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Wrap Text <\/span><\/p>\n<p><span style=\"color: #000000;\">b) Anchoring<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Alignment<\/span><\/p>\n<p><span style=\"color: #000000;\">d) BookMark<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">ii) Identify the property which help to set the number of characters in text\/ varchar type <\/span><span style=\"color: #000000;\">field of a table in DBMS.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Entry Required<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Size<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Default Value<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Length<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">iii)\u00a0 __________ is designed to help users with auditory impairments.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Sound Sentry<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Serial key<\/span><\/p>\n<p><span style=\"color: #000000;\">c) High Contrast <\/span><\/p>\n<p><span style=\"color: #000000;\">d) Show Sounds<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">iv) State whether True or False:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">\u201cIt is not possible to create a default template in a Word processor\u201d.<\/span><\/p>\n<p><span style=\"color: #000000;\">a) True<\/span><\/p>\n<p><span style=\"color: #000000;\">b) False<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">v) Reviewers and authors can add their ______ to explain their changes in the cell of <\/span><span style=\"color: #000000;\">Spreadsheet.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Comments<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Worksheet<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Hyperlink<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Macros<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">vi) In Calc, Arguments passed to a macro from Calc are always ___________.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Cell Reference <\/span><\/p>\n<p><span style=\"color: #000000;\">b) Value <\/span><\/p>\n<p><span style=\"color: #000000;\">c) Both a and b<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Sheet Reference<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><em><strong><span style=\"color: #000000;\">4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)<\/span><\/strong><\/em><\/p>\n<p><strong><span style=\"color: #000000;\">i) Identify the website that offers offline blog service for free.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Blogdesk<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Qumana <\/span><\/p>\n<p><span style=\"color: #000000;\">c) WordPress<\/span><\/p>\n<p><span style=\"color: #000000;\">d) both a and b<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">ii) John has written a book consisting of fifteen chapters. He wanted to make the index <\/span><span style=\"color: #000000;\">of the book. Suggest him the option used to create the index automatically in a word\u00a0<\/span><span style=\"color: #000000;\">processor.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Tables<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Columns<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Mail Merge<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Table of Content<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">iii) The length of the field value of text data type is _____ characters by default in <\/span><span style=\"color: #000000;\">DBMS.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) 10<\/span><\/p>\n<p><span style=\"color: #000000;\">b) 25 <\/span><\/p>\n<p><span style=\"color: #000000;\">c) 20<\/span><\/p>\n<p><span style=\"color: #000000;\">d) 50<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">iv) A healthy lifestyle helps to keep and improve people\u2019s health and well-being. It <\/span><span style=\"color: #000000;\">does not include:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) healthy eating habits <\/span><\/p>\n<p><span style=\"color: #000000;\">b) physical activities<\/span><\/p>\n<p><span style=\"color: #000000;\">c) stress management<\/span><\/p>\n<p><span style=\"color: #000000;\">d) less sleep<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">v) In a spreadsheet using to create a hyperlink to a web FTP or Telnet, click on the <\/span><span style=\"color: #000000;\">__________ icon available in Hyperlink dialog box.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) browser <\/span><\/p>\n<p><span style=\"color: #000000;\">b) Internet<\/span><\/p>\n<p><span style=\"color: #000000;\">c) hyperlink<\/span><\/p>\n<p><span style=\"color: #000000;\">d) mail &amp; news<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">vi) A _________ refers to a cell or a range of cells on a worksheet and can be used to <\/span><span style=\"color: #000000;\">find the values or data that you want formula to calculate.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Cell reference <\/span><\/p>\n<p><span style=\"color: #000000;\">b) Sheet Reference<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Block<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Autofill<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><em><strong><span style=\"color: #000000;\">5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)<\/span><\/strong><\/em><\/p>\n<p><strong><span style=\"color: #000000;\">i) Identify the mode, where we can modify in the structure of table?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Datasheet view <\/span><\/p>\n<p><span style=\"color: #000000;\">b) Design view<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Structure view<\/span><\/p>\n<p><span style=\"color: #000000;\">d) All of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">ii) BSNL stands for _____________________.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Bihar Sanchar Nigam Limited<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Bharat Samachar Nigam Limited<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Bharat Sanchar Nigam Limited<\/span><\/p>\n<p><span style=\"color: #000000;\">d) None of the above<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">iii) ________ function takes data from a series of worksheets or workbooks and <\/span><span style=\"color: #000000;\">summaries it into a single worksheet that you can update easily.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Data Combination<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Data Consolidation<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Data Merging<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Data Concatenation<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">iv) __________ store data in a single table which is suitable to store less amount of <\/span><span style=\"color: #000000;\">Data.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) Flat File<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Relational<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Mini File<\/span><\/p>\n<p><span style=\"color: #000000;\">d) Single File<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">v) In a word processor, by default, evaluates ________ levels of headings when it <\/span><span style=\"color: #000000;\">builds the table of contents.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) 3 <\/span><\/p>\n<p><span style=\"color: #000000;\">b) 10<\/span><\/p>\n<p><span style=\"color: #000000;\">c) 7 <\/span><\/p>\n<p><span style=\"color: #000000;\">d) 12<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">vi) In ________________ Networks, all computers have an equal status and each <\/span><span style=\"color: #000000;\">terminal has an equally competent CPU.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">a) MAN<\/span><\/p>\n<p><span style=\"color: #000000;\">b) WAN <\/span><\/p>\n<p><span style=\"color: #000000;\">c) Client Server<\/span><\/p>\n<p><span style=\"color: #000000;\">d) P2P<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">SECTION B: SUBJECTIVE TYPE QUESTIONS<\/span><\/strong><\/p>\n<p><em><strong><span style=\"color: #000000;\">Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks) <\/span><span style=\"color: #000000;\">Answer each question in 20 \u2013 30 words.<\/span><\/strong><\/em><\/p>\n<p><span style=\"color: #000000;\">6.What are the advantages of the ability to Work Independently?\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">7. Name the Stress causal agents.\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">8. What do you mean by Disk Defragmentation?<\/span><\/p>\n<p><span style=\"color: #000000;\">9. Explain any two Myths about Entrepreneurship.\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">10. Write any four roles of Entrepreneurs.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">Answer any 4 out of the given 6 questions in 20 \u2013 30 words each (2 x 4 = 8 marks)<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">11. State any two purposes of using Templates in a word document.\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">12. Mention any two operations that can be performed using Macros in a spreadsheet.\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">13. What do you mean by Hyperlinks in Spreadsheets? Give the two different types of <\/span><span style=\"color: #000000;\">Hyperlinks that can be used in Spreadsheets.<\/span><\/p>\n<p><span style=\"color: #000000;\">14. List Numeric and Alphanumeric Datatypes in OpenOffice Base.\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">15. Differentiate between Filter keys and Toggle keys in Microsoft Windows.\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">16. In which situations Online shopping could be useful? Write any two popular ecommerce websites.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">Answer any 3 out of the given 5 questions in 50\u2013 80 words each (4 x 3 = 12 marks)<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">17. Anshita is preparing spreadsheet notes for her Term Exam. Help her to write short note <\/span><span style=\"color: #000000;\">on the following:<\/span><\/p>\n<p><span style=\"color: #000000;\">i) Scenarios<\/span><\/p>\n<p><span style=\"color: #000000;\">ii) Goal Seek<\/span><\/p>\n<p><span style=\"color: #000000;\">iii) Solver<\/span><\/p>\n<p><span style=\"color: #000000;\">iv) Subtotal<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">18.\u00a0 Tanmay is a Class X student. He has learnt Mail Merge option of a Word Processor <\/span><span style=\"color: #000000;\">in his computer period. But he is confused with few terms used to merge documents. <\/span><span style=\"color: #000000;\">Explain the following briefly, which will help Tanmay better understand the Mail <\/span><span style=\"color: #000000;\">Merge options.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">i) Merge Field<\/span><\/p>\n<p><span style=\"color: #000000;\">ii) Data Source<\/span><\/p>\n<p><span style=\"color: #000000;\">iii) Main Document<\/span><\/p>\n<p><span style=\"color: #000000;\">iv) Mention two types of data on which mail merge can be applied.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">19.\u00a0 Consider the following table: Sales<\/span><\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">Sale_Id <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">Prod_Name <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">Price <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">Discount<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">1101 <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">Laptop <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">65000 <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">2500<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">1103 <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">Pen tab<\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">29500 <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">1000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">1105 <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">Desktop <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">50000 <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">1550<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">1106 <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">Printer <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">12000 <\/span><\/td>\n<td style=\"width: 25%;\"><span style=\"color: #000000;\">2000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">i) How many fields and records are there in Sales table?<\/span><\/p>\n<p><span style=\"color: #000000;\">ii) Write SQL commands for the following:<\/span><\/p>\n<p><span style=\"color: #000000;\">a) Display Sales ID and price of all products whose discount is more than <\/span><span style=\"color: #000000;\">1000.<\/span><\/p>\n<p><span style=\"color: #000000;\">b) Display the details alphabetically by product name.<\/span><\/p>\n<p><span style=\"color: #000000;\">c) Display product name and sales price after deducting the discount from the <\/span><span style=\"color: #000000;\">price.<\/span><\/p>\n<p><span style=\"color: #000000;\">Note: Sales price can be calculated as (price-discount)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">20.\u00a0 Your friend owns a chemist shop, he needs to keep records of the medicines with their <\/span><span style=\"color: #000000;\">id\u2019s, date of purchase, expiry date, price, etc. in a database program. But he does not\u00a0<\/span><span style=\"color: #000000;\">have any knowledge about the database. Explain to him the following to get a better <\/span><span style=\"color: #000000;\">understanding of the DBMS concepts.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">i) What is DBMS? Explain in brief.<\/span><\/p>\n<p><span style=\"color: #000000;\">ii) Name any two database programs which can be used to create a table and store <\/span><span style=\"color: #000000;\">the data as per the requirement.<\/span><\/p>\n<p><span style=\"color: #000000;\">iii) Which field can be set as a Primary Key?<\/span><\/p>\n<p><span style=\"color: #000000;\">iv) Is it possible to make more than one field as a primary key in your table? <\/span><span style=\"color: #000000;\">(Yes\/No). Justify your answer.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">21. Vicky is a student of class X. He used to get the work based on internet surfing, But <\/span><span style=\"color: #000000;\">he is not aware of the internet and its terminology. Being a friend of Vicky, help him\u00a0<\/span><span style=\"color: #000000;\">in finding the answers of the following questions.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">i) What do you mean by Internet Service Provider?<\/span><\/p>\n<p><span style=\"color: #000000;\">ii) Expand the following terms:<\/span><\/p>\n<p><span style=\"color: #000000;\">a) WAP<\/span><\/p>\n<p><span style=\"color: #000000;\">b) W3<\/span><\/p>\n<p><span style=\"color: #000000;\">iii) Mention any two advantages of Networking.<\/span><\/p>\n<p><span style=\"color: #000000;\">iv) What is a Blog? Name any two Online Blogs.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>402 Information Technology Class 10 Sample Question Paper 2022-23 Max. Time: 2 Hours Max. Marks: 50 General Instructions: (1) This Question Paper consists of 21 questions in two sections: Section A &amp; Section B. (2) Section A has Objective type questions whereas Section B contains Subjective type questions. (3) Out of the given (5 + [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[],"class_list":["post-3447","post","type-post","status-publish","format-standard","hentry","category-information-technology-for-cbse-class-10"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/3447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=3447"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/3447\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=3447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=3447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=3447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}