Information Technology (402) · Sample Paper 3

General instructions

Section A · Objective

1. Question 11 mark

   Which part of speech is the word 'quickly' in 'She ran quickly'?

   1. A.noun
   2. B.adjective
   3. C.adverb
   4. D.pronoun
2. Question 21 mark

   Communication in which the receiver gives a response is

   1. A.one-way
   2. B.two-way
   3. C.non-verbal only
   4. D.written only
3. Question 31 mark

   Which of these helps in managing stress?

   1. A.skipping meals
   2. B.regular exercise
   3. C.staying up all night
   4. D.avoiding friends
4. Question 41 mark

   Setting a deadline for a task is part of

   1. A.time management
   2. B.stress
   3. C.procrastination
   4. D.anger management
5. Question 51 mark

   Which of these should you do to keep your computer safe?

   1. A.share your password
   2. B.install updates regularly
   3. C.open unknown attachments
   4. D.disable antivirus
6. Question 61 mark

   Software designed to harm a computer is

   1. A.firmware
   2. B.malware
   3. C.freeware
   4. D.shareware
7. Question 71 mark

   Which of these is a function of an entrepreneur?

   1. A.taking risks and making decisions
   2. B.avoiding new ideas
   3. C.working only for wages
   4. D.following orders only
8. Question 81 mark

   Which practice is part of a green economy?

   1. A.burning stubble
   2. B.using renewable energy
   3. C.dumping waste in rivers
   4. D.cutting forests
9. Question 91 mark

   In Writer, a template file has the extension

   1. A..odt
   2. B..ott
   3. C..ods
   4. D..odp
10. Question 101 mark

    A table of contents is generated automatically using

    1. A.character styles
    2. B.heading styles
    3. C.page styles
    4. D.frame styles
11. Question 111 mark

    Which menu is used to update a table of contents after editing?

    1. A.right-click > Update Index
    2. B.File > Save
    3. C.View > Zoom
    4. D.Insert > Page Break
12. Question 121 mark

    Which feature lets reviewers add notes to a document without changing its text?

    1. A.comments
    2. B.styles
    3. C.templates
    4. D.headers
13. Question 131 mark

    Goal Seek in Calc is found in the

    1. A.Tools menu
    2. B.Data menu
    3. C.Insert menu
    4. D.Format menu
14. Question 141 mark

    Which feature allows several what-if sets of values to be stored and shown in the same cells?

    1. A.Scenarios
    2. B.Subtotals
    3. C.Consolidate
    4. D.Sort
15. Question 151 mark

    Linking to data in another spreadsheet file uses

    1. A.Sheet > Link to External Data
    2. B.Format > Cells
    3. C.View > Toolbars
    4. D.Edit > Undo
16. Question 161 mark

    A collection of recorded actions that can be replayed is a

    1. A.macro
    2. B.scenario
    3. C.chart
    4. D.filter
17. Question 171 mark

    Which data type stores whole numbers in Base?

    1. A.Text
    2. B.Integer
    3. C.Date
    4. D.Boolean
18. Question 181 mark

    A key made of two or more fields together is a

    1. A.primary key
    2. B.composite key
    3. C.foreign key
    4. D.candidate key
19. Question 191 mark

    Which SQL command removes records from a table?

    1. A.DROP
    2. B.DELETE
    3. C.REMOVE
    4. D.ERASE
20. Question 201 mark

    Which Base object is used to retrieve specific data based on conditions?

    1. A.Table
    2. B.Form
    3. C.Query
    4. D.Report
21. Question 211 mark

    In a relationship where one record of table A links to many records of table B, the relationship is

    1. A.one-to-one
    2. B.one-to-many
    3. C.many-to-many
    4. D.none
22. Question 221 mark

    A small file stored by a website on your computer to remember your preferences is a

    1. A.virus
    2. B.cookie
    3. C.firewall
    4. D.worm
23. Question 231 mark

    Which of these is a strong password?

    1. A.123456
    2. B.password
    3. C.Rk#7v!q2Lm
    4. D.yourname
24. Question 241 mark

    Bullying someone online through threatening messages is

    1. A.phishing
    2. B.cyberbullying
    3. C.hacking
    4. D.spamming

Section B · Short answer

1. Question 252 marks

   What are the basic parts of a sentence? Identify them in 'The dog barked loudly.'

2. OR

   Question 252 marks

   What is self-confidence? Give two ways to build it.

3. Question 262 marks

   What is disk cleanup and why is it needed?

4. Question 272 marks

   Name two green jobs in agriculture and energy.

5. OR

   Question 272 marks

   What are the qualities of a successful entrepreneur? Give two.

6. Question 282 marks

   What is the use of 'Consolidate' in Calc?

7. Question 292 marks

   Give two precautions to follow while using social networking sites.

Section C · Long answer

1. Question 304 marks

   What is a template? Write the steps to create and use a template in LibreOffice Writer.

2. OR

   Question 304 marks

   Explain how to insert an image and add a caption to it in LibreOffice Writer.

3. Question 314 marks

   A loan amount is in B1, interest rate in B2, number of months in B3 and the monthly instalment formula in B4. Explain how Goal Seek can find the loan amount for a target instalment of ₹5 000.

4. OR

   Question 314 marks

   Explain the steps to share a spreadsheet and record changes made by different users in LibreOffice Calc.

5. Question 324 marks

   A table EMPLOYEE has fields EmpID, Name, Dept and Salary. Write SQL queries to:

   (a) display the names of employees in the 'Sales' department, (b) display all records in ascending order of salary, (c) insert a record (105, 'Ravi', 'HR', 30000), (d) display the number of employees in each department.

6. Question 334 marks

   Explain any four ways to protect yourself from online identity theft.