Information Technology (402) · Sample Paper 2

General instructions

Section A · Objective

1. Question 11 mark

   In the sentence 'The children played happily', the word 'happily' is

   1. A.a noun
   2. B.an adjective
   3. C.an adverb
   4. D.a verb
2. Question 21 mark

   Which of these is an example of positive feedback?

   1. A.'You never listen.'
   2. B.'Your report was clear and well organised.'
   3. C.'That's wrong.'
   4. D.'Do it again.'
3. Question 31 mark

   Recognising one's own strengths and weaknesses is called

   1. A.self-awareness
   2. B.stress
   3. C.teamwork
   4. D.time management
4. Question 41 mark

   Wanting to do well to win a prize is an example of

   1. A.intrinsic motivation
   2. B.extrinsic motivation
   3. C.self-doubt
   4. D.stress
5. Question 51 mark

   Which of the following is a common symptom of a computer virus?

   1. A.The computer runs faster
   2. B.Files disappear or programs crash unexpectedly
   3. C.The screen becomes brighter
   4. D.The keyboard works better
6. Question 61 mark

   Regularly copying important files to another storage device is called

   1. A.formatting
   2. B.backup
   3. C.defragmentation
   4. D.scanning
7. Question 71 mark

   Which of these is a characteristic of an entrepreneur?

   1. A.Avoids all risk
   2. B.Takes calculated risks
   3. C.Waits for instructions
   4. D.Fears change
8. Question 81 mark

   Which of the following is a renewable energy source used in green jobs?

   1. A.Natural gas
   2. B.Coal
   3. C.Solar power
   4. D.Diesel
9. Question 91 mark

   In LibreOffice Writer, a style that applies to a whole paragraph is a

   1. A.character style
   2. B.paragraph style
   3. C.frame style
   4. D.list style
10. Question 101 mark

    The shortcut key to open the Styles deck in LibreOffice Writer is

    1. A.F5
    2. B.F11
    3. C.F7
    4. D.F2
11. Question 111 mark

    Which of the following allows you to place an image so that text flows around it?

    1. A.Wrap
    2. B.Indent
    3. C.Merge
    4. D.Sort
12. Question 121 mark

    A document created from a template is saved by default with the extension

    1. A..ott
    2. B..odt
    3. C..ods
    4. D..odp
13. Question 131 mark

    Which feature in Calc combines data from several sheets into one summary sheet?

    1. A.Goal Seek
    2. B.Consolidate
    3. C.Subtotal
    4. D.Scenario
14. Question 141 mark

    The Subtotals feature in LibreOffice Calc is found in the

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

    To link to cell B2 of a sheet named 'Sales' in the same file, you write

    1. A.Sales:B2
    2. B.$Sales.B2
    3. C.B2@Sales
    4. D.#Sales B2
16. Question 161 mark

    The 'Record Changes' feature in Calc is used to

    1. A.record macros
    2. B.track edits made to a shared spreadsheet
    3. C.record audio
    4. D.count rows
17. Question 171 mark

    A collection of related records stored in rows and columns is a

    1. A.form
    2. B.table
    3. C.report
    4. D.query
18. Question 181 mark

    Which data type would you use to store a date of birth?

    1. A.Text
    2. B.Number
    3. C.Date
    4. D.Boolean
19. Question 191 mark

    A field in one table that refers to the primary key of another table is a

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

    Which SQL command is used to add new records to a table?

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

    Which Base object provides a user-friendly screen for entering data?

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

    Software that records keystrokes to steal passwords is called a

    1. A.keylogger
    2. B.firewall
    3. C.browser
    4. D.cookie
23. Question 231 mark

    Which of these is a safe practice while shopping online?

    1. A.Using public Wi-Fi for payments
    2. B.Checking for https and a padlock in the address bar
    3. C.Sharing OTP with the seller
    4. D.Saving card details on any site
24. Question 241 mark

    A program or device that monitors and blocks unauthorised network traffic is a

    1. A.firewall
    2. B.spam
    3. C.phishing
    4. D.cookie

Section B · Short answer

1. Question 252 marks

   What are the two types of sentences based on their function? Give an example of each — any two of statement, question, command, exclamation.

2. OR

   Question 252 marks

   What is time management? Give two techniques for managing time well.

3. Question 262 marks

   What is spam? How can you protect yourself from it?

4. Question 272 marks

   Give two ways in which green jobs help in sustainable development.

5. OR

   Question 272 marks

   How does an entrepreneur help society? Give two points.

6. Question 282 marks

   Differentiate between a database and a DBMS.

7. Question 292 marks

   What is phishing? Give one way to identify a phishing email.

Section C · Long answer

1. Question 304 marks

   What is an image in LibreOffice Writer? Explain the steps to insert an image and to change its wrapping and alignment.

2. OR

   Question 304 marks

   Explain any four types of styles available in LibreOffice Writer.

3. Question 314 marks

   What is 'Subtotals' in LibreOffice Calc? Write the steps to use it on a sheet listing sales by region.

4. OR

   Question 314 marks

   What are macros in LibreOffice Calc? Write the steps to record a simple macro.

5. Question 324 marks

   A table STUDENT has the fields RollNo, Name, Class and Marks. Write SQL statements to:

   (a) display all records, (b) display the names of students who scored more than 80, (c) display all records in descending order of marks, (d) change the marks of RollNo 5 to 90.

6. Question 334 marks

   What is cybercrime? Explain any three ways to stay safe online.