6 Sample Paper

Self-Assessment

सू चना प्रौद्योगिकी
INFORMATION TECHNOLOGY
Time Allowed: 2 Hours Maximum Marks: 50

General Instructions: Same instructions as given in Sample Paper 1.

SECTION - A

(Objective Type Questions)

24 marks

1. Answer any 4 out of the given 6 questions on Employability Skills. (1 x 4 = 4 marks)

(A) Communication is essential for human existence but .................... is the livewire of
communication. (a) words (b) thoughts (c) expressions (d) feedback

(B) Stress management prevents .................... problems. (a) Behavioural (b) Psychological (c)
Physical (d) Both (a) and (b)

(C) Which of the following is an idea of self-employment? (a) Making a shoe in factory. (b)
Selling shoe in a showroom. (c) Owning a shoe factory/showroom. (d) Maintaining accounts
of shoe factory/showroom.

(D) Imagine you are a high school student and your board practicals are round the corner.
You haven’t prepared your practical file and so you are stressed. A person is said to be
stressed if he is: (a) tense (b) worried (c) relaxed (d) both (a) and (b)

(E) The organisation that has been assigned responsibility of supervising and coordinating the
actions and schemes of SDGs: (a) NEET (b) NTA (c) ARPANET (d) NITI Aayog

(F) Shortcut keys used to paste a file is: (a) Ctrl + C (b) Ctrl + P (c) Ctrl + V (d) Ctrl + X

2. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)

(A) .................... style affects numbering and bullet style. (a) Page (b) Frame (c) List (d)
Paragraph
(B) What will be the output of = MAX(10, 18, –210, 190)? (a) 190 (b) –210 (c) 18 (d) 10

(C) To make the picture as mirror placed at the bottom of the image .................... tool is used.
(a) Flip horizontal (b) Flip vertical (c) Rotate (d) Crop

(D) Khushi is inserting an image in her document. She wants to increase the contrast of this
image, which graphic filter should she choose? (a) Smooth (b) Sharpen (c) Invert (d) Remove
Noise

(E) Scenarios are the tool to test .................... type of questions. (a) If-else (b) What-if (c)
What-then (d) If-then

(F) Archika is an interior designer who has got a project to design interiors of an IT company.
How the workstations be oriented so that minimum artificial light sources are required during
day time and the bright day light doesn’t affect the screen visibility. (a) Place workstations
near windows. (b) Give large windows near the workstations. (c) Place the workstations in
open spaces. (d) Place workstations such that the light falls to the right angles of them.

3. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)

(A) Consolidate options is available under .................... menu. (a) Tools (b) View (c) Insert
(d) Data

(B) Which of the following styles is not offered by a word processor? (a) Page style (b)
Presentation style (c) Frame style (d) Character style

(C) Smriti has to create an official letter urgently. So she decided to use template to save her
time in doing formatting. Which of the following commands should she use to perform the
same? (a) File New Template (b) File Template New (c) File Save Template (d)
File Template Save

(D) Siddhant used the Update Index Table command in his document. Why do you think he
must have used it? (a) He must have added a heading in his document. (b) He must have
deleted a heading from his document. (c) He must have edited a heading in his document. (d)
All of these

(E) .................... feature is known to be disabled in a shared spreadsheet. (a) Protect

document (b) Consolidate (c) Compare document (d) All of these

(F) Which of the following component is NOT a part of database? (a) Queries (b) Forms (c)
Tables (d) Tools

4. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)

(A) A table has .................... rows and .................... columns. (a) Vertical, Horizontal (b)
Horizontal, Vertical (c) Random, Fixed (d) Diagonal, Circular

(B) Isha wants to mark changes in her spreadsheet temporarily so that she can review them
later. She should use the .................... mode in calc. (a) Shared Mode (b) Macro (c) Record
Changes mode (d) Change mode
(C) The Product database links to the Quantity table via ProductID. If ProductID is deleted
from Quantity, balance reports can’t be generated. Which DBMS rule is violated here? (a)
Data Consistency (b) Data Redundancy (c) Referential Integrity (d) Relationship

(D) .................... is a fixed length data type and .................... is a variable length data type. (a)
Char, Varchar (b) Varchar, Char (c) Double, Real (d) Integer, Double

(E) A written statement by the employer stating the company’s commitment for the
protection of the health, safety and security of its employees. (a) Safety policy (b) Security
policy (c) Health policy (d) Health, safety and security policy

(F) Select the ways to reduce air pollution which an organisation can follow. (a) Use limited
automobiles. (b) Observe a no vehicle day in the week. (c) Producers of dust particles must
be checked. (d) All of these

5. Answer any 5 out of the given 6 questions. (1 x 5 = 5 marks)

(A) Meeta is creating a sales report using Report Wizard. She wants that the sales of same
Zonal Office should appear together, and for each Zonal office the sales data should be
printed in descending order of the sales. What should Meeta do to perform the same? (a) She
should create a table in the required order and then use it to generate report. (b) She should
add ZonalOffice as Group Field in the report and sort the group on the basis of Sales in
descending order. (c) Both (a) and (b) (d) None of these

(B) SELECT command of SQL is a .................... type of command. (a) DDL (b) DML (c)
TCL (d) Arithmetic

(C) The Table Design view allows you to: (a) add fields (b) delete fields (c) change field
properties (d) all of these

(D) Occupational Overuse syndrome can cause: (a) Strain in legs and feet (b) Conjunctivitis
(c) Obesity (d) Both (a) and (c)

(E) Some of the most common causes of work place fire are: (I) Improper handling of
flammable materials and combustible substances. (II) Damaged electrical cords (III)
Unplanned placement of furniture (IV) Fully covered emergency exits (a) (I) and (II) (b) only
(II) (c) (I), (II) and (III) (d) All of these

(F) Snigdha is fond of wearing metal jewellery. She wears many rings and bangles every day
to the office. Her manager asked her to not to come with so much jewellery because: (a) it is
against the work culture. (b) it is not in accordance with the dress code. (c) the jewellery
made of conductive materials can damage computer components by striking them with static
electricity. (d) The sound of the ornaments distracts the co-workers.

SECTION - B

(Subjective Type Questions)

26 marks

Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6

marks) Answer each question in 20 – 30 words.

6. Verbal communication takes the form of face-to-face or interpersonal communication or

small groups and public address systems. What do you think are the reasons for the
popularity of the verbal communication methods? Write any two reasons. 2

7. What points are to be taken into consideration before deciding the entrepreneurship as a
career ? Write two points. 2

8. Arnav’s sister accidentally deleted some of his project files and images. He wants to get
the deleted files back. Write steps to restore a deleted file in Windows. 2

9. Kritika is a UPSC aspirant. She devotes minimum 6 to 7 hours to her studies. She also
gives tuition to school students to earn her pocket money. In addition to this sometimes she
has to help her father in his shop. What will be the consequences if she could not manage
time for all her tasks? 2

10. What does ‘T’ mean in SMART? 2

Answer any 4 out of the given 6 questions in 20–30 words each. (2 x 4 = 8 marks)

11. Write a short note on Fill Format mode. 2

12. Sudhir has organised a safety and health awareness workshop in his office for the
employees. In the first session of the workshop the employees were taught about the types
and causes of accidents at a workplace. What are these types and causes of accidents? Write
about any two. 2

13. Sameer is analysing a shared sheet. His two other colleagues are also working on the
same sheet. Wherever they want to make changes, they mark comments in it. What is the
purpose of adding such comments in a worksheet? How is it done? 2

14. Sumit is head librarian in a college library. The library is too big and has many sections
containing books on different subjects. Each section is headed by an assistant librarian. The
records of all the books and members are kept in a workbook which is shared between him
and all other assistant librarians. What is the advantage of sharing data? 2

15. What are the advantages of using primary key in a table? 2

16. What do you understand by emergency? What are its types? 2

Answer any 3 out of the given 5 questions in 50–80 words each. (4 x 3 = 12 marks)

17. Saksham has written a book about his journey from school to the medical college and his
life at hostel. (A) To create an index of chapter names, topics, and page numbers in a word
processor which tool should he use? What are the prerequisites for it? (B) What will happen
if a heading in the document is changed? Where is this index placed? 4
18. Looking at your reckless expenses, your father decides to hand over the responsibility of
managing the household budget to you, so that you should learn to be responsible. (A) To
manage the monthly household budget which application can be used? (B) After a few
months you realize that some cost cutting is required to save money for the upcoming festive
season. Name the tool that can be used to estimate the result of cost-cutting. (C) What’s the
primary objective of these tools? (D) Are there any other tools that could be relevant for this
task? 4

19. Explain the concepts of a Table in reference to DBMS. What are different components of
a table? What are constraints and how are they applied? 4

20. Abhay, a corporate employee, is feeling pain, numbness and tingling in the hand and arm.
What could be the possible reason for this? How can this be avoided? 4

21. Following table displays a part of information of Train Bookings.

Table : Booking

Booking-No Pass-Name Boarding-Stn Destination Travel-Date Status

112456 Amit Sahni Delhi Jaipur 2022-09-20 Booked
123980 Kasturi Bangalore Delhi 2022-10-07 Cancel
234167 Shalini Delhi Mumbai 2022-10-06 Booked
289765 Devendra Jaipur Agra 2022-11-05 Booked

(A) Which data type is used for column Travel Date? (B) Write SQL query to add a column
TrainNo as Integer. (C) Name the primary key of this table. (D) If the new column Train no
is added to the table can it be used as the primary key? Why or why not? 4