Page 16 - IPP-12-2024

13. Which type of cybercrime is characterized by the creation of fake accounts and the posting of content with
the intent to harm victims’ reputation by engaging in continuous and unwanted online aggression? (1)
(i) Cyberbullying (ii) Spoofing
(iii) Phishing (iv) Identity theft
Ans. (i) Cyberbullying

14. Which of the following SQL queries will display output as "MERRY" from the given string "MERRY
CHRISTMAS". (1)
(i) SELECT INSTR(“MERRY CHRISTMAS”, “MERRY”);
(ii) SELECT INSTR(‘MERRY CHRISTMAS’, 1,6);
(iii) SELECT SUBSTRING(‘MERRY CHRISTMAS’, ‘MERRY’);
(iv) SELECT SUBSTR(‘MERRY CHRISTMAS’,1,6);

Ans. (iv) SELECT SUBSTR(‘MERRY CHRISTMAS’,1,6);
15. A __________ in a computer network is a device used to connect multiple LANs to form a larger LAN. (1)
(i) Gateway (ii) Bridge
(iii) Repeater (iv) Router
Ans. (ii) Bridge
16. ____________ is a free software licence that allows the users to use, share and modify software without
paying for it. (1)
(i) Government Public Licence (ii) Apache Licence
(iii) Government Private Licence (iv) General Public Licence
Ans. (iv) General Public Licence

Q. 17 and 18 are ASSERTION and REASONING based questions. Mark the correct choice as
(a) Both A and R are true and R is the correct explanation of A.
(b) Both A and R are true but R is not the correct explanation of A.
(c) A is true but R is false.
(d) A is false but R is true.

17. Assertion (A): In tree topology, some devices are connected to the active hub and some devices are
connected to the passive hub. (1)
Reasoning (R): An active hub provides connection between connecting nodes, whereas passive hubs contain
repeaters that regenerate the signal when it becomes weaker for long-distance transmission.
Ans. (c) A is true but R is false.
18. Assertion (A): To create a series from an array, we have to import NumPy module. (1)

Reasoning (R): NumPy is an open-source numerical Python library. It provides high-performance
multidimensional array objects and tools for working with these arrays.
Ans. (a) Both A and R are true and R is the correct explanation of A.

SECTION B
19. Define the term Cookies. Write any two benefits of Cookies. (2)
OR
Differentiate between Static web page and Dynamic web page?
Ans. Cookies are small pieces of data stored as text files on a user’s device by a web browser while browsing
a website.
(a) Cookies help identify users and maintain their logged-in status.
(b) Cookies enable websites to personalize content based on users’ preferences and behaviours.
OR

MODEL TEST PAPER 3