Karnataka 2nd PUC Question Paper 2026 Computer Science

£ÉÆÃAzÀt ¸ÀASÉå :
Registration No. :

V1 – 2026
«µÀAiÀÄ ¸ÀAPÉÃvÀ /
41 (NS)
Subject Code

UÀtPÀ «eÕÁ£À / COMPUTER SCIENCE
(Kannada and English Versions)

[¸ÀªÀÄAiÀÄ: 3 UÀAmÉUÀ¼ÀÄ] [MlÄÖ ¥Àæ±ÉßUÀ¼À ¸ÀASÉå : 44] [UÀjµÀ× CAPÀUÀ¼ÀÄ : 70]
[Time : 3 Hours] [Total No. of questions : 44] [Max. Marks : 70]

(Kannada Version)

¸ÀÆZÀ£ÉUÀ¼ÀÄ : 1. F ¥Àæ±ßÉ ¥ÀwæPÉAiÀÄ°è A, B, C, D, E JA§ LzÀÄ ¨sÁUÀU½
À ªÉ.
2. ¨sÁUÀ-A zÀ°è£À ¥Àæ±ÉßUÀ½UÉ ¥ÀæxÀªÀĪÁV §gÉzÀ GvÀÛgÀUÀ¼À£ÀÄß
ªÀiÁvÀæ ªÀiË®åªÀiÁ¥À£ÀzÀ°è ¥ÀjUÀt¸À¯ÁUÀĪÀÅzÀÄ.

¨sÁUÀ – A
J¯èÁ ¥Àæ±ÉßUÀ½UÉ GvÀÛj¹. ¥ÀæwAiÉÆAzÀÄ ¥Àæ±ÉßUÉ 1 CAPÀ. (20 × 1 = 20)

I. PÉÆnÖgÀĪÀ DAiÉÄÌUÀ¼À°è ¸ÀjAiÀiÁzÀ GvÀÛgÀªÀ£ÀÄß DAiÉÄÌ ªÀiÁr.

1) Q = N/D JAzÀÄ ¤ÃqÀ¯ÁVzÉ, D = 0 ªÀÄvÀÄÛ N = 100 DzÀgÉ AiÀiÁªÀ
CAvÀ¤ð«ÄðvÀ JPÉì¥Àë£ï §gÀÄvÀÛzÉ?

a) Zero Division Error b) Index Error
c) Value Error d) Syntax Error

P.T.O.

41 (NS) -2-

2) PÀqÀvÀzÀ°è£À file-object £À ¥Àæ¸ÀÄÛvÀ ¸ÁÜ£ÀzÀ ¥ÀÆuÁðAPÀªÀ£ÀÄß »AwgÀÄV¸ÀĪÀ
PÁAiÀÄðªÀÅ
a) seek b) load
c) tell d) dump

3) ¥Àæw¥ÁzÀ£É (A) : ªÉÄzÉ JA§ÄzÀÄ gÉÃTÃAiÀÄ zÀvÁÛA±À gÀZÀPÀªÁVzÀÄÝ
CA±ÀUÀ¼À£ÀÄß FIFO PÀæªÀÄzÀ°è ±ÉÃRj¸À¯ÁUÀÄvÀÛzÉ.
PÁgÀt (R) : ªÉÄzÉAiÀÄ°è ºÉƸÀ CA±ÀªÀ£ÀÄß MAzÉà vÀÄ¢¬ÄAzÀ
ºÁPÀ¯ÁUÀÄvÀÛzÉ ªÀÄvÀÄÛ vÉUÉAiÀįÁUÀÄvÀÛzÉ.
a) (A) ªÀÄvÀÄÛ (R) JgÀqÀÆ ¸Àj¬ÄzÉ ªÀÄvÀÄÛ (R), (A) £À ¸ÀjAiÀiÁzÀ
«ªÀgÀuÉAiÀiÁVzÉ
b) (A) ªÀÄvÀÄÛ (R) JgÀqÀÆ ¸Àj¬ÄzÉ ªÀÄvÀÄÛ (R), (A) £À ¸ÀjAiÀiÁzÀ
«ªÀgÀuÉAiÀÄ®è
c) (A) ¸Àj¬ÄzÉ (R) vÀ¥ÁàVzÉ

d) (A) vÀ¥ÁàVzÉ (R) ¸Àj¬ÄzÉ

4) SÁ° ¸ÀgÀwAiÀÄ£ÀÄß gÀa¸À®Ä AiÀiÁªÀ CAvÀ¤ð«ÄðvÀ PÁAiÀÄðªÀ£ÀÄß
¥ÉÊxÁ£ï£À°è §¼À¸À¯ÁUÀÄvÀÛzÉ?

a) enqueue( ) b) list( )
c) append( ) d) insert( )

5) DgÉÆúÀt PÀæªÀÄzÀ°è «AUÀr¸ÀĪÁUÀ §§¯ï «AUÀqÀuÉAiÀÄ°è, AiÀiÁªÀ
CA±ÀªÀÅ ªÉÆzÀ® ¥Á¸ï £ÀAvÀgÀ, CzÀgÀ ¸ÀjAiÀiÁzÀ ¸ÁÜ£ÀªÀ£ÀÄß vÀ®Ä¥ÀÄvÀÛzÉ?
a) Cw aPÀÌ CA±À b) ªÀÄzsÀåzÀ CA±À
c) Cw zÉÆqÀØ CA±À d) JgÀqÀ£Éà Cw zÉÆqÀØ CA±À

-3- 41 (NS)

6) n2 ¸ÀªÀÄAiÀÄ ¸ÀAQÃtðvÉAiÀÄ£ÀÄß ºÉÆA¢gÀĪÀ PÀæªÀiÁªÀ½AiÀÄ£ÀÄß «±Éèö¸À®Ä
AiÀiÁªÀ ¥ÀzÀªÀ£ÀÄß §¼À¸À¯ÁUÀÄvÀÛzÉ, ¸ÁªÀiÁ£ÀåªÁV £É¸q ÉÖ ï ®Æ¥ïUÀ½AzÀ
F ¸ÀAQÃtðvÉ GAmÁUÀÄvÀÛzÉ.

a) gÉÃTÃAiÀÄ ¸ÀªÀÄAiÀÄ PÀæªÀiÁªÀ½
b) WÁwÃAiÀÄ ¸ÀªÀÄAiÀÄ PÀæªÀiÁªÀ½
c) PÁéqÁænPï ¸ÀªÀÄAiÀÄ PÀæªÀiÁªÀ½
d) ¹ÜgÀ ¸ÀªÀÄAiÀÄ PÀæªÀiÁªÀ½

7) qÉÃmÁ¨Éøï£À°è zÀvÁÛA±À ¤§ðAzsÀzÀ GzÉÝñÀ
a) «±Áé¸ÀªÀ£ÀÄß SÁvÀj¥Àr¸À®Ä

b) qÉÃmÁ¨Éøï£À UÁvÀæªÀ£ÀÄß ªÁåSÁ夸À®Ä
c) ¸ÀAUÀæºÀt £ÀªÀÄÆ£ÉAiÀÄ£ÀÄß ¸ÀàµÀÖ¥Àr¸À®Ä
d) PÉéöÊjAiÀÄ ªÉÃUÀªÀ£ÀÄß ºÉaѸÀ®Ä

8) SQL £À°è order by G¥ÀªÁPÀå K£ÀÄ ªÀiÁqÀÄvÀÛzÉ?

a) PÀA§¸Á°£À ªÀiË®åUÀ¼À DzsÁgÀzÀ ªÉÄÃ¯É CqÀظÁ®ÄUÀ¼À£ÀÄß
«AUÀr¸ÀÄvÀÛzÉ
b) µÀgÀvÀÄÛUÀ¼À DzsÁgÀzÀ ªÉÄÃ¯É CqÀظÁ®ÄUÀ¼À£ÀÄß ¸ÉÆøÀÄvÀÛzÉ
c) MAzÉà jÃwAiÀÄ ªÀiË®åUÀ¼À£ÀÄß ºÉÆA¢gÀĪÀ CqÀظÁ®ÄUÀ¼À£ÀÄß UÀÄA¥ÀÄ
ªÀiÁqÀÄvÀÛzÉ
d) ªÀÄgÀ½¸ÀĪÀ CqÀظÁ®ÄUÀ¼À ¸ÀASÉåAiÀÄ£ÀÄß «ÄwUÉƽ¸ÀÄvÀÛzÉ

41 (NS) -4-

9) MYSQL £À°è zÀ±ÀªÀiÁA±À ©AzÀÄUÀ¼À£ÀÄß ºÉÆA¢gÀĪÀ ¸ÀASÉåUÀ¼À£ÀÄß
»r¢lÄÖPÉƼÀî®Ä AiÀiÁªÀ qÉÃmÁmÉÊ¥ï C£ÀÄß §¼À¸À¯ÁUÀÄvÀÛzÉ?
a) FLOAT b) DATE
c) INT d) INTEGER

10) SQL ºÉýPÉUÀ¼À£ÀÄß ¹éÃPÀj¸À®Ä ¹zÀÞªÁVzÉ JAzÀÄ ¸ÀÆa¸ÀĪÀ MYSQL £À
¥ÁæA¥ïÖ EzÁVzÉ.
a) >>> b) mysql>
c) cmd> d) db>

11) PɼÀV£ÀªÀÅUÀ¼À°è AiÀiÁªÀÅzÀÄ WAN £À Cw zÉÆqÀØ GzÁºÀgÀuÉAiÀiÁVzÉ?
a) «±Àé«zÁå®AiÀÄzÀ PÁåA¥À¸ï£À eÁ®
b) ªÀÄ£ÉAiÀÄ ªÉÊ¥sÉÊ eÁ®
c) CAvÀeÁð®
d) §ÆèlÆvï

12) AiÀiÁªÀ £ÉmïªÀPïð mÉÆ¥ÉÆ®fAiÀÄ°è zÀvÁÛA±ÀªÀÅ KPÀªÀÄÄRªÁV
gÀªÁ£ÉAiÀiÁUÀÄvÀÛzÉ?
a) ¸ÁÖgï b) jAUï
c) ªÉĵï d) §¸ï

13) ¥ÀÆtð qÀÆå¥ÉèPïì ¸ÀAªÀºÀ£À «zsÁ£ÀzÀ GzÁºÀgÀuÉAiÀÄÄ

a) ªÁQ-mÁQà b) ¥sÁå£ï
c) n.«. d) ªÉƨÉʯï

-5- 41 (NS)

14) HTTP AiÀÄ C©üªÀÈ¢ÞAiÀÄ£ÀÄß ªÀÄÄ£ÀßqɹzÀªÀgÀÄ

a) ZÁ¯ïìð ¨Áå¨ÉÃeï b) ©eÉ£ïð ¸ËÖçmï¸ÀÖç¥ï
c) gÁAiÀiï mÁªÀiï°£ï¸À£ï d) nªÀiï §gï£À¸ïð °Ã

15) vÀ£Àß PÉ®¸ÀªÀ£ÀÄß M§âAnAiÀiÁV ªÀiÁrPÉƼÀÄîªÀ ¸ÁªÀÄxÀåð ºÉÆA¢gÀĪÀ
¥ÉÆæÃUÁæªÀiïUÀ¼ÀÄ
a) ªÀªÀiïð b) mÉÆæÃd£ï PÀÄzÀÄgÉ
c) gÁå£ïìªÀiïªÉÃgï d) ¸ÉàöʪÉÃgï

II. DªÀgÀtzÀ°è PÉÆnÖgÀĪÀ ¸ÀÆPÀÛ ¥ÀzÀ/¥ÀzÀUÀ¼À£ÀÄß DAiÉÄÌ ªÀiÁr
©lÖ ¸ÀܼÀUÀ¼À£ÀÄß ¨sÀwð ªÀiÁr.
(Dump, Upper, Parsing, Redundancy, Distinct, Length)

16) ¹AmÁåPïì zÉÆõÀUÀ¼À£ÀÄß, ____________ zÉÆõÀUÀ¼ÀÄ JAzÀÄ ¸ÀºÀ
PÀgÉAiÀįÁUÀÄvÀÛzÉ.

17) ¢éªÀiÁ£À PÀqÀvÀzÀ°è zÀvÁÛA±ÀªÀ£ÀÄß §gÉAiÀįÉAzÀÄ ¥ÉÊxÁ£ï ªÀ¸ÀÄÛUÀ¼À£ÀÄß
¥ÀjªÀwð¸À®Ä ____________ «zsÁ£ÀªÀ£ÀÄß §¼À¸À¯ÁUÀÄvÀÛzÉ.

18) ____________ JA§ÄzÀÄ MAzÉà §UÉAiÀÄ zÀvÁÛA±ÀªÀ£ÀÄß ¨ÉÃgÉ ¸ÀܼÀUÀ¼À°è
(PÀqÀvÀUÀ¼À°è) £ÀPÀ®Ä ªÀiÁqÀĪÀÅzÁVzÉ.

19) ___________ G¥ÀªÁPÀåªÀ£ÀÄß SQL PÉéöÊjAiÀÄ select £ÉÆA¢UÉ £ÀPÀ®Ä
¨É¯ÉUÀ¼À£ÀÄß ¤AiÀÄAwæ¸À®Ä §¼À¸À¯ÁUÀÄvÀÛzÉ.

20) SQL £À°è ____________ PÁAiÀÄðªÀÅ PÉÆnÖgÀĪÀ ¤¢ðµÀÖ ¹ÖçAUï£À°ègÀĪÀ
CPÀëgÀUÀ¼À ¸ÀASÉåAiÀÄ£ÀÄß »AwgÀÄV¸ÀÄvÀÛzÉ.

41 (NS) -6-

¨sÁUÀ – B

III. AiÀiÁªÀÅzÁzÀgÀÆ £Á®ÄÌ ¥Àæ±ÉßUÀ½UÉ GvÀÛj¹. ¥ÀæwAiÉÆAzÀÄ ¥Àæ±ÉßUÉ 2 CAPÀUÀ¼ÀÄ.
(4 × 2 = 8)

21) ¥ÀƪÀð¥ÀævÀåAiÀÄ ªÀÄvÀÄÛ GvÀÛgÀ¥ÀævÀåAiÀÄ GQÛUÀ¼ÉAzÀgÉãÀÄ?

22) ¸ÀgÀwAiÀÄ PÉÆ£ÉAiÀÄ°è ºÉƸÀ CA±ÀªÀ£ÀÄß ¸ÉÃj¸À®Ä ¥ÉÊxÁ£ï PÁAiÀÄðªÀ£ÀÄß
§gɬÄj.

23) ªÀiÁ¥Àðr¹zÀ ¨ÉÊ£Àj ºÀÄqÀÄPÁlzÀ AiÀiÁªÀÅzÁzÀgÀÆ JgÀqÀÄ C£ÀéAiÀÄUÀ¼À£ÀÄß
w½¹.

24) ¤ÃrgÀĪÀ ¸ÀA§AzsÀ : Guardian, EzÀgÀ°è ¸ÀA§AzsÀzÀ rVæ ªÀÄvÀÄÛ
PÁrð£Á°nAiÀÄ£ÀÄß §gɬÄj.
GUID GName Gphone

44444 Amit 5711492685

11111 Bhutia 3612967082

46644 Sujata 3801923168

10101 Himanshu 4726309212

25) Delete DzÉñÀªÀ£ÀÄß SQL £À°è KPÉ §¼À¸À¯ÁUÀÄvÀÛzÉ? EzÀgÀ
¹AmÁåPïì C£ÀÄß §gɬÄj.

26) PÀA¥ÀÆålgï eÁ®zÀ°è MODEM £À ¥ÁvÀæªÉãÀÄ?

27) AiÀiÁªÀÅzÁzÀgÀÆ JgÀqÀÄ vÀAw ªÀiÁzsÀåªÀĪÀ£ÀÄß ºÉ¸Àj¹.

-7- 41 (NS)

¨sÁUÀ – C

IV. AiÀiÁªÀÅzÁzÀgÀÆ £Á®ÄÌ ¥Àæ±ÉßUÀ½UÉ GvÀÛj¹. ¥ÀæwAiÉÆAzÀÄ ¥Àæ±ÉßUÉ 3 CAPÀUÀ¼ÀÄ.
(4 × 3 = 12)

28) Raise ºÉýPÉAiÀÄ GzÉÝñÀªÉãÀÄ? EzÀgÀ ¹AmÁåPïì ªÀÄvÀÄÛ
GzÁºÀgÀuÉAiÀÄ£ÀÄß §gɬÄj.

29) PÀqÀvÀ JAzÀgÉãÀÄ? ¥ÉÊxÁ£ï£À°è PÀqÀvÀUÀ¼À£ÀÄß vÉgÉAiÀÄĪÀ AiÀiÁªÀÅzÁzÀgÀÆ
JgÀqÀÄ §UÉUÀ¼À£ÀÄß «ªÀj¹.

30) PɼÀV£ÀªÀÅUÀ¼À£ÀÄß GvÀÛj¹.
a) «AUÀqÀuÉAiÀÄ£ÀÄß ªÁåSÁ夹.
b) ¸Áé¦AUï JAzÀgÉãÀÄ?
c) DAiÉÄÌ «AUÀqÀuÉAiÀÄ°è “n” CA±ÀUÀ¼À£ÀÄß «AUÀr¸À®Ä JµÀÄÖ
¥Á¸ïUÀ¼À£ÀÄß §¼À¸À¯ÁUÀÄvÀÛzÉ?

31) ºÁå¶AUï£À°è collision, collision resolution ªÀÄvÀÄÛ perfect hash
function UÀ¼ÉAzÀgÉãÀÄ?

32) qÉÃmÁ¨ÉÃ¸ï ¹ÌêÀiÁªÀ£ÀÄß «±Éèö¹.

33) SQL £À°è MAn¸Á°£À ªÀÄvÀÄÛ §ºÀÄ ¸Á®ÄUÀ¼À PÁAiÀÄðUÀ¼À ªÀåvÁå¸ÀUÀ¼À£ÀÄß
§gɬÄj.

34) MAC «¼Á¸ÀªÀ£ÀÄß «ªÀj¹.

41 (NS) -8-

¨sÁUÀ – D

V. AiÀiÁªÀÅzÁzÀgÀÆ £Á®ÄÌ ¥Àæ±ÉßUÀ½UÉ GvÀÛj¹. ¥ÀæwAiÉÆAzÀÄ ¥Àæ±ÉßUÉ 5 CAPÀUÀ¼ÀÄ.
(4 × 5 = 20)

35) ªÉÄzÉAiÀÄÄ AiÀiÁªÀ ¸ÉÊzÁÞAwPÀ PÀæªÀĪÀ£ÀÄß ¥Á°¸ÀÄvÀÛzÉ? ¥ÉÆæÃUÁæ«ÄAUï£À°è
ªÉÄzÉAiÀÄ «©ü£Àß §UÉAiÀÄ G¥ÀAiÉÆÃUÀUÀ¼À£ÀÄß «ªÀj¹.

36) Deque C£ÀÄß ªÁåSÁ夹. Deque EzÀgÀ PÁAiÀiÁðZÀgÀuÉUÀ¼À£ÀÄß «ªÀj¹.

37) ¥ÀnÖAiÀÄ°è ¤ÃrgÀĪÀ MAzÀÄ CA±ÀªÀ£ÀÄß ºÀÄqÀÄPÀ®Ä gÉÃTÃAiÀÄ ºÀÄqÀÄPÁl
vÀAvÀæzÀ PÀæªÀiÁªÀ½AiÀÄ£ÀÄß §gɬÄj.

38) ¸ÀA§AzsÀUÀ¼À qÉÃmÁ¨Éøï£À°è §¼À¸ÀĪÀ «©ü£Àß §UÉAiÀÄ QðUÀ¼À£ÀÄß
«ªÀj¹.

39) LAN §UÉÎ n¥Ààt §gɬÄj.

40) ªÉÄÊPÉÆæêÉêïUÀ¼À ªÀUÀðUÀÄtUÀ¼ÀÄ AiÀiÁªÀŪÀÅ?

41) ªÀiÁ¯ÉéÃgïUÀ¼À «gÀÄzÀÞ ¤AiÀÄAwæ¸ÀĪÀ PÉ®ªÀÅ ªÀiÁ¥À£ÀUÀ¼À£ÀÄß ¥ÀnÖ ªÀiÁr.

¨sÁUÀ – E

VI. AiÀiÁªÀÅzÁzÀgÀÆ JgÀqÀÄ ¥Àæ±ÉßUÀ½UÉ GvÀÛj¹. ¥ÀæwAiÉÆAzÀÄ ¥Àæ±ÉßUÉ 5 CAPÀUÀ¼ÀÄ.
(2 × 5 = 10)

42) PɼÀUÉ ¤ÃrgÀĪÀ CA±ÀUÀ¼À£ÀÄß C¼ÀªÀrPÉ «AUÀqÀuÉAiÀÄ ¥ÀzÀÞw §¼À¹
«AUÀr¹.
80, 60, 20, 40, 50, 10.

-9- 41 (NS)

43) MAzÀÄ vÀgÀUÀwAiÀÄ «zÁåyðUÀ¼À vÀÆPÀ (PÉ.f.AiÀÄ°è)
54, 41, 44, 48, 50, 46, 46
EªÀÅUÀ¼À£ÀÄß §¼À¹.
a) «ÄÃrAiÀÄ£ï
b) ªÉÆÃqï
c) ¥ÀæªÀiÁtÂvÀ «ZÀ®£ÀUÀ¼À£ÀÄß PÀAqÀÄ»r¬Äj.

44) PÉÆnÖgÀĪÀ zÀvÁÛA±ÀªÀ£ÀÄß DzsÀj¹ (a) ¬ÄAzÀ (e) ªÀgÉV£À ¥Àæ±ÉßUÀ½UÉ
SQL DeÉÕUÀ¼À£ÀÄß §gɬÄj. PÉÆõÀ×PÀ : EMPLOYEE

ID NAME DOB DEPARTMENT SALARY
1111 AAAA 01-08-1998 ACCOUNTS 156780
2222 BBBB 12-12-2000 HR 199950
1010 CCCC 23-06-2000 SALES 140000
5456 ZZZZ 01-01-2002 PRODUCTION 250000
3486 LLLL 08-08-1998 HR 200000

a) J¯Áè GzÉÆåÃVUÀ¼À ªÀiÁ»wAiÀÄ£ÀÄß CªÀgÀ SALARY AiÀÄ
CªÀgÉÆúÀt PÀæªÀÄzÀ°è ¥ÀæzÀ²ð¹.
b) total_income JA§ ºÉƸÀ PÀA§¸Á®£ÀÄß ¸ÉÃj¹.

c) total_income C£ÀÄß SALARY × 12 JAzÀÄ ¯ÉPÀ̪ÀiÁqÀ®Ä DeÉÕ.

d) ««zsÀ DEPARTMENT UÀ¼À ¸ÀASÉåAiÀÄ£ÀÄß Jt¹ ¥ÀæzÀ²ð¸À®Ä.
e) AiÀiÁªÀ GzÉÆåÃVAiÀÄ total_income 20 ®PÀë ªÉÄîànÖzÉ CªÀgÀ
«ªÀgÀUÀ¼À£ÀÄß GvÁࢸÀ®Ä.
———————

41 (NS) -10-

(English Version)

Instructions : 1. The question paper has five parts namely
A, B, C, D, E.

2. For Part–A questions, only first written answers will
be considered for valuation.

PART – A

Answer all the questions. Each question carries 1 mark. (20 × 1 = 20)
I. Select the correct answer from the choices given.

1) Given Q = N/D, if D = 0 and N = 100, which built-in exception occurs?
a) Zero Division Error b) Index Error
c) Value Error d) Syntax Error

2) The function which returns an integer that specifies the current position of
the file-object in the file is
a) seek b) load
c) tell d) dump

3) Assertion (A) : A stack is a linear data structure that stores the
elements in FIFO order.
Reason (R) : In stack a new element is added and removed from
one end only.
a) Both (A) and (R) are correct and (R) is the correct explanation of (A)
b) Both (A) and (R) are correct, and (R) is not the correct explanation
for (A)
c) (A) is true but (R) is false
d) (A) is false but (R) is true

-11- 41 (NS)

4) Which built-in function (method) is used to create an empty queue in
python?
a) enqueue( ) b) list( )
c) append( ) d) insert( )

5) In bubble sort while sorting in ascending order, which element reaches its
correct position after the first pass?

a) The smallest element b) The middle element
c) The largest element d) The second largest element

6) The term used to describe algorithm whose time complexity is n2, typically
caused by nested loops is

a) Linear time algorithm b) Exponential time algorithm
c) Quadratic time algorithm d) Constant time algorithm

7) The purpose of data constraint in database is

a) to ensure reliability b) to define size of databases
c) to specify storage format d) to speedup query

8) What does the order by clause do in SQL?
a) Sorts rows based on column values
b) Filters rows based on condition
c) Groups rows with similar values
d) Limits the number of rows returned

9) Which datatype is used to hold numbers with decimal points in MYSQL?

a) FLOAT b) DATE
c) INT d) INTEGER

41 (NS) -12-

10) The prompt that indicates MYSQL is ready to accept SQL statements is
a) >>> b) mysql>
c) cmd> d) db>

11) The largest example of WAN is

a) A university campus network

b) A home wifi network
c) Internet
d) Bluetooth

12) The network topology where data can be transmitted in only one direction
is

a) Star b) Ring
c) Mesh d) Bus

13) Example of full duplex communication mode is

a) Walkie-Talkie b) Fan
c) TV d) Mobile

14) The development of HTTP was led by

a) Charles Babbage b) Bjarne Stroutstrup
c) Roy Tomlinson d) Tim Berners Lee

15) The standalone programs that are capable of working on its own is

a) Worm b) Trojan horse
c) Ransomware d) Spyware

-13- 41 (NS)

II. Fill in the blanks by choosing the appropriate word/words from those given
in the brackets.

(Dump, Upper, Parsing, Redundancy, Distinct, Length)

16) Syntax errors are also known as _____________ errors.

17) To convert python objects for writing data to a binary file,
_____________ method is used.

18) _____________ means same data are duplicated in different places
(files).

19) _____________ clause is used along with select to avoid duplicate
values in an SQL query.

20) In SQL _____________ function returns the number of characters in the
specified string.

PART – B

III. Answer any four questions. Each question carries 2 marks. (4 × 2 = 8)

21) What is prefix and postfix expression?

22) Write a python function to insert a new element at the end of queue.

23) Mention any two applications of modified binary search.

41 (NS) -14-

24) Given the relation : Guardian, write the degree and cardinality of the
relation.

GUID GName Gphone

44444 Amit 5711492685

11111 Bhutia 3612967082

46644 Sujata 3801923168

10101 Himanshu 4726309212

25) Why is delete command used in SQL? Write its syntax.

26) What is the role of MODEM in computer network?

27) Name any two wired media.

PART – C

IV. Answer any four questions. Each question carries 3 marks. (4 × 3 = 12)

28) What is the purpose of raise statement? Write its syntax and example.

29) What is a file? Explain any two file opening modes in python.

30) Answer the following :

a) Define sorting.

b) What is swapping?

c) How many passes are made by selection sort to sort “n” elements?

-15- 41 (NS)

31) What is collision, collision resolution and perfect hash function in

hashing?

32) Describe database schema.

33) Differentiate between single and multi row function in SQL.

34) Explain MAC address.

PART – D

V. Answer any four questions. Each question carries 5 marks. (4 × 5 = 20)

35) What is the ordering principle of stack? Explain different applications of
stack in programming.

36) Define deque. Explain the operations on deque.

37) Write an algorithm to search an element in a list using linear search
technique.

38) Explain different types of keys in relational database.

39) Write note on LAN.

40) What are the properties of microwaves?

41) List some preventive measures against the malware.

41 (NS) -16-

PART – E

VI. Answer any two questions. Each question carries 5 marks. (2 × 5 = 10)

42) Write the process to sort the following elements using insertion sort
method :
80, 60, 20, 40, 50, 10.

43) The weights (in kg) of students in a class are :
54, 41, 44, 48, 50, 46, 46.
Use the given weights to find :
a) Median
b) Mode
c) Standard deviation.
44) Write SQL commands for questions (a) to (e) based on data given in the
EMPLOYEE table :
ID NAME DOB DEPARTMENT SALARY
1111 AAAA 01-08-1998 ACCOUNTS 156780
2222 BBBB 12-12-2000 HR 199950
1010 CCCC 23-06-2000 SALES 140000
5456 ZZZZ 01-01-2002 PRODUCTION 250000
3486 LLLL 08-08-1998 HR 200000

a) Display information of all the employees in descending order of their
SALARY.
b) Add a new column total_income.
c) Compute total_income as SALARY × 12.
d) Display the count of various DEPARTMENT.
e) Generate report of employees whose total_income is above
20 lakhs.

———————