Find CBSE and other IT Sample Papers for Class 10 – Code 402 with Complete Solution. Prepare for IT Code 402 Class 10 by Downloading PDF Sample Papers for Pre Board or Annual Exams and Understand the complete pattern of Board Exams for all Sessions. Here, LearnCSE.in website is a one platform to get all Class 10 IT Code 402 Previous Year Question Papers and Solutions related to computer science, Information Technology or Informatic Practices.
INFORMATION TECHNOLOGY (SUBJECT CODE – 402)
Pre Board Sample Question Paper for Class X (Session 2023-2024) – SET 1 by LearnCSE
Solution
Max. Time: 2 Hours
Max. Marks: 50
General Instructions:
- Please read the instructions carefully.
- This Question Paper consists of 21 questions in two sections: Section A & Section B.
- Section A has Objective type questions whereas Section B contains Subjective type questions.
- Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the
allotted (maximum) time of 2 hours. - All questions of a particular section must be attempted in the correct order.
- SECTION A – OBJECTIVE TYPE QUESTIONS (24 MARKS):
i. This section has 05 questions.
ii. Marks allotted are mentioned against each question/part.
iii. There is no negative marking.
iv. Do as per the instructions given. - SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):
i. This section has 16 questions.
ii. A candidate has to do 10 questions.
iii. Do as per the instructions given.
iv. Marks allotted are mentioned against each question/part
SECTION A: OBJECTIVE TYPE QUESTIONS
Q. 1 Answer any 4 out of the given 6 questions on Employability Skills (1X4=4 marks)
(i) Self awareness refers to
a) our knowledge and understanding of ourselves
b) systematic efforts to direct thoughts and actions
c) ability to identify effective methods to move from thought to action
d) None of the above
(ii) If we worry about matters we can do nothing about or we are worring for no reason at all, we are having ____.
a) environmental stress
b) eustress
c) distress
d) internal stress
(iii) The simultaneous processing of two or more programs by multiple processors is
a) multi-programming
b) multi-tasking
c) time sharing
d) multi-processing
(iv) What is a file ?
a) A file is a section of main storage used to store data
b) A file is a collection of information that has been given a name and have an extension
c) A file is the part of a program that is used to describe what the program should do
d) A file can be saved only in CDs
(v) State whether the following statement is true or false:
Talent is more important than industry.
(vi) To find the suitable market and entrepreneur performs the functions of
a) advertisement and publicity
b) appointment of selling agents
c) new organisation structure
d) Both a) and b)
Q. 2 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) Which extension is given to a document by default in OpenOffice writer?
a) .odf
b) .com
c) .docx
d) None of these
(ii) The status of your document like current page number and number of pages are given by __
a) Formatting toolbar
b) Status bar
c) Standard toolbar
d) None of these
(iii) The documents can be saved by using
a) Ctrl + s
b) File > Save
c) File -> Save As
d) All of these
(iv) Which of the following alignments are available in writer?
a) Left
b) Right
c) Center
d) All of these
(v) Line or paragraph spacing is measured in terms of lines or points which is referred as ____.
a) text wrapping
b) PDF
c) XPS
d) leading
(vi) Which term refers to a set of formats consisting of fonts, font color, font size and paragraph formats?
Q. 3 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) According to OpenOffice Calc which of the following is not a What-if analysis tool?
a) Conditional formatting
b) Goal seek
c) Scenarios
d) Solver
(ii) The ____ feature creates summarized outline of data in a worksheet.
a) Subtotal
b) Solver
c) Goal seek
d) Scenario
(iii) To start the Macro recorder, which of the following command is used?
a) Tools > Macros > Record macro
b) Tools > Record > Record macro
c) Data > Macros > Record
d) None of these
(iv) Linked data is stored in the ____
a) destination file
b) web file
c) source file
d) domain file
(v) This is a type of hyperlink available in Hyperlink dialog box, which creates a new worksheet
a) New document
b) New file
c) New worksheet
d) New data
(vi) Rajat has received a spreadsheet, which is reviewed by his subordinates Puneet, kavya and Aman, who made some corrections in it. Before Rajat shared the spreadsheet with his subordinates, he has activated the track changes feature. Which of the following option he should use now to keep some of the changes made by them?
a) Accept and reject changes
b) Overwrite and keep changes
c) Both a and b
d) None of these
Q. 4 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) Facilities offered by databases are
a) the ability to store a large amount of data in a structured format, easy update, sort query, production of reports.
b) easy edition, spell check, perform calculations, library of mathematical functions, replications.
c) the ability to rotate images, copy and paste, fill scale.
d) None of the above
(ii) Which one of the following is an example of RDBMS?
a) MongoDB
b) Windows registry
c) Publisher
d) Oracle
(iii) Database servers are referred to as ____
a) front-ends
b) back-ends
c) clients
d) model
(iv) Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required?
a) Age in years
b) Date of birth
c) Age in days
d) Age in months
(v) The ____ has evolved since the 1960s to ease increasing difficulties in designing, building and maintaining complex information system.
a) Knowledge concept
b) Formula concept
c) Database concept
d) Forms concept
(vi) Computer Based Record Keeping system is known as
a) Data manipulation system
b) Computerised data system
c) Computerised Record Keeping system
d) DBMS
Q. 5 Answer any 5 out of the given 6 questions (1X5=5 marks)
(i) Which of the following is an application program that is stored on a remote server and delivered over the internet?
a) Web application
b) System application
c) Internet application
d) None of these
(ii) A group of computers connected together with the help of cables within an office building is called
a) PAN
b) WAN
c) MAN
d) LAN
(iii) Digital information is converted into analogue information by the modem at
a) destination computer
b) source computer
c) Both a) and b)
d) Neither a) nor b)
(iv) A modem is connected in between a telephone line and a
a) computer
b) serial port
c) network
d) communication adaptor
(v) What can you do with the internet?
a) Exchange information with friends and colleagues
b) Access pictures, sounds, video clips and other media elements
c) Find diverse perspective on issue from a global audience
d) Internet exchange information, access pictures, find diverse perspective on issue from a global audience.
(vi) Which of these services will not be provided by a typical Internet Service Provider (ISP)
a) An e-mail address
b) Modem
c) A connection to the internet
d) Technical help
SECTION B: SUBJECTIVE TYPE QUESTIONS
Answer any 3 out of the given 5 questions on Employability Skills (2X3=6 marks)
Answer each question in 20–30 words.
6. What is survival stress?
7. Why is self regulation important in life?
8. What is an Operating System?
9. Explain any three characteristics or qualities of an entrepreneur.
10. Explain the role and significance of entrepreneurs.
Answer any 4 out of the given 6 questions in 20–30 words each (2X4=8 marks)
11. Explain any four graphic filters.
12. Ridhima wants to know about mailing labels in word processor. Help her to find the answers of the given questions.
(a) What is mailing label?
(b) What are the ways to prepare and print mailing labels?
13. What is the use of consolidate option in Calc?
14. How are fields, record and a table related to each other? Explain with the help of an example.
15. Why do we use instant messaging?
16. (a) Write the full form of the following terms. (i) WiMAX (ii) BPL
(b) Ramya wants to connect all the computers of her office wirelessly in order to avoid clumsy cables. Which wireless Technology would be best suitable for her office?
Answer any 3 out of the given 5 questions in 50–80 words each (4X3=12 marks)
17. Ojas had prepared a table of contents of the project work he had done in a word processor application.
(a) Tell him the different steps to update the TOC.
(b) Tell him the different steps to delete the TOC.
18. Lavish is preparing notes for his upcoming exams. Help him to write the correct answer of the following.
(i) Scenario
(ii) Absolute link
(iii) Relative link
(iv) Macro
19. Define database management system. Right to advantages of using database management system for school.
20. (a) State the relationship and difference between a primary and foreign key.
(b) Write SQL command to create the table VEHICLES with given constraint and also add some information in it.
| Column Name | Data_Type (Size) | Constraint |
|---|---|---|
| Reg_No | char (15) | Primary Key |
| Reg_Date | date | |
| Owner_Name | varchar (20) | |
| Address | varchar (40) |
21. (a) What are the benefits of online shopping?
(b) How many types of web browser? Explain them.