Chap 1 Sample Paper 6 Page 1
Sample Paper 6
INFORMATION TECHNOLOGY (402)
Class X Session 2022-23
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):
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.
7. 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.
SECTION - A
Objective Type Questions
1. Answer any 4 out of the given 6 questions based on Employability Skills
(i) Moving a folder or a file means_____it from its original location and placing it at another location.
(a) Pointing (b) Removing (c) Leaving (d) None of these
(ii) ______barriers are created in the mind by none other than ourselves, through preconceived notions and the
stereotyping of people.
(a) Language (b) Cultural (c) Imaginative (d) Perceptual
(iii) Kaspersky, McAfee are examples of popular_______.
(a) DBMS (b) word-processing software
(c) image editing software (d) anti-virus software
(iv) Regular exercise helps pep up your mood and can take your mind off a lot of worry and negativity which are the
main feed of stress. Which of the following activity is not considered as exercise?
(a) Swimming (b) Walking (c) Talking (d) Jogging
(v) Which of the following sentences is in passive voice?
(a) Uncle Rakesh teaches my brother. (b) By whom was the mess cleaned?
(c) The birds were being fed by my sister. (d) Both (b) and (c)
(vi) _______builds up over a period of time and takes a toll on the body due to overwork.
(a) Irritability (b) Depression (c) Fatigue (d) None of these
Install NODIA App to See the Solutions.
Click Here To Install
Page 2 Sample Paper 6 Chap 1
2. Answer any 5 out of the given 6 questions
(i) A_______is a database element that is used to view, enter and edit records in a table.
(a) Query (b) Form (c) Report (d) None of these
(ii) A person who writes a blog or a weblog is known as_______.
(a) blogger (b) program (c) user (d) None of these
(iii) ______styles are used to format graphics and text frames, including text wrap, borders, backgrounds and
columns.
(a) Table (b) Text (c) Border (d) Frame
(iv) The______command is used to modify the existing rows in a table.
(a) INSERT (b) UPDATE (c) REVIEW (d) SELECT
(v) Neeta is planning to take a car loan to buy a new car. But she is not sure about the payback time, i.e. whether to
pay it back in 5 or 6 years considering that her monthly fuel cost will also increase. In such cases, which of the
following features of spreadsheet can she use to get an idea about it?
(a) Templates (b) What-if analysis (c) Consolidation (d) Macros
(vi) A_____language is a portion of a DML involving information retrieval only.
(a) Query (b) TCL (c) DCL (d) None of these
3. Answer any 5 out of the given 6 questions
(i) To add a new image to the Gallery, you can click on the______button.
(a) New theme (b) Add theme (c) New image (d) Add image
(ii) 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
(iii) ______is a list, usually found on a page before the start of a written work, of its chapter or section titles or brief
descriptions with their commencing page numbers.
(a) Table of contents (b) Acknowledgements (c) Page title (d) Preface
(iv) The processed form of data is known as______.
(a) value (b) information (c) knowledge (d) None of these
(v) For sorting through macro, the selected cell range must be______.
(a) formatted (b) identical (c) different (d) Both (b) and (c)
(vi) ______service can integrate both video calling and instant messaging abilities.
(a) Web browser (b) Web page (c)Web conferencing (d) None of these
4. Answer any 5 out of the given 6 questions
(i) State whether True or False.
Duplicate values can be entered in column marked as primary key.
(a) False (b) True
(ii) A collection of web pages linked together in a random order is_______.
(a) a search engine (b) a web browser (c) a website (d) a web server
(iii) The speed of a network is measured in______.
(a) kHz (b) mbps (c) bytes (d) None of these
Install NODIA App to See the Solutions.
Click Here To Install
Chap 1 Sample Paper 6 Page 3
(iv) ______are descriptions about the changes made in cells during record changes mode.
(a) Comments (b) Messages (c) Tips (d) None of these
(v) _____are used for transmitting data across networks.
(a) Channel (b) Circuit switching (c) Switching techniques (d) None of these
(vi) Which of the following is not a required information for Label set-up?
(a) Column (b) Height (c) Number (d) Vertical pitch
5. Answer any 5 out of the given 6 questions
(i) ______is the formation of networks.
(a) Client (b) Server (c) Networking (d) None of these
(ii) What data type should be chosen for a zipcode field in a table?
(a) Memo (b) Tat (c) Number (d) All of these
(iii) A table in a relational database is also called as_______.
(a) results (b) relation (c) tuple (d) records
(iv) Wireless broadband can be_______.
(a) fixed (b) mobile (c) Both (a) and (b) (d) None of these
(v) 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 a different person on each label or envelope.
(a) mail merge (b) E-mail (c) data source (d) database
(vi) The candidate key, which is not used as primary key is called______key.
(a) alternate (b) super (c) primary (d) foreign
SECTION - B
Subjective Type Questions
Direction for Q 6-Q 10 : Answer any 3 out of the given 5 questions on Employability skills. Answer each question in
20-30 words. Each question carry 2 marks.
6. Explain any two items of the Windows desktop.
7. Describe any two types of barriers to communication in one sentence each with examples.
8. Why is there a need for sustainable development? Give reasons.
9. Why is self-regulation important in life?
10. Explain the role and significance of entrepreneurs.
Direction for Q 11-Q 16 : Answer any 4 out of the given 6 questions in 20-30 words. Each question carry 2 marks.
11. What is the role of key fields in a database? Name the keys in a DBMS.
Install NODIA App to See the Solutions.
Click Here To Install
Page 4 Sample Paper 6 Chap 1
12. What is Mail Merge?
13. Define the following terms:
(i) Active Cell (ii) Sheet Tab
14. What is a macro?
15. How does a router help in maintaining a network ?
16. How can a document’s style be changed ? Explain with proper steps.
Direction for Q 17-Q 21 : Answer any 3 out of the given 5 questions in 50-80 words. Each question carry 4 marks.
17. What is sorting? How to use ascending or descending sort which depends on one column?
18. Write one example of each field for which you would use
(i) Text data type
(ii) Memo data type
19. Consider the following table: Employee
Table : Employee
Emp_no E_name Profile Manager Hire_date Salary Commission Dept no
8369 SMITH CLERK 8902 1990-12-18 8000 NULL 20
8499 ANYA SALESMAN 8698 1991-02-20 16000 300.00 30
8521 SETH SALESMAN 8698 1991-02-22 12500 500.00 30
8566 MAHA MANAGER 8839 1991-04-02 29850 NULL 20
DEVAN
8654 MOMIN SALESMAN 8698 1991-09-28 12500 1400.00 30
8698 BINA MANAGER 8839 1991-05-01 28500 NULL 30
(a) Write the SQL queries for the following:
(i) Display E name and salary of those employees whose Salary is less than or equal to 16000.
(ii) Display details of employees who are getting commission of ` 300 or greater.
(iii) Display all the details of the employee profile ‘CLERK’.
(b) How many fields and records are there in the table Employee?
20. Ajay is learning about the different terms and commands of a database. He came across the following terms . Tell
him the definition of the following
(i) Insert command (ii) Select command
(iii) Delete command (iv) DCL command
21. Sonia had heard about the various types of ISPs. She had some doubts. Answer to her queries to clear her doubts.
(a) What is an ISP?
(b) Name any two ISPs of India.
(c) What is satellite?
(d) Name any two connection types that home users use.
******
Install NODIA App to See the Solutions.
Click Here To Install