Information Technology (402) · Sample Paper 1

General instructions

Section A · Objective

1. Question 11 mark

   Which part of speech describes or modifies a noun?

   1. A.Verb
   2. B.Adverb
   3. C.Adjective
   4. D.Preposition
2. Question 21 mark

   Which of the following is a closed-ended question?

   1. A.What did you do on your holiday?
   2. B.How do you feel about the new rule?
   3. C.Did you finish the assignment?
   4. D.Why did you choose this subject?
3. Question 31 mark

   Doing an activity because you enjoy it, rather than for a reward, is an example of

   1. A.extrinsic motivation
   2. B.intrinsic motivation
   3. C.peer pressure
   4. D.time management
4. Question 41 mark

   Which of the following is a quality of a self-motivated person?

   1. A.Waits to be told what to do
   2. B.Gives up when tasks get difficult
   3. C.Sets goals and works towards them
   4. D.Blames others for failure
5. Question 51 mark

   Which software protects a computer from viruses and other malware?

   1. A.Word processor
   2. B.Antivirus
   3. C.Web browser
   4. D.Spreadsheet
6. Question 61 mark

   Which tool is used to remove temporary and unnecessary files to free up disk space?

   1. A.Disk Cleanup
   2. B.Task Manager
   3. C.Control Panel
   4. D.File Explorer
7. Question 71 mark

   An entrepreneur who introduces a completely new product or idea to the market is mainly playing the role of a(n)

   1. A.innovator
   2. B.employee
   3. C.consumer
   4. D.investor only
8. Question 81 mark

   Which of the following sectors creates green jobs?

   1. A.Coal mining
   2. B.Renewable energy
   3. C.Single-use plastic manufacturing
   4. D.Diesel generator sales
9. Question 91 mark

   Which key opens the Styles deck (Styles and Formatting) in LibreOffice Writer?

   1. A.F5
   2. B.F7
   3. C.F11
   4. D.F12
10. Question 101 mark

    A table of contents in LibreOffice Writer is inserted from the

    1. A.Insert menu
    2. B.Format menu
    3. C.Tools menu
    4. D.View menu
11. Question 111 mark

    The file extension of a LibreOffice Writer template is

    1. A..odt
    2. B..ott
    3. C..ots
    4. D..dot
12. Question 121 mark

    Which feature in LibreOffice Writer records the edits made by different reviewers in a document?

    1. A.Mail Merge
    2. B.Track Changes
    3. C.AutoCorrect
    4. D.Navigator
13. Question 131 mark

    The Consolidate feature in LibreOffice Calc is found in the

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

    Which tool in LibreOffice Calc finds the input value needed to get a desired result from a formula?

    1. A.Scenario
    2. B.Goal Seek
    3. C.Subtotals
    4. D.Sort
15. Question 151 mark

    Scenarios in LibreOffice Calc are mainly used for

    1. A.printing sheets
    2. B.what-if analysis
    3. C.spell checking
    4. D.inserting charts
16. Question 161 mark

    In LibreOffice Calc, the correct reference to cell A1 of a sheet named Sheet2 is

    1. A.=Sheet2!A1
    2. B.=Sheet2.A1
    3. C.=Sheet2:A1
    4. D.=Sheet2#A1
17. Question 171 mark

    In a database table, a column is also called a

    1. A.record
    2. B.field
    3. C.tuple
    4. D.query
18. Question 181 mark

    In a database table, a row is also called a

    1. A.record
    2. B.field
    3. C.attribute
    4. D.form
19. Question 191 mark

    A primary key is a field that

    1. A.can contain duplicate values
    2. B.uniquely identifies each record in a table
    3. C.must always be text
    4. D.links two databases on different computers
20. Question 201 mark

    Which SQL command is used to retrieve data from a table?

    1. A.INSERT
    2. B.UPDATE
    3. C.SELECT
    4. D.DELETE
21. Question 211 mark

    Which object in LibreOffice Base is used to display data in a formatted, printable layout?

    1. A.Table
    2. B.Query
    3. C.Form
    4. D.Report
22. Question 221 mark

    Which of the following is an instant messaging service?

    1. A.WhatsApp
    2. B.LibreOffice Calc
    3. C.Paint
    4. D.Notepad
23. Question 231 mark

    Which of these is the strongest password?

    1. A.password123
    2. B.12345678
    3. C.Ravi2008
    4. D.T#9v!qL2@x
24. Question 241 mark

    Malware that locks a user's files and demands payment to unlock them is called

    1. A.spyware
    2. B.adware
    3. C.ransomware
    4. D.a firewall

Section B · Short answer

1. Question 252 marks

   What are the basic parts of a sentence? Explain with an example.

2. OR

   Question 252 marks

   Mention any two steps for building self-confidence.

3. Question 262 marks

   Mention any two ways to keep a computer system healthy and safe.

4. Question 272 marks

   What is a green economy? Mention any one green job related to agriculture or energy.

5. OR

   Question 272 marks

   Mention any two functions of an entrepreneur.

6. Question 282 marks

   What is a template in LibreOffice Writer? Mention one advantage of using it.

7. Question 292 marks

   Mention any two safety measures to follow while using the internet.

Section C · Long answer

1. Question 304 marks

   Write the steps to create a table of contents in LibreOffice Writer, and how to update it after the document changes.

2. OR

   Question 304 marks

   What is Track Changes in LibreOffice Writer? Explain how changes are recorded, viewed and accepted or rejected.

3. Question 314 marks

   What is Goal Seek in LibreOffice Calc? Explain its use with an example.

4. OR

   Question 314 marks

   What are scenarios in LibreOffice Calc? Write the steps to create a scenario.

5. Question 324 marks

   Differentiate between a primary key and a foreign key, with an example of each.

6. Question 334 marks

   Explain any two online threats and suggest one way to protect yourself from each.