AL/2022/20/T-I -1-

KOg;gjpg;GupikAilaJ / All Rights Reserved ]

mwpTWj;jy;fs;:
 vy;yh tpdhf;fSf;Fk; tpil vOJf.
 tpilj;jhspy; jug;gl;Ls;s ,lj;jpy; ckJ Rl;nlz;iz vOJf.
 tpilj;jhspd; kWgf;fj;jpy; jug;gl;Ls;s mwpTWj;jy;fisf; ftdkhf thrpj;Jg; gpd;gw;Wf.
 1 njhlf;fk; 50 tiuAs;s tpdhf;fs; xt;nthd;Wf;Fk; (1),(2),(3),(4),(5) vd ,yf;fkplg;gl;l
tpilfspy; rupahd my;yJ kpfg; nghUj;jkhd tpiliaj; njupe;njLj;J> mjidf; Fwpj;J
epw;Fk; ,yf;fj;ijj; jug;gl;Ls;s mwpTWj;jy;fSf;F mika tpilj;jhspy; Gs;sb (x) ,Ltjd;
%yk; fhl;Lf.
 fzpg;ghd;fisg; gad;gLj;Jtjw;F ,lkspf;fg;glkhl;lhJ.

1. “NtWgl;l myFfs; juitf; ifahsf;$ba Ntfj;jpy; cs;s NtWghl;il <Lnra;tjw;fhf

juitr; Nrkpf;fg; gad;gLj;jg;gLk; juT Nrkpg;gfk; ……………………. vd miof;fg;gLk;”.
,ilntspapid epug;Gtjw;Fg; nghUj;jkhdJ gpd;tUtdtw;Ws; vJ?
(1) gJf;F epidtfk; (cache memory) (2) epidtfk; (memory)
(3) nka;epfu; epidtfk; (virtual memory) (4) epidtf Kfhikj;Jt myF (MMU)
(5) ,ilafk; (buffer)

2. gpd;tUk; $w;Wf;fisf; fUJf.

A - mwpTWj;jy;fisf; Fwpatpo;j;jy; (decoding)
B - tUtpistpidg; gupkhWjy; (transferring)
C - mwpTWj;jy;fisf; nfhzu;jy; (fetching)
NkYs;stw;Ws; vJ vit nfhzu;-epiwNtw;W (fetch-execute) rf;fuj;jpdJ gbKiwfshFk;?
(1) A khj;jpuk; (2) B khj;jpuk; (3) A,B khj;jpuk; (4) A,C khj;jpuk; (5) B,C khj;jpuk;

3. gpd;tUk; $w;Wf;fisf; fUJf.

A - Nfhg;Gf;fis ,izaj;jpD}lhf vq;fpUe;Jk; mZf Kbjy;
B - Fiwe;j nkd;nghUs; nryT
C - jdpg;gl;l juT / ghJfhg;G gpur;rpidfs;
Nkw;$wpatw;wpy; vJ / vit Kfpy; fzpdpg;gLj;jypdJ (cloud computing) ed;ik (fshff;)
fUjg;gLfpd;wd?
(1) A khj;jpuk; (2) B khj;jpuk; (3) A,B khj;jpuk; (4) A,C khj;jpuk; (5) B,C khj;jpuk;

4. td;nghUs; rhjdq;fSf;F xU nkd;nghUs; ,ilKfj;ij toq;Ffpd;w $W

gpd;tUtdtw;Ws; vJ?
(1) rhjdr;nrYj;jp (2) BIOS (3) CMOS (4) IRQ (5) EPROM

[See page 2
AL/2022/20/T-I -2-

5. Ez;Kiwtopahf;fpapdJ vz;fzpj jUf;f myF nfhz;bUf;fpd;w mjptpiuthd fsQ;rpa

myF …………………………. MFk;.
(1) gJf;F epidtfk; (cache memory) (2) td;tl;L (3) fl;Lg;ghl;L myF
(4) fhe;j tl;L (magnetic disk) (5) gjpap (register)

6. X = 101000102 kw;Wk; Y = 111010102 vdpd;> X NOR Y ,d; ngWkjp ahJ?

(1) 000101012 (2) 111000102 (3) 111010102 (4) 001010102 (5) 100010102

7. gpd;tUk; fhu;dh tupg;glj;jpidf; fUJf.

C
AB 0 1 mUNfAs;s fhu;dh tupg;glj;jpdhy; jug;gLfpd;w G+ypad;
1 0 Nfhit gpd;tUtdtw;Ws; vJ?
00
(1) 𝐴𝐶 + 𝐴̅𝐵̅ (2) 𝐴𝐵 + 𝐵𝐶 + 𝐴̅𝐵̅𝐶̅
0 1
01 (3) 𝐴𝐵 + 𝐴̅𝐵𝐶 (4) 𝐵𝐶 + 𝐴𝐵 + 𝐴𝐶̅
11 1 1 (5) 𝐵𝐶̅ + 𝐴̅𝐶

10 0 0

8. gpd;tUk; jUf;fr; Rw;wpidf; fUJf.

A
B
C
Z

NkYs;s jUf;fr;Rw;wpdJ tUtpisT Z ,w;Fr; rktYTila tUtpisTfisj; jUfpd;w

jUf;fr; Rw;Wf;fs; gpd;tUtdtw;Ws; vJ / vit?
I II
B
C A

Z C
A Z
B

III

A
B
Z
C

(1) I khj;jpuk; (2) I,II khj;jpuk; (3) I,III khj;jpuk; (4) II,III khj;jpuk; (5) I,II,III midj;Jk;

[See page 3
AL/2022/20/T-I -3-

9. (+1810) kw;Wk; (-1210) Mfpatw;wpdJ ,uz;bdJ epug;gpfs; KiwNa.

(1) 100110002 , 000010112 (2) 111110002 , 011010112 (3) 111010002 , 001010112
(4) 111010002 , 000100112 (5) 000100102 , 111101002

10. G+ypad; Nfhit 𝐴̅𝐵𝐶 + 𝐴𝐵̅𝐶 + 𝐴𝐵𝐶̅ + 𝐴𝐵𝐶 ,dJ RUf;fg;gl;l tpisT ahJ?
(1) 𝐴𝐵 + 𝐵̅𝐶 + 𝐴𝐶̅ (2) 𝐴𝐵 + 𝐵𝐶 + 𝐴𝐶 (3) 𝐴𝐵̅ + 𝐵𝐶 + 𝐴𝐶
(4) 𝐴𝐵 + 𝐵̅𝐶̅ + 𝐴𝐶 (5) 𝐴̅𝐵 + 𝐵̅𝐶 + 𝐴̅𝐶̅

11. gpd;tUtdtw;Ws; gzpnray; Kiwikapd; Kiwtopf; fl;Lg;ghl;Lj; njhFjp (PCB)

nghJtpy; nfhz;bUf;fhj jfty; vJ?
(1) Kiwtop vz; (process number)
(2) td;tl;bdJ nfhs;ssT (capacity of hard disk)
(3) Kiwtop ml;ltizg;gLj;jy; epiyik (process scheduling state)
(4) nra;epuy; vz;zp (program counter)
(5) Kiwtop epiyik (process state)

12. gzpnray; KiwikahdJ Nfhg;Gf;fSf;fhd ,lxJf;fL P fis (space allocation)

Nkw;nfhs;tjw;Fg; gy;NtW topKiwfisg; gad;gLj;Jfpd;wJ.
mtw;Ws; “……………………………….. MdJ Nfhg;G cUthf;fg;gLfpd;w Neuj;jpy;
Rl;bfspd; ml;ltizapid (FwpaPl;L) cUthf;Ffpd;wJ”.
,ilntspapid epug;Gtjw;Fg; nghUj;jkhdJ gpd;tUtdtw;Ws; vJ?
(1) ,izg;G (linked) xJf;fL P
(2) epidtf xJf;fL P
(3) njhlu;r;rpahd (contiguous) xJf;fL
P
(4) Rl;L (indexed) xJf;fLP
(5) td;tl;L xJf;fL P

13. gzpnray; KiwikahdJ xt;nthU Kiwtopf;Fk; xU gf;f ml;ltiziag;

guhkupf;fpd;wJ mj;Jld; nka;epfu; gf;fj;jpw;fhd Eiotpidf; (entry) fz;l ; wpa gf;f
ml;ltizapy; xU Rl;lhf (index) nka;epfu; gf;f vz; gad;gLj;jg;gLfpd;wJ.
gpd;tUtdtw;wpy; vJ gf;f ml;ltiz EiotpDs; Nru;ff ; g;gLtjpy;iy?
(1) rl;lf vz; (frame number)
(2) typjhd kw;Wk; typjw;w gpw;W (valid and invalid bit)
(3) gf;f jtW (page fault)
(4) Nkw;Nfhsplg;gl;l gpw;W (referenced bit)
(5) khw;wpaikf;fg;gl;l gpw;W (modified bit)

14. juTj; njhlu;ghly; Kiwikfspy; OSI khjpupapy; ve;j mLf;fpy; (layer) topg;gLj;jp (router)
nraw;gLfpd;wJ?
(1) ngsjpf mLf;F (physical layer) (2) gpuNahf mLf;F (application layer)
(3) jutpizg;G mLf;F (data link layer) (4) tiyaikg;G mLf;F (network layer)
(5) epfo;j;Jif mLf;F (presentation layer)

15. 192.16.5.133/29 vDk; IP Kftupapidf; fUJf. tiyaikg;G kw;Wk; tpUe;Njhk;Gdu;

Mfpatw;iw KiwNa ,dq;fhz;gjw;F vj;jid gpw;Wf;fs; Njitg;gLfpd;wd?
(1) 29, 3 (2) 28, 3 (3) 30, 2 (4) 28, 4 (5) 29, 4

[See page 4
AL/2022/20/T-I -4-

16. fzpdp tiyaikg;gpy;> TCP njhlu;gpy; gpd;tUtdtw;Ws; rupahdJ vJ /vit?

A - Fiwe;j Nkd;jiy (less overhead)
B - ek;gfkhd juTg; gupkhw;wk;
C - ,izg;G mbg;gilapyhdJ
D - cj;juthj tpepNahfk;
(1) A khj;jpuk; (2) B,C khj;jpuk; (3) A,B khj;jpuk; (4) A,D khj;jpuk; (5) B,C,D khj;jpuk;

17. juTj; njhlu;ghly; kw;Wk; fzpdp tiyaikg;gpy; gad;gLj;jg;gLfpd;w Clfq;fSs;>

gpd;tUk; vf;FOthdJ topg;gLj;jg;glhj Clfq;fis (unguided media) khj;jpuk;
nfhz;Ls;sJ?
(1) nre;epwf;fo
P ; fjpu;> ehu; xspapay; tlk;> thndhyp miy
(2) Xur;R tlk;> Ez;ziy> thndhyp miy
(3) nre;epwf;fo
P ; fjpu;> Ez;ziy> KWf;fpiz tlk;
(4) nre;epwf;fo
P ; fjpu;> Ez;ziy> thndhyp miy
(5) KWf;fpiz tlk;> ehu; xspapay; tlk;> Xur;R tlk;

18. kiwFwpahf;fj;jpw;Fk; (encryption), kiwFwp ePf;fYf;Fk; (decryption) xNu rhtpapidg;

gad;gLj;jp Nkw;nfhs;sg;gLfpd;w kiwFwpahf;fy; cj;jp miof;fg;gLtJ.
(1) rkr;rPuhd kiwFwpahf;fk; (symmetric encryption)
(2) rkr;rPuw;w kiwFwpahf;fk; (asymmetric encryption)
(3) nghJr;rhtp kiwFwpahf;fk; (public key encryption)
(4) tpNrlrhtp kiwFwpahf;fk; (special key encryption)
(5) fyg;G kiwFwpahf;fk; (hybrid encryption)

19. fzpdp gpwo;nghUs; gw;wpa gpd;tUk; $w;Wf;fisf; fUJf.

A - fzpdp er;Repuy; (virus) jd;id kPsgpujpnra;tJld;> xU fzpdpapypUe;J kw;nwhU
fzpdpapy; guTfpd;wJ.
B - Nuh[d; Fjpiu (trojan horse) fzpdpapy; epWtgLtjw;F Kd;G gadUf;F gaDs;sjhf
Njhd;Wk; mNjNtis fzpdpapy; epWtg;gl;lJk; gad;kpf;f jfty;fisj; jpULfpd;wJ
C - fzpdp GO (worm) jd;id kPsgpujpnra;tJld;> fzpdp tiyaikg;gpidg; gad;gLj;jp
xU fzpdpapypUe;J kw;iwa fzpdpfSf;F gadupd; jiyaPL ,y;yhky; guTfpd;wJ
,tw;Ws; rupahd $w;Wf;fs; vJ / vit?
(1) A khj;jpuk; (2) B khj;jpuk; (3) C khj;jpuk; (4) B,C khj;jpuk; (5) A,B,C midj;Jk;

20. nkd;nghUs; Kiwtop khjpupaq;fs; njhlu;ghd gpd;tUk; $w;Wf;fisf; fUJf.

• nraw;$w;W myFfs; (functional modules) %yKd;khjpupfshf (prototypes) rkhe;jukhf
mgptpUj;jp nra;ag;gl;L> mtw;iw xUq;fpizg;gjd; %yk; Jupj tpepNahfj;ij
nraw;gLj;jp mgptpUj;jp nra;ag;gLfpd;wJ.
• gadu; Njitg;ghLfs; ed;F Gupe;J nfhs;sg;gLk;NghJ> mjd; KiwtopahdJ xU
mgptpUj;jpf; FOtpid kpff; FWfpa fhyj;jpw;Fs; 'KOikahfr; nraw;gLk;
nkd;nghUis' cUthf;f cjTfpd;wJ.
gpd;tUk; ve;j nkd;nghUs; khjpupak; NkYs;s $w;Wf;fisj; jpUg;jp nra;fpd;wJ?
(1) ePu;tPor
; ;rp khjpupak;
(2) Jupj gpuNahf mgptpUj;jp (RAD) khjpupak;
(3) RUsp (spiral) khjpupak;
(4) nghUs; Nehf;F (object-oriented) khjpupak;
(5) RWRWg;ghd Kiwtop (agile process) khjpupak;
[See page 5
AL/2022/20/T-I -5-

21. re;ijapy; nfhs;tdT nra;af;$ba nkd;nghUs; (COTS) gw;wpa gpd;tUk; $w;Wf;fspy;

rupahdit vJ / vit?
A - mit Fwpg;gpl;l gadu;fspd; Njitfis epiwTnra;tjw;nfd mgptpUj;jp
nra;ag;gl;lit MFk;
B - jdpg;gadhf;fg;gl;l (customized) nghjpfSld; xg;gpLk; NghJ mtw;wpd; ngUk;ghyhd
trjpfisg; gadu;fs; gad;gLj;Jtu;
C - mit jdpg;gadhf;fg;gl;l nghjpfSld;; xg;gpLk;NghJ nryT Fiwe;jit
(1) A khj;jpuk; (2) B khj;jpuk; (3) C khj;jpuk; (4) A,B khj;jpuk; (5) A,B,C midj;Jk

22. gpd;tUk; ml;ltizapidf; fUJf.

jfty; Kiwikfs; tptuzk;

(i) epiwNtw;W cjT (a) rpf;fyhd gpur;rpidfSf;Fupa jPu;Tfis

Kiwik mwptpidg; gad;gLj;jp jUf;f uPjpapy; rpe;jpj;J
toq;Ffpd;w KiwikahFk;
(ii) jPu;khd cjT (b) juT kw;Wk; El;gkhd gFg;gha;T khjpupfis
Kiwik xUq;fpizf;Fk; my;yJ epu;thfkl;lg;
gadu;fSf;Fj; juT gFg;gha;T fUtpfis xU
mikg;gpd;> Fiw fl;likf;fg;gl;l (semi-structured)
kw;Wk; fl;likf;fg;glhj (unstructured) jPu;khdk;
vLf;Fk; xU jfty; Kiwik
(iii) ty;Ydu; Kiwik (c) xU epWtdj;jpd; %Nyhgha kl;lgadu;fSf;F
Nkk;gl;l tiutpay; kw;Wk; njhlu;ghly; %yk;
fl;likg;gw;w (unstructured) jPu;khdnkLj;jypw;F
cjTfpd;w jfty; KiwikahFk;

NkYs;sit njhlu;gpy; rupahdJ gpd;tUtdtw;Ws; vJ?

(1) (i) → (a), (ii) → (b), (iii) → (c) (2) (i) → (b), (ii) → (a), (iii) → (c)
(3) (i) → (b), (ii) → (c), (iii) → (a) (4) (i) → (a), (ii) → (c), (iii) → (b)
(5) (i) → (c), (ii) → (b), (iii) → (a)

23. gpd;tUk; $w;Wf;fisf; fUJf.

A - xU Gj;jfj;jpw;F Kd;gjpT nra;Ak; NghJ fzpdpapd; gjpyspg;G Neuk;; Ntfkhf ,Uf;f
Ntz;Lk; (c-k;. 5 nrf;fd;fSf;F Fiwthf)
B - Kiwik E}yfmq;fj;jtu;fspdJ juTfSf;F ghJfhg;ig toq;ff; $bajhf ,Uj;jy;
C - E}yf mq;fj;jtu;fs; Gj;jfq;fspd; fpilf;Fk; jd;ikiaj; Njlf; $bajhf ,Uj;jy;
NkYs;stw;Ws; Xu; njhluwh E}yf Kiwikapd; nray;rhu; (functional) Njitg;ghLfshf
,Uf;ff;$bait vj /vit?
(1) A khj;jpuk; (2) B khj;jpuk; (3) C khj;jpuk; (4) B,C khj;jpuk; (5) A,B,C midj;Jk;

24. juTg;gha;r;ry; tupg;glk; (DFD) gw;wpa $w;Wf;fisf; fUJf.

A - Kiwtop khjpupaj;jpid (process model) mJ gpujpepjpj;Jtk; nra;fpd;wJ
B - ,uz;lhk; kl;l tupg;glj;jpidg; ngWtjw;F Kjyhk; kl;l DFD NkYk;
gpupf;fg;gLfpd;wJ (decomposing)
C - Kjyhk; kl;l DFD ,y; ntspg;Gw cs;nghUs;fs; juTfSf;fhd %yq;fshff;
fUjg;glKbAk;
NkYs;stw;Ws; rupahdit vJ /vit?
(1) A khj;jpuk; (2) B khj;jpuk; (3) A,B khj;jpuk; (4) B,C khj;jpuk; (5) A,B,C midj;Jk;

[See page 6
 -6-
AL/2022/20/T-I

tpdhf;fs; (25) kw;Wk; (26) Mfpatw;wpw;F tpilaspg;gjw;F gpd;tUk; epiyikapidf; fUJf.

kUe;jff;fk;gdpfs; (pharmaceutical companies) kUe;Jfis (drugs) cw;gj;jp nra;fpd;wd.

xt;nthU fk;gdpfspd; kUe;Jfs; mtw;wpdJ tpahghug; ngaupdhy; jdpj;Jtkhf
milahsg;gLj;jg;gLfpd;wd. xt;nthU kUe;jfKk; (pharmacy) gy kUe;Jfis tpw;gid
nra;fpd;wd. xt;nthU kUe;Jk; mjd; tpiyfisf; (price) nfhz;Ls;sd. xU kUe;jhdJ gy
kUe;jfq;fspy; xU epiyj;j (fixed) tpiyapy; tpw;fg;gl KbAk;. kUe;jff;fk;gdpfs; gy
kUe;jfq;fSld; xg;ge;jj;jpidf; (contract) nfhz;Ls;sJ. mNjNtis> xU kUe;jfk; gy
kUe;jff;fk;gdpfSld; xg;ge;jj;jpidf; nfhz;Ls;sJ.

25. jug;gl;l epiyikapd; mbg;gilapy; tpiy vt;thW Fwpf;fg;gly; Ntz;Lk;?

(1) kUe;jfj;jpdJ ,dJ gz;ghf
(2) kUe;jfk; kw;Wk; kUe;J Mfpatw;Wf;fpilapyhd njhlu;GilikapdJ gz;ghf
(3) kUe;jfk; kw;Wk; kUe;jff;fk;gdpfs; Mfpatw;Wf;fpilapyhd njhlu;GilikapdJ
gz;ghf
(4) kUe;jpdJ gz;ghf
(5) kUe;jff;fk;gdpfspdJ gz;ghf

26. kUe;jfj;jpw;F kUe;jfk; Xt;nthU kUe;jpdJk; tpiy khWgLkhapd;> tpiy vt;thW

Fwpf;fg;gly; Ntz;Lk;?
(1) kUe;jpdJ gz;ghf
(2) kUe;jfk; kw;Wk; kUe;J Mfpatw;Wf;fpilapyhd njhlu;GilikapdJ gz;ghf
(3) kUe;jfk; kw;Wk; kUe;jff;fk;gdpfs; Mfpatw;Wf;fpilapyhd njhlu;GilikapdJ
gz;ghf
(4) kUe;jfj;jpdJ gz;ghf
(5) kUe;jff;fk;gdpfspdJ gz;ghf

27. gpd;tUk; SQL $w;Wf;fisf; fUJf (midj;J ml;ltizfSk;> Gyq;fSk;

jug;gl;Ls;sjhff; nfhs;f).
A - SELECT * FROM Customers WHERE Country IN ('Sri Lanka', 'Australia', 'India');
B - SELECT * FROM Products WHERE Price BETWEEN 50 AND 100;
C - SELECT COUNT(CustomerID), Country FROM Customers GROUP BY Country;
NkYs;stw;Ws; njhlupay; uPjpapy; (syntactically) rupahdJ vJ /vit?
(1) A khj;jpuk; (2) B khj;jpuk; (3) C khj;jpuk; (4) A,B khj;jpuk; (5) A,B,C midj;Jk;

28. gpd;tUk; E-R tiuglj;ijf; fUJf.

Order places Customer

xU thbf;ifahsu; xd;wpw;F Nkw;gl;l fl;lisfisAk;> xU fl;lis Mff;$baJ xU

thbf;ifahsupdhy; ,lg;gLnkdpd;> gpd;tUtdtw;Ws; vJ ,U cs;nghUs;fSf;Fk;
,ilNaahd njhlu;Gilikapidj; jpwk;gl tpgupf;fpd;wJ?

(1) 1: N (2) M: N (3) 1: 1 (4) 0: M (5) 0: 1

[See page 7
AL/2022/20/T-I
-7-

29. Inventory (PartNo, Warehouse, Location, Quantity, Weight, Colour) vDk; ml;ltizapidf;
fUJf.
Weight, Colour Mfpait PartNo ,y; jq;fpAs;sd
Quantity MdJ (PartNo, Warehouse) ,y; jq;fpAs;sJ
Location MdJ Warehouse ,y; jq;fpAs;sJ
ml;ltiz njhlu;gpy; gpd;tUk; $w;Wf;fSs; rupahdJ vJ?
(1) mJ 0NF ,y; cs;sJ (2) mJ 1NF ,y; cs;sJ (3) mJ 2NF ,y; cs;sJ
(4) mJ 3NF ,y; cs;sJ (5) mJ BCNF ,y; cs;sJ

30. gpd;tUk; tptuzj;ijf; fUJf.

• thbf;ifahsu; (client) fl;lisfis (order) Nkw;nfhs;fpd;wdu;.
• xU fl;lis xU thbf;ifahsUf;fhdjhFk;.
• xU fl;lis xU tiff;fhdjhFk; (category).
thbf;ifahsu; njhlu;ghd tpguq;fs; Clients vDk; ml;ltizapy; khjpupj; juTld; fPNo
jug;gLfpd;wd.

clientno shop city contact orderno category value

C0034 Akbar Shop Colombo Hakeem O06325 Personal Items 14325.00
C0045 Shanthi Shop Galle Perera O83763 Personal Items 18367.00
C0534 Xtreme Shop Kandy Nastriya O26498 Ornamental 20873.00
C0625 S.J.S Shop Matara Robbin O82743 Gift Items 89738.40
C1826 Lalitha Jewels Jaffna Raja O82634 Ornaments 95000.00
C1826 Lalitha Jewels Jaffna Raja O72634 Personal Items 28273.93

gpd;tUk; vj; njhlu;Gfs; 3NF tbtpy; NkYs;s mikg;Gtbtpidj; (schema) jUfpd;wd?

A - Client (clientno, shop, city, contact)
B - Order (clientno, orderno, category, value)
C - Order (orderno, value)
D - ClientOrder (clientno, orderno, value)
(1) A khj;jpuk; (2) A, B khj;jpuk; (3) C khj;jpuk; (4) B, C khj;jpuk; (5) A, B, D khj;jpuk;

31. cs;nghUs;-njhlu;Gilik (ER) tupg;glj;jpy; gad;gLj;jg;gLfpd;w gz;GfSf;fhd gpd;tUk;

%d;W FwpaPLfisAk; fUJf.

① ② ③

EmpID PhoneNo Age

①, ② kw;Wk; ③ Mfpa gz;Gfspd; tiffs; KiwNa.

(1) tUtpj;j (derived) gz;G> milahsg;gLj;Jk; gz;G> gy;ngWkjpg; gz;G
(2) gy;ngWkjpg; gz;G> milahsg;gLj;Jk; gz;G> tUtpj;j gz;G
(3) milahsg;gLj;Jk; gz;G> gy;ngWkjpg; gz;G> tUtpj;j gz;G
(4) milahsg;gLj;Jk; gz;G> tUtpj;j gz;G> gy;ngWkjpg; gz;G
(5) gy;ngWkjpg; gz;G> tUtpj;j gz;G> milahsg;gLj;Jk; gz;G

[See page 8
AL/2022/20/T-I -8-

32. gpd;tUk; igj;jhd; nra;epuiyf; fUJf.

x = "awesome"
def myfunc():
global x
x = "fantastic"
print ("Python is " + x)
myfunc()
print ("Python is " + x)

,r; nra;epuy; epiwNtw;wg;gLk;NghJ vd;d tUtpisT fpilf;fg;ngWk;?

(1) (2) (3)

Python is awesome Python is awesome Python is fantastic
Python is awesome Python is fantastic Python is awesome

(4) (5) tOr;nra;jpapidf; fhz;gpf;Fk;

Python is fantastic
Python is fantastic

33. gpd;tUk; igj;jhd; nra;epuiyf; fUJf.

S = 'The way to get started is to quit talking and begin doing'

ch = "e"
c=0
w=0
for i in range(len(S)):
if c % 2 == 0 and S[i] == ch:
w += 1
c=1
elif S[i] == " ":
c=0
print(w)

,r; nra;epuy; epiwNtw;wg;gLk;NghJ vd;d tUtpisT fpilf;fg;ngWk;?

(1) 4 (2) 12 (3) e (4) 6 (5) get

34. gpd;tUk; igj;jhd; $w;Wf;fisf; fUJf.

A - a, b = (2, [3, 4])

B - s = set()
C - c = 2, 3, 4
D - a = b, c = (1, [2, 3])

NkYs;stw;Ws; typjhd igj;jhd; $w;Wf;fs; vJ / vit?

(1) A khj;jpuk; (2) B khj;jpuk; (3) A,C khj;jpuk; (4) A,B,C khj;jpuk; (5) A,B,C,D midj;Jk;

[See page 9
AL/2022/20/T-I -9-

35. gpd;tUk; igj;jhd; nra;epuypy;> gadu; 11 ,id cs;sPL nra;jhy; ngwg;gLfpd;w

tUtpisT ahJ?

res = 'A'
n =int(input())
if n > 5:
res = 'P'
if n > 8:
res = 'Q'
else:
res = 'R'
if n > 10:
res = 'S'
else:
res='Z'
print(res)

(1) A (2) P (3) Q (4) Z (5) S

36. print(5 | 2 ^ 3 >> 2) vDk; igj;jhd; $w;W epiwNtw;wg;gl;ljd; gpd;du;> tUtpisT ahjhf
,Uf;Fk;?
(1) 2 (2) 7 (3) 3 (4) 1 (5) 0

fPNo gha;r;rw;Nfhl;Lg;glj;jpdhy; jug;gLfpd;w newpKiwapidg; gad;gLj;jp tpdhf;fs; (37),

(38) Mfpatw;wpw;F tpilaspf;Ff.

Start

Enter an integer value, N

i=1

Is No
i <= N ? Stop

Yes
Is No
N mod i =0 ?

Yes

Print i

i=i+1

[See page 10
AL/2022/20/T-I
-10-

37. NkNy jug;gLfpd;w gha;r;rw;Nfhl;Lg;glk; gw;wpa gpd;tUk; $w;Wf;fspy; rupahdit vJ

/vit?
A - N ,w;F Xu; kiwg;ngWkjp toq;fg;gLk;NghJ Xu; tUtpistpidf; fhl;rpg;gLj;Jk;
B - N ,w;F Xu; Neu; KOvz; toq;fg;gLk;NghJ cldbahf epw;fpd;wJ
C - N ,w;F ngWkjp 6 toq;fg;gLk;NghJ tUtpisthf 1 2 3 6 fhl;rpg;gLj;jg;gLfpd;wJ
(1) A khj;jpuk; (2) B khj;jpuk; (3) C khj;jpuk; (4) A,B khj;jpuk; (5) A,B,C midj;Jk;

38. NkNy (37) ,y; jug;gl;l newpKiwf;F rktYTila igj;jhd; FwpKiw

gpd;tUtdtw;Ws; vJ /vit?
I II III
i=1 i=1 n = int(input())
n = int(input()) n = int(input()) for i in range (N):
while i <= n: while True: if n % i == 0:
if n % i == 0: if n % i == 0: print(i)
print(i) print(i)
i=i+1 i=i+1
if i > N: break

(1) I khj;jpuk; (2) II khj;jpuk; (3) III khj;jpuk; (4) I,II khj;jpuk; (5) I,II,III midj;Jk;

39. gpd;tUk; igj;jhd; nra;epuYf;F cs;sPlhf 5 toq;fg;gl;lhy;> fpilf;fg;ngWfpd;w

tUtpisT ahjhf ,Uf;Fk;?

a = int(input())
n1, n2 = 0, 1
count = 0
while count < a:
print(n1,end=' ')
n = n1 + n2
n1 = n2
n2 = n
count += 1

(1) 1 2 3 4 5 (2) 0 1 2 3 4 (3) 0 1 1 2 3

(4) 5 (5) 0 1 2 3 4

40. fzpdpr; nra;epuyhf;fk; gw;wpa gpd;tUk; $w;Wf;fisf; fUJf.

A - igj;jhd; Xu; nghUs;-Nehf;f (object-oriented) nra;epuyhf;f nkhopahFk;
B - Kjyhk; kw;Wk; ,uz;lhk; jiyKiwr; nra;epuyhf;f nkhopfs; xd;whf “cau;kl;l
nra;epuyhf;f nkhopfs;” vd miof;fg;gLfpd;wd
C - njhFg;gp xU Neuj;jpy; xU mwpTWj;jy; vd;wthW %yf;FwpKiwapid ,ae;jpuf;
FwpKiwf;F nkhopkhw;wp> epiwNtw;Wfpd;wJ
NkYs;stw;Ws; rupahdit vJ /vit?
(1) A khj;jpuk; (2) B khj;jpuk; (3) C khj;jpuk; (4) A,B khj;jpuk; (5) A,B,C midj;Jk;

[See page 11
AL/2022/20/T-I -11-

41. tiyg;gf;fk; xd;wpy; xypj;Jz;L (audio clip) xd;wpidr; nrUFtjw;Fg; gad;gLj;jg;gLfpd;w

HTML FwpKiwf;$W gpd;tUtdtw;Ws; vJ?
(1) <play controls> <source src=”song.mp3” type=”audio/mp3”> </play>
(2) <audio controls> <source src=”song.mp3” type=”audio/mp3”> </audio>
(3) <video controls> <source src=”song.mp3” sound=”audio/mp3”> </video>
(4) <run controls> <source src=”song.mp3” type=”audio/mp3”> </run>
(5) <sound controls> <source src=”song.mp3” type=”audio/mp3”> </sound>

42. tiyg;gf;fk; xd;wpy; Nfhl;by; rl;lfk; (inline frame) xd;wpidr; nrUFtjw;Fg;

gad;gLj;jg;gLfpd;w HTML FwpKiw gpd;tUtdtw;Ws; vJ?
(1) <inlineframe href="demo.html" height="200" width="300" title="display"></inlineframe>
(2) <frameset src="demo.html" height="200" width="300" title="display"></frameset>
(3) <frame src="demo.html" height="200" width="300" title="display"></frame>
(4) <iframe src="demo.html" height="200" width="300" title="display"></iframe>
(5) <frames href="demo.html" height="200" width="300" title="display"></frames>

43. CSS ,y; ntspg;Gw ghzpj;jhspidf; Fwpg;gpLtJ gpd;tUtdtw;Ws; vJ?

(1) <link src = "stylesheet" type = "text/css" href = "mainstyle.css">
(2) <link rel = "stylesheet" type = "text/css" href = "mainstyle.css">
(3) <style src = "mainstyle.css">
(4) <stylesheet> mainstyle.css </stylesheet>
(5) <link url = "stylesheet" type = "text/css" href = "mainstyle.css">

44. gpd;tUk; CSS FwpKiwf;$wpidf; fUJf.

<html>
<head>
<style>
*{
text-align: center;
color: blue;
}
</style>
</head>
<body>
<h1 style="color:red;"> CSS </h1>
<p style="color:green;"> Style </p>
<p id="para1"> Selector </p>
<p style="color:yellow;"> Paragraph </p>
</body>
</html>
jug;gl;l CSS FwpKiw njhlu;gpy; rupahd $w;W gpd;tUtdtw;Ws; vJ?
(1) midj;J ghlq;fSk; ePy epwkhff; fhl;rpaspf;Fk;
(2) midj;J ghlq;fSk; rptg;G epwkhff; fhl;rpaspf;Fk;
(3) midj;J ghlq;fSk; gr;ir epwkhff; fhl;rpaspf;Fk;
(4) midj;J ghlq;fSk; kQ;rs; epwkhff; fhl;rpaspf;Fk;
(5) ghlq;fs; CSS rptg;G epwkhfTk;> Style gr;ir epwkhfTk;> Selector ePy epwkhfTk;>
Paragraph kQ;rs; epwkhfTk; fhl;rpaspf;Fk;
[See page 12
AL/2022/20/T-I
-12-

45. PHP GET kw;Wk; POST Ntz;Liffs; njhlu;ghd gpd;tUk; $w;Wf;fspy; gpioahdJ vJ?
(1) GET Ntz;Lif (request) KiwAld; Xu; gbtj;jpypUe;J (form) mDg;gg;gLfpd;w
jftyhdJ URL ,y; fhl;rpg;gLj;jg;gLfpd;wJ
(2) GET Ntz;LifahdJ mDg;gg;gLfpd;w jftypdJ mstpy; tiuaiwapidf; (limits)
nfhz;Ls;sJ
(3) POST Ntz;Liffs; gJf;fg;gl (cached) Kbahjit
(4) GET Ntz;Liffs; tiy NkNyhb tuyhw;wpy; (web browser history)
itj;jpUf;fg;gLfpd;wd
(5) POST Ntz;Liffs; Gj;jfmilahskplg;gl (bookmarked) KbAk;

46. gpd;tUk; PHP script ,idf; fUJf.

<?php
$cars = array("Volvo", "BMW", "Toyota");
$arrlength = count($cars);
for($x = 0; $x < $arrlength-1; $x++)
{
echo $cars[$x]." ";
}
?>
NkYs;s PHP script epiwNtw;wg;gLk;NghJ tiyNkNyhbapd;kPJ ngwg;gLfpd;w tUtpisT
ahjhf ,Uf;Fk;?

(1) Volvo BMW Toyota (2) Toyota BMW Volvo (3) Volvo BMW
(4) BMW Volvo (5) 3

47. ,yj;jpudpay; tu;j;jf gpuNahfq;fspy; gad;gLj;jg;gLk; tzpff;$il (shopping cart)

nkd;nghUisg; gw;wpa gpd;tUk; $w;Wf;fSs; vJ / vit rupahdit?
A - ,J thbf;ifahsu;fSf;F nghUl;fisj; Nju;e;njLj;J gzk; nrYj;j cjTfpd;wJ
B - ,J xU nghUl;fl;lis Kfhikj;Jtf; fUtpahfg; gad;gLj;jg;gl KbAk;
C - ,J tpw;gid njhif> tpw;gid tup> tpiyf;fopT Nghd;wtw;iwj; jd;dpaf;fkhff;
fzf;fpLfpd;wJ
NkYs;s $w;Wf;fSs; rupahdit vJ / vit?
(1) B khj;jpuk; (2) C khj;jpuk; (3) A,B khj;jpuk; (4) B,C khj;jpuk; (5) A,B,C midj;Jk;

48. Kftu; njhopDl;gtpay; (agent technology) njhlu;ghd gpd;tUk; $w;Wf;fisf; fUJf.

A - nkd;nghUs; Kftu; vd;gJ Xu; fzpdp nra;epuyhFk;> mJ ePl;rpg;gLj;jg;gl;l Neuj;jpy;
,d;Ndhu; cs;nghUs; / gadu; rhu;ghf Xu; ,aq;Fepiy R+oypy; Nehf;f mbg;gilapy;
jd;dpaf;fkhd Kiwapy; njhopw;gLfpd;wJ
B - xU gy; Kftu; mikg;G> Kftu;fs; vdg;gLk; gpur;rpid-jPu;T cs;nghUs;fspd;
tiyaikg;ghFk;> ,J xt;nthU Kftupd; jdpj; jpwd;fSf;Fk; mg;ghw;gl;l
rpf;fy;fSf;fhd jPu;TfSf;fhd gjpy;fisf; fz;Lgpbf;f xd;whf Ntiy nra;fpwJ
C - Ez;zwpT Kftu; Xu; jd;dpaf;fkhd cs;nghUshFk;> mJ Xu; R+oypy; czupfspD}lhf
mtjhdpg;gJld;> mr; R+oypy; Xu; Nehf;fj;jpidailAk; nghUl;L ,aq;Ffpd;wJ
,tw;Ws; rupahd $w;Wf;fs; vJ /vit?
(1) A khj;jpuk; (2) B khj;jpuk; (3) A,B khj;jpuk; (4) B,C khj;jpuk; (5) A,B,C midj;Jk;

[See page 13
AL/2022/20/T-I -13-

49. gpd;tUtdtw;iwf; fUJf.

A - gy;gupkhz topKiwapy; gy;gupkhz gpw;Wf;fisg; (qubits) gad;gLj;jp ghupastpyhd
juTfs; fhl;rpg;gLj;jg;gl KbAk;
B - khjpupaq;fs; kw;Wk; kiwFwpahf;fk; (modeling and encryption) Nghd;w ghupa juTj;js
Kfhikj;Jtj;jpy; gad;gLj;jg;gl KbAk;
C - ghuk;gupa fzpdpfisf; fhl;bYk; juTr; nrad;Kiwf; fjp mjpfkhFk;
NkYs;stw;Ws; nrhl;Lf; fzpdpahf;fk; (quantum computing) gw;wp rupahdit vit?
(1) A khj;jpuk; (2) B khj;jpuk; (3) C khj;jpuk; (4) A,B khj;jpuk; (5) A,B,C midj;Jk;

50. gpd;tUk; $w;Wf;fisf; fUJf.

A - Nghf;Ftuj;J neupry; gw;wpa jfty;fisg; gFg;gha;T nra;tjD}lhf Kbtplj;jpw;fhd
jFe;j ghijapid toq;Fjy;.
B - thfdq;fis mq;ff P upg;gjD}lhf tPjpg;gad;ghl;bw;fhd fl;lzq;fisj; jd;dpaf;fkhff;
fzpj;jy;.
C - tsp> ePu;> kz; Nghd;wtw;wpd; khR epiyikapid ,dq;fhzy;.
NkYs;stw;Ss; ru;ttpahgff; fzpdpg;gLj;jy; (ubiquitous computing) R+oy;fspd; Nritfshf
,Uf;ff;$bait vit?
(1) A khj;jpuk; (2) B khj;jpuk; (3) A,C khj;jpuk; (4) A, B khj;jpuk; (5) A, B,C midj;Jk;

***

[ End
AL/2022/20/T-II
-1-
KOg;gjpg;GupikAilaJ / All Rights Reserved ]

Rl;nlz; : ………………………………………

❖ ,t; tpdhj;jhs; A, B vd;Dk; ,U guPl;rfupd; cgNahfj;jpw;F khj;jpuk;

gFjpfisf; nfhz;Ls;sJ. ,U gFjpfSf;Fk; gFjp tpdh ,y. Gs;spfs;
xJf;fg;gl;l Neuk; %d;W kzpj;jpahyq;fs;
MFk;.( Nkyjpf thrpg;G Neukhf 10 epkplq;fs; 1
toq;fg;gLk;.) 2
A
❖ fzpg;ghid gad;gLj;jf;$lhJ. 3
❑ gFjp A - mikg;Gf;fl;Liu 4
❖ tpdhf;fSf;Fk; tpilfis ,t;
5
tpdhj;jhspNyNa vOJf.
6
❖ xt;nthU tpdhTf;Fk; tplg;gl;Ls;s ,lj;jpy;
ckJ tpilfis vOJf. 7
❖ nfhLf;fg;gl;Ls;s ,lk; ckJ tpilfSf;Fg; B 8
NghJkhdJ vd;gijAk; tpupthd tpilfs;
9
mtrpakpy;iy vd;gijAk; ftdpf;f.
10
❑ gFjp B - fl;Liu
nkhj;jk;
❖ ,g;gFjp MW tpdhf;fisf; nfhz;Ls;sJ.
mtw;wpy; ehd;F tpdhf;fSf;F khj;jpuk; rjtPjk;
tpil vOJf. ckf;F toq;fg;gLk; jhs;fis ,Wjpg; Gs;spfs;
,jw;F gad;gLj;Jf. ,yf;fj;jpy;
❖ ,t; tpdhj;jhSf;nfd toq;fg;gl;l Neu nrhw;fspy;
Kbtpy; gFjp A NkNy ,Uf;Fk; gbahf A, FwpaPl;nlz;fs;
tpilj;jhs; guPl;rfu; 1
B Mfpa ,uz;L gFjpfisAk; xd;whfr;
tpilj;jhs; guPl;rfu; 2
Nru;j;Jf; fl;ba gpd;du; guPl;ir
Gs;spfisg; guPl;rpj;jtu;
Nkw;ghu;itahsuplk; ifaspf;f.
Nkw;ghu;it nra;jtu;
❖ tpdhj;jhspd; gFjp B ia khj;jpuk; guPl;ir
kz;lgj;jpypUe;J ntspNa vLj;Jr; nry;y
mDkjpf;fg;gLk;.

[gf;. 2 Ig; ghu;f;f

 AL/2022/20/T-II
-2-

gFjp A – mikg;Gf; fl;Liu ,g;gFjpapy;

ehd;F tpdhf;fSf;Fk; ,j;jhspNyNa tpil vOJf. vjidAk;
vOJjy;
1. MfhJ

(a)
(i) gpd;tUk; tpistpid tiyNkNyhb xd;wpy; ngWtjw;fhd HTML FwpKiwf;
$W fPNo jug;gLfpd;wJ. mtw;wpd; ,ilntspfisg; nghUj;jkhd tpjj;jpy; epug;Gf.
<……..>
<…….> Violin </……>
<…….> - a string instrument </……>
<…….> Clarinet </…….>
<…….> - a wind instrument </…….>
</…….>
[2 marks]
(ii) gpd;tUk; tiyg;gf;fj;jpidf; fUJf.

NkNy jug;gl;l tiyg;gf;fj;jpidf; fhl;rpg;gLj;Jtjw;F Ntz;ba HTML FwpKiw

fPNo jug;gLfpd;wJ. mtw;wpdJ ,ilntspfisg; nghUj;jkhd tpjj;jpy; epug;Gf.

<html>
<head>
<title> Registration </title>
</head>
<body>
<form action="register.php" method="post">
<fieldset>
<legend> Register </legend>
Full Name: <input type="……………………" name="name"/>
<p> Mail Address: <input type="…………………….." name="email"/> </p>
User Name: <input type="……………………." name="uname"/>
<p> Password: <input type="………………………" name="pwd"/> </p>
[gf;. 3 Ig; ghu;f;f
AL/2022/20/T-II -3-
,g;gFjpapy;
<input type="…………………………" name="Submit" value="Submit"/> vjidAk;
vOJjy;
<input type="…………………………" name="Cancel" value="Cancel"/> MfhJ

</fieldset>
</form>
</body>
[3 marks]
(b)
(i) gpd;tUk; ml;ltizapYs;s tplaq;fisf; fUJf.

milahs xl;Lf;fs; njhlu;ghzpj; jhs;

(CSS)
(tags)
p font → arial
font colour → red
font size → 16px
h1 font colour → red
font size → 16px
div font → arial
font size → 16px

NkNy jug;gl;l ml;ltizapYs;s tplaq;fisg; gad;gLj;jp> ntspg;Gwg; ghzpj;

jhspid (externa style sheet) FOthf;fg;gl;l njupapapid (group selector) khj;jpuk;
gad;gLj;jp vOJf.
…………………………………………………………………………………………………

…………………………………………………………………………………………………

…………………………………………………………………………………………………

[2 marks]

(ii) ‘register.css’ vDk; ntspg;Gw CSS Nfhg;nghd;wpid ‘myfile.html’ vDk; Nfhg;Gld;

,izg;gjw;Fupa CSS FwpKiwf; $wpid vOJf (,U Nfhg;Gf;fSk; xNu
Nfhg;Giwapy; ,Ug;gjhff; fUJf).

…………………………………………………………………………………………………

[1 marks]

(c) gpd;tUk; PHP script ,idf; fUJf. gpd;tUk; gl;baypypUe;J njupT nra;tjdhy; ①
,ypUe;J ④ tiu jug;gl;l Kfg;gilahsq;fSf;fhf nghUj;jkhd nrhw;fis
vOJf.

[gf;. 4 Ig; ghu;f;f

 AL/2022/20/T-II -4-
,g;gFjpapy;
<?php vjidAk;
vOJjy;
$conn = new ①("localhost”,”root”,”admin”,”myDB”); MfhJ

if ($conn->②)
{
die("Connection failed: " . $conn->connect_error);
}
$sql = "UPDATE MyGuests SET lastname='Doe' WHERE id=2";
if ($conn->③($sql) === TRUE)
{
echo "④";
}
else
{
print "Error updating record: " . $conn->error;
}
$conn->close();
?>

Kfg;gilahsq;fs; gl;baYf;fhd nrhw;fs;

gl;bay;: [query, echo, Record updated successfully, close(), mysqli, connect_error]

[2 marks]

2.
(a) nrt;tfk; xd;wpdJ ePsk; kw;Wk; mfyk; Mfpatw;iw cs;sPL nra;J mjd;
gug;gsT kw;Wk; Rw;wsT Mfpatw;iw tUtpisTfshff; fhl;rpg;gLj;Jtjw;fhd
KOikg;gLj;jg;glhj gpd;tUk; gha;r;rw;Nfhl;Lg; glj;jpidf; fUJf. ePsk; kw;Wk;
mfyk; Mfpait G+r;rpak; my;yJ kiwg;ngWkjpfshf ,Uf;Fk;NghJ
gha;r;rw;Nfhl;Lg; glk; epw;fNtz;Lk;.

gug;gsT = ePsk; x mfyk;> Rw;wsT = 2 x (ePsk; + mfyk;) MFk;.

[gf;. 5 Ig; ghu;f;f

AL/2022/20/T-II -5-
,g;gFjpapy;
vjidAk;
Muk;gk; vOJjy;
MfhJ
ePsk; (L), mfyk; (B)
Mfpatw;iw cs;sPL nra;f

,y;iy

Mk;

KbT

gha;r;rw;Nfhl;Lg; glj;jpy; ,ilntspfisg; nghUj;jkhd tpjj;jpy; epug;Gf.

[4 marks]

(b) gpd;tUk; igj;jhd; nra;epuyhdJ xU Fwpj;j vz;zpf;ifapyhd gadu;

cs;sPLfspd; $l;Lj;njhifapid ntspaPlhfj; jUfpd;wJ.

…………….. = int(input("Enter a number: "))

if num < 0:
print("Enter a positive number")
else:
sum = ……….
while (num > 0):
sum += num
…………………………….
print("The total is", ……………..)

(i) ,ilntspfisg; nghUj;jkhd tpjj;jpy; epug;Gf.

[2 marks]
(ii) KjyhtJ tupapy; gadu; cs;sPlhf 5 ,id toq;fpdhy; tUtpisT ahjhf
,Uf;Fk;?
………………………………………………………………………………………………………

………………………………………………………………………………………………………

[2 marks]

[gf;. 6 Ig; ghu;f;f

 AL/2022/20/T-II -6-
,g;gFjpapy;
(c) xU juTj;jsj;jpypUe;J gjpTfisj; Nju;e;njLg;gjw;fhd gpd;tUk; igj;jhd; vjidAk;
vOJjy;
FwpKiwf; $Wfs; jug;gLfpd;wd. mit epiwNtw;Wif (execution) xOq;FKiwapy; MfhJ
jug;gltpy;iy. fPNo nfhLf;fg;gl;Ls;s ntw;wplq;fspy; FwpaPl;L tup vz;iz
epiwNtw;W tupirapy; vOJf (Kfg;gilahsq;fis khj;jpuk; vOJf).

,y. %yf;FwpKiwapdJ tupfs;

❶ ex = conn.cursor()

❷ res = ex.fetchall()
for i in res:
print(i)
❸ ex.execute("SELECT * FROM employee")

❹ import mysql.connector
conn = mysql.connector.connect(host="localhost", user="root", password="admin",
database="myDB")

1………………………….. 2…………………………..
3………………………….. 4…………………………..
[2 marks]
3.
(a) fPNo jug;gl;l gl;baypypUe;J epuy; X ,w;Fupatw;iw epuy; Y ,y; vOJf.
[njhopDl;g ,ay;jfT> nghUshjhu ,ay;jfT> nra;gzp ,ay;jfT> r%f-fyhr;rhu
,ay;jfT> rl;l ,ay;jfT> fhyml;ltiz ,ay;jfT]
epuy; X epuy; Y
(i) Kiwikapid mgptpUj;jp nra;tjw;F (A)
Ntz;ba trjpfs; eilKiwapy; ……………………………………
cs;sjh? vd;gjid kjpg;gply;
(ii) xU nraw;wpl;lj;jpdJ (project) nryT (B)
gw;wpa mstPL ……………………………………

(iii) jug;gl;l epWtd mikg;gpy; (C)

KiwikahdJ ,aq;Ffpd;wjh? vd ……………………………………
mwpjy;
(iv) xU nraw;wpl;lj;jpid epahakhf (D)
Kbg;gjw;F vt;tsT fhyg;gFjpapid ……………………………………
vLf;Fk; vd;gJ gw;wpa mstPL
[2 marks]
(b)
(i) juTj;js nrt;tdhf;fj;jpdJ (normalization) ,U ed;ikfis vOJf.

…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
[2 marks]
[gf;. 7 Ig; ghu;f;f
AL/2022/20/T-II -7-
,g;gFjpapy;
(ii) xU tpepNahf fk;gdpapy;;> xt;nthU Xl;LeUk; (driver) ve;j thidAk; (van) vjidAk;
vOJjy;
nrYj;jyhk;>; xt;nthU thDk; ve;j Xl;LduhYk; nrYj;jg;glyhk;. gpd;tUk; MfhJ
juTj;js ml;ltiz xt;nthU thDk;> xt;nthU Xl;Leuhy; nrYj;jg;gLfpd;w
J}uj;ijg; gjpT nra;fpd;wJ.

DriverID VanID DriverName VanMake Mileage

D01 V03 Selvam Ford 350
D02 V01 Silva Mercedes 800
D01 V01 Selvam Mercedes 200

jug;gl;l ml;ltizapid %d;whk; nrt;td; tbtpw;F (3NF) khw;Wf.

ePu; cUthf;fpa ml;ltiz xt;nthd;Wf;Fk; Kjd;ikr;rhtpapidj; njspthff;
Fwpg;gpLf (ml;ltizfis mikg;G (schema) tbtpy; vOJf).
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…..…………………………………………………………………………………………………….
[3 marks]

(c) fPNo nfhLf;fg;gl;Ls;s gl;baypypUe;J kpfTk; nghUj;jkhd cUg;gbAld; (i) Kjy;

(vi) tiu nfhLf;fg;gl;l xt;nthU nrhw;nwhliuAk; nghUj;Jf:
gl;bay;:[,ize;j tUthd khjpupak;> jiyfPo; Vyk;> kpd; re;ijg;gLj;jy;> tiy
thry; (web portal), B2C khjpupak;> nka;epfu; filKfg;G (virtual storefront),
gpwpf; kw;Wk; Nkhl;lhu; tpahghuk; (brick-and-mortar business), Nghl;bapil
mD$yk; (competitive advantage), tUthd khjpupakhf re;jh> jfty; jufu;>
elkhLk; re;ijg;gLj;jy; (mobile marketing), juTj;js re;ijg;gLj;jy;]
nrhw;nwhlu;fs;:
(i) ,izaj;jsq;fs;> kpd;dQ;ry;> v];vk;v];> r%f Clfq;fs; %yk;
nry;yplj;njhiyNgrpfs;> kbNky; fzpdpfs; Nghd;wtw;wpD}lhff; Fwpg;gpl;l
ghu;itahsu;fis nrd;wiltij ikakhff; nfhz;l njhluwh re;ijg;gLj;jy;
El;gkhFk;.
(ii) xU epWtdk; mjd; Nghl;bahsu;fisf; fhl;bYk; nghUl;fs; my;yJ Nritfis
rpwg;ghfNth my;yJ kypthfNth cw;gj;jp nra;a mDkjpf;Fk; fhuzpfisf;
Fwpf;fpd;wJ.
(iii) tof;fkhd ,ilntspapy; Kiwtopg;gLj;jg;gLfpd;w njhlu;r;rpahd fl;lzj;ij
thbf;ifahsu;fsplk; tR+ypg;gjd; %yk; ,J tUkhdj;jpid cUthf;Ffpd;wJ.
(iv) ,J Xu; tpNrlkhf tbtikf;fg;gl;l ,izaj;jskhFk;> kpd;dQ;ry;> njhluwh
kd;wk; (online forum) kw;Wk; NjLnghwp Nghd;w gy;NtW %yq;fspypUe;J
jdpj;Jtkhd topKiwapy; jfty;fisf; nfhz;LtUfpd;wJ.
(v) ,J thbf;ifahsupd; Njitapidj; jpUg;jpnra;Ak; nghUl;L ,izak; kw;Wk;
cyfshtpa tiy Nghd;w fzpdpkakhf;fg;gl;l> tiyaikg;Gr; R+oypy;
nghUl;fs; kw;Wk; Nritfspd; tpepNahfk;> Nkk;gLj;Jif kw;Wk; tpiy epu;zak;
Mfpatw;iwj; jpl;lkpl;Lr; nraw;gLj;Jfpd;w Xu; KiwtopahFk;.

[gf;. 8 Ig; ghu;f;f

AL/2022/20/T-II -8-
,g;gFjpapy;
(vi) jdJ tpahghur; nraw;ghLfSf;fhf rpy;yiw filfs; my;yJ Nrkpg;Gf; vjidAk;
vOJjy;
fplq;Ffis (warehouses) itj;jpUf;Fk; xU epWtdj;ijf; Fwpf;f ,J MfhJ
ngUk;ghYk; gad;gLj;jg;gLfpd;wJ.

kpfTk; nghUe;Jfpd;w nrhw;nwhlupidf; fPNoAs;s ml;ltizapDs; vOJf.

,y. nrhw;nwhlu;

(i)

(ii)

(iii)

(iv)

(v)

(vi)

[3 marks]
4.
(a) gpd;tUk; epiyikapidf; fUJf.

RK fl;ll xg;ge;jjhuu;fs; vd;gJ nghJkf;fSf;F tPL fl;Ljy; kw;Wk; nrhj;J

(property) Nkk;ghl;L Nritfis toq;Fk; xU epWtdk; MFk;. epWtdj;jpd;
cupikahsu; (proprietor) Nkrd;> kuNtiy nra;gtu; kw;Wk; Foha; nghUj;Jdu;
Nghd;w gy jpwikahd njhopyhsu;fis Ntiyf;F mku;j;Jfpwhu;. cupikahsu;
fl;blj; nraw;wpl;lq;fisj; jhNd epu;tfpf;fpwhu;.
RK fl;ll xg;ge;jjhuu;fs; fl;bl Ntiyfspd; Kfhikj;Jtj;ijf; fzpdpkakhf;f
tpUk;Gfpd;wJ. mJ kjpg;gL P fs;> Ntiy jpl;lkply; kw;Wk; gzf; nfhLg;gdTfspd;
nrad;Kiw Mfpatw;iw cs;slf;Ffpd;wJ.
xU thbf;ifahsu; epWtdj;ijj; njhlu;Gnfhz;L kjpg;gPl;ilf; NfhUk;NghJ>
cupikahsu; thbf;ifahsupd; njhlu;G tptuq;fs; kw;Wk; Kd;nkhopag;gl;l
Ntiyapd; NkNyhl;lkhd jpl;lj;jpid (outline) Mfpatw;iwf; Fwpg;gpLfpd;whu;.
Ntiyf;fhd nryit kjpg;gpLtjw;fhf thbf;ifahsUld; mtupd; nrhj;jpidg;
ghu;gg
; jw;F xU jpfjpia xg;Gf;nfhs;fpwhu;. xg;Gf;nfhs;sg;gl;l jpfjpapy;
nrhj;jpidg; ghu;itapLk; NghJ> Kd;nkhopag;gl;l Ntiyapd; NkNyhl;lkhd
jpl;lj;Jld; cupikahsu; $Ljy; tptuq;fisr; Nru;f;fpwhu;. nrhj;jpidg; ghu;itapl;l
3 ehl;fSf;Fs; cupikahsu; xU KOikahd tpupthd kjpg;gl P ;il cUthf;fp
thbf;ifahsUf;F mDg;Gfpwhu;. thbf;ifahsu; kjpg;gPl;il Vw;Wf;nfhz;lhy;>
cupikahsu; Ntiyiaj; njhlq;Ftjw;fhd jpfjpiaj; jpl;lkpLfpwhu; (,J
Ntiyapd; msT kw;Wk; Vw;fdNt jpl;lkplg;gl;l gpw Ntiyfspd; mbg;gilapy;
mike;Js;sJ).
xU Ntiyapd; xg;Gf;nfhs;sg;gl;l njhlf;fj; jpfjpf;Fr; rpy ehl;fSf;F Kd;G>
cupikahsu; thbf;ifahsiuj; njhlu;Gnfhz;L> njhlf;fj; jpfjpia cWjpnra;J>
gpd;du; Njitahd fl;Lkhdg; nghUl;fis Ntiy njhlq;Fk; jpfjpapy; toq;FkhW
tpepNahf];juplkpUe;J fl;lis ,Lfpd;whu;. Ntiy Kbe;jJk;> thbf;ifahsUf;F
mDg;gg;gLk; tpiyg;gl;bay; (invoice) jahupg;gjw;fhf> Ntiyapd; cz;ikahd
nryit cupikahsu; fzf;fpLfpwhu;. thbf;ifahsUf;F tpiyg;gl;bay; nrYj;j 30
ehl;fs; cs;sd.
[gf;. 9 Ig; ghu;f;f
AL/2022/20/T-II -9-
,g;gFjpapy;
vjidAk;
vOJjy;
1 cupikahsu;
Gjpa Ntiyf;fhd ② MfhJ
Ntz;LNfhs;
Gjpa Ntiyf;fhd
Ntz;Lifapidg;
ngWjy;
ghu;itapLk; jpfjp
Gjpa D1 thbf;ifahsu;
Ntiyf;fhd
2 NkNyhl;lk;
① cupikahsu;
Ntiy tpguk;
D2 Ntiy
nrhj;jpidg;
ghu;itapLjy;
Vw;Wf;nfhs;sg;gl;l kjpg;gPL
kjpg;gplg;gl;l nryT
thbf;ifahsu; ngau;+tpyhrk;
3 cupikahsu;
thbf;ifahsu; ngau;+tpyhrk;
⑤
⑥
Vw;Wf;nfhs;sg;gl;l kjpg;gPL

Ntiy tpguk;
4 cupikahsu;
Njitg;gLk;
nghUl;fSf;Ff; D2
nghUl;fs; Ntiy
fl;lisaplYk;> ⑦
Ntiyapidf;
njhlq;FjYk;
③
toq;fg;gl;l Ntiy njhlq;Fk; D3 ⑧
nghUl;fs; jpfjp
5 cupikahsu; Ntiy tpguk;
toq;fg;gl;l nghUl;fs;
nra;ag;gl;l
⑨ Ntiyf;Fupa D2 Ntiy
tpiyg;gl;baiyj; kjpg;gplg;gl;l
jahupj;jy; Ntiy+nghUl;fs;
NtiyapdJ
nryT gzf;
nfhLg;gdT D4 ④
⑩
thbf;ifahsu;

D1 thbf;ifahsu;

NkNy jug;gl;l Kjyhk; kl;l juTg;gha;r;ry; tupg;glj;jpYs;s (DFD) ,ilntspfisg;

nghUj;jkhd tpjj;jpy; epug;Gf.

① …………………………………………………………………

② …………………………………………………………………

③ …………………………………………………………………

④ …………………………………………………………………

⑤ …………………………………………………………………

⑥ …………………………………………………………………

⑦ …………………………………………………………………

⑧ …………………………………………………………………
[gf;. 10 Ig; ghu;f;f
AL/2022/20/T-II -10-
,g;gFjpapy;
⑨ ………………………………………………………………… vjidAk;
vOJjy;

⑩ ………………………………………………………………… MfhJ

[5 marks]

(b) juTj; njhlu;ghly; kw;Wk; fzpdp tiyaikg;Gf;fs; gw;wpa gpd;tUk; $w;Wf;fisf;

fUJf. fPNo jug;gl;Ls;s gl;baypy; ,Ue;J ntw;wplq;fis epug;Gtjw;Fg;
nghUj;jkhd nrhw;fisj; njupT nra;f.

(i) ……………………… MdJ ,izaj;ijg; gad;gLj;Jtjw;F gjpT nra;ag;glhj

(unregistered) IP Kftupfisg; gad;gLj;jp jdpg;gl;l IP tiyaikg;Gf;fis
nraw;gLj;Jtjd; %yk; IP Kftupfisg; ghJfhf;fpd;wJ.
(ii) …………………….. vd;gJ xU epWtdj;jpy; Kd;dNu jPu;khdpf;fg;gl;l ghJfhg;G
nfhs;iffspd; mbg;gilapy;> cs;tUfpd;w kw;Wk; ntspr;nry;Yfpd;w (incoming /
outgoing) tiyaikg;G Nghf;Ftuj;jpidf; fz;fhzpj;J tbfl;Lfpd;w (filtering)
tiyaikg;G ghJfhg;G rhjdk; MFk;.
(iii) …………………….. MdJ ek;gfkhd Xu; cs;nghUs; (entity) Nghd;W jd;id
,dq;fhl;b GFgjpif (login) tpguq;fs; kw;Wk; fld; ml;il vz;fs; Nghd;w
gadu; juTfisj; jpUl gad;gLfpd;w Xu; r%f nghwpapay; jhf;FjyhFk;.
(iv) …………………. vd;gJ Xu; gpwo;nghUs; (malware) MFk;> mJ
ghjpf;fg;gl;ltupd; (victim) jftiy kiwFwpahf;fp (encryption) itj;jpUe;J
mjid toq;Ftjw;F gzj;jpid Xu; Nfs;tpahff; NfhUfpd;wJ.
(v) …………………. vd;gJ Xu; rkpf;iQ njhlu;G Clfj;ij xNu Neuj;jpy; fle;J
nry;tjw;fhf gy jfty; njhlu;G rkpf;iQfis xd;whf ,izf;ff;$ba
njhopy;El;gk; ,JthFk;.

[gl;bay; : DNS, tiytPry; (Phishing), FTP, fg;gg;nghUs; (Ransomware), ALOHA,

Ethernet, jPr;Rtu; (Firewall), topr;nrayp (Router), Nuh[d; Fjpiu (Trojan
horse), NAT, gd;ikahf;fk; (Multiplexing), UDP]
[5 marks]
**

[gf;. 11 Ig; ghu;f;f

 AL/2022/20/T-II -11-
KOg;gjpg;GupikAilaJ / All Rights Reserved ]

gFjp B
 ehd;F tpdhf;fSf;F khj;jpuk; tpil vOJf.

(5) gpd;tUk; jUf;fr; Rw;wpidf; fUJf.

A
B
C

(a) NkNy jug;gl;l jUf;fr; Rw;wpdJ tUtpisT F ,w;fhd G+ypad; Nfhitapid vOJf.
(b) NkNy (a) y; ngwg;gl;l G+ypad; Nfhitf;fhd nka;al;ltizapid mikf;f.
(c) fhu;dh tupg;glj;jpidg; gad;gLj;jp F ,w;F Xu; RUf;fg;gl;l Nfhitapidg; ngWf.
(d) NAND jUf;f thapy;fis khj;jpuk; gad;gLj;jp F f;fhd Rw;wpidr; nraw;gLj;j xU
Rw;wpid tiuf.
[3+4+4+4=15 marks]
(6)
(a) 10110001 vDk; juT CLflj;jpd;NghJ kd;nr];lu; rkpf;iQ FwpKiwahf;fj;jpid
(manchester signal encoding) gpd;tUk; tupg;glj;jpy; tiue;J fhl;Lf (tupg;glj;jpid ckJ
tpilj;jhspy; gpujpnra;f).

1 0 1 1 0 0 0 1

[gf;. 12 Ig; ghu;f;f

AL/2022/20/T-II -12-

(b) gpd;tUk; epiyikapidf; fUJf.

xU eLj;ju Milj;njhopw;rhiyahdJ tpahghu jfty; Kiwik> fzf;fpay;> cw;gj;jp>

re;ijg;gLj;jy; Nghd;w xt;nthU jpizf;fsq;fSf;Fk; ehd;F ,lj;Jup
tiyaikg;Gf;fisf; (LAN s) nfhz;Ls;sd. fPNo jug;gl;l ml;ltizapy; xt;nthU
jpizf;fsKk; fzpdpfspd; vz;zpf;ifiaf; nfhz;Ls;sd.

jpizf;fsq;fs; xt;nthU xt;nthU jpizf;fsj;jpYKs;s

jpizf;fsj;jpYKs;s tiyaikg;G mr;Rg;nghwpfspd;
fzpdpfspd; vz;zpf;if vz;zpf;if
tpahghu jfty; 19 2
Kiwik
fzf;fpay; 17 1

cw;gj;jp 10 1

re;ijg;gLj;jy; 22 2

xU IP njhFjp 192.146.1.0/24 MdJ tiyaikg;G epu;thfpf;F (network administrator)

toq;fg;gl;Ls;sJ. tiyaikg;G epu;thfp xt;nthU jpizf;fsj;jpYKs;s midj;Jf;
fZf;fSf;Fk; (nodes) IP Kftupfis xJf;f Ntz;Lk;. ,e; Nehf;fj;jpw;fhf ehd;F
cgtiyaikg;Gf;fs; mikf;fg;glTs;sd kw;Wk; ,e;j tiyaikg;G Copau;fspd;
,izag; gad;ghl;bw;fhf xU nghJ IP KftupAld; ,izf;fg;gl;Ls;sJ. xt;nthU
jpizf;fsKk; xU gpuNjrj;jpy; ntt;NtW fl;blq;fspy; mike;Js;sd. tiyaikg;gpd;
ghJfhg;gpw;fhf xU jPr;Rtu; epWtg;gl;Ls;sJ kw;Wk; ehd;F Mspfs;> Njitahd
tiyaikg;G tlq;fs;> gjpyhs; (proxy) Nritafk; kw;Wk; DHCP Nritafk; Mfpait
,e;Nehf;fj;jpw;fhf tiyaikg;G epu;thfpf;F toq;fg;gLfpd;wd. tpahghu jfty; Kiwik
jpizf;fskhdJ Neubahf ,izaj;Jld; ,izf;fg;gl;Ls;sJ.
,e; epiyikf;fhd Xu; tiyaikg;G tupg;glj;jpid tiuf. midj;J IP Kftupfs;>
tiyaikg;G ,izg;G rhjdq;fs; kw;Wk; Nritafq;fs; Mfpatw;iwj; njspthff;
fhl;Lf.
IP Kftupfis xJf;Ftjw;F gpd;tUk; ml;ltizapid Xu; cjtpahfg; gad;gLj;Jf
(,jw;fhf khWk; ePsKila cgtiy kiwKfj;jpid (VLSM) khj;jpuk; gad;gLj;Jf).

jpizf;fsq;fs; tiyaikg;G xypgug;G Kftup cgtiy gad;gL IP

Kftup kiwKfk; Kftup tPr;R
tpahghu jfty;
Kiwik
fzf;fpay;

cw;gj;jp

re;ijg;gLj;jy;

[4+11=15 marks]

[gf;. 13 Ig; ghu;f;f

AL/2022/20/T-II -13-

(7)
(a) BestFit vd;gJ ijj;j Milfis tpw;fpd;w Xu; tpahghukhFk;. jw;NghJ ehlshtpa uPjpapy;
fhzg;gLfpd;w jdJ 25 fpisfspD}lhf tpw;gidapid Nkw;nfhs;fpd;wJ.
,izaj;jsj;jpD}lhf thbf;ifahsu;fSf;F Milfis tpw;gjdhy; ghupastpyhd
ed;ikfisg; ngwKbAk; vd;gjid epWtdk; czu;e;J nfhs;fpd;wJ.

(i) BestFit ijj;j Milfis ,izaj;jsj;jpD}lhf thbf;ifahsu;fSf;F tpw;gid nra;tJ

ve;j kpd;tu;j;jfj;jpdJ khjpupakhFk;?

(ii) thbf;ifahsu;fs; jkJ fl;lzq;fisj; njhluwh (online) Kiwapy; nrYj;jf;$ba

ahjhapDk; ,uz;L Kiwfis vOJf.

(iii) BestFit MdJ kpd;tpahghuj;jpw;F efUk;NghJ ngw;Wf; nfhs;sf;$ba mD$yq;fs;

,uz;bid tpsf;Ff.

(iv) BestFit MdJ jdJ ,izaj;jsj;jpid Vida tpahghuq;fSf;fhf tpupTgLj;jj;

jPu;khdpf;fpd;wJ. Vida tpahghuq;fs; ,jDhlhfj; jkJ Milfis tpw;gid nra;a
KbAk;. ,jd;NghJ BestFit gad;gLj;j KbAkhd kpd; tUkhd khjpupaq;fs; (e-revenue
models) ,uz;bid vOJf.
[1+2+2+2+1=8 marks]
(v) NkNy (iv) ,y; BestFit Vida epWtdq;fspD}lhd tpahghur; nraw;ghLfs; ve;j
kpd;tu;j;jfj;jpdJ khjpupakhFk; vdf; Fwpg;gpLf.

(b) gpd;tUk; epiyikapidf; fUJf.

BestFit vd;gJ Xu; gy;Kftu; Kiwikapidf; nfhz;l ,izaj;jskhFk;.

thbf;ifahsu;fs; jkf;fhd Milfisj; Njbg;ghu;j;J thq;Ftjw;F mJ cjTfpd;wJ.
xU thbf;ifahsu; BestFit ,izaj;jsj;jpDs;Ns gpuNtrpf;Fk;NghJ Xu; mul;il (chat-bot)
Kftu; Kjypy; thbf;ifahsUld; ,ilj;njhlu;G nfhs;fpd;wJ. gadu; Fuy; (voice) kw;Wk;
ghlj;jpd; (text) mbg;gilapy; MilfSf;fhd jkJ Njitg;ghLfis thbf;ifahsu;
toq;f KbAk;. ,jd;NghJ mul;il Kftu; %yk; toq;fg;gLfpd;w jfty;fs; xU
gpupj;njLg;G KftUf;F (extraction agent) mDg;gg;gLfpd;wJ. gpupj;njLg;G Kftu;
thbf;ifahsuplkpUe;J ngw;w Kjy;epiyj; jfty;fisr; RUf;fkhf;fp nghUj;jkhd
jfty;fis xU Njly; KftUf;F mDg;Gfpd;wJ. mj;Njly; Kftu; Njly;fis
tiuthfTk;> kpfTk; nghUj;jkhfTk; NjLtjw;F xd;Wf;F Nkw;gl;l cg Kftu;fisg;
gad;gLj;Jfpd;wJ. ,Wjpapy; cg Kftu;fspd; %yk; ngwg;gl;l Njly; KbTfs; Njly;
KftUf;F toq;fg;gLfpd;wd. gpd;du; mk; KbTfs; thbf;ifahsUf;F toq;fg;gLfpd;wd.

(i) Nkw;Fwpj;j gy;Kftu; Kiwikf;F Xu; vspjhf;fpa Kftu; tupg;glj;ij tiuf. cq;fs;
tupg;glj;jpy; cs;s vy;yh epiynghUs;fisAk; (entities) ngaupl;L> mtw;Wf;fpilNa
cs;s ,ilj;njhlu;GfisAk; njspthff; fhl;Lf.

(ii) ,g; gy;Kftu; Kiwikapd; jd;dhl;rp (self-autonomous) nkd;nghUs; Kftu;fspd;

ngau;fis vOJf.

(iii) mul;il Kftu; %yk; toq;fg;gl;l jfty;fs; Neubahf Njly; KftUf;F

mDg;gg;glhikf;fhd fhuzk; xd;wpid tpsf;Ff.

[4+2+1=7 marks]

[gf;. 14 Ig; ghu;f;f

 AL/2022/20/T-II -14-

(8)
(a) gpd;tUk; epiyikapidf; fUJf.
cw;gj;jpahsu;fspdhy; (manufacturers) thfd cjpupg;ghfq;fs; jahupf;fg;gLfpd;wd. xU
cw;gj;jpahsu; xd;Wf;F Nkw;gl;l cjpupg;ghfq;fis cw;gj;jp nra;a KbAk;.
thbf;ifahsu;fs; cjpupg;ghfq;fSf;fhf fl;lisfisg; (orders) gpwg;gpf;f KbAk;. xU
thbf;ifahsu; xd;Wf;F Nkw;gl;l fl;lisfisg; gpwg;gpf;f KbAk;. thbf;ifahsu;fshy;
gpwg;gpf;fg;gLfpd;w fl;lisfspy; xd;Wf;F Nkw;gl;l cjpupg;ghfq;fs; fhzg;glKbtJld;>
xU Fwpg;gpl;l cjpupg;ghfkhdJ xd;Wf;F Nkw;gl;l fl;lisfspy; ,Uf;f KbAk;.
fl;lisahdJ thbf;ifahsupdJ ,Ug;gpy; jq;fpAs;sJ.
gpd;tUk; juTfs; xt;nthd;Wk; ,jw;fhff; fsQ;rpag;gLj;jg;gl Ntz;bAs;sd.
▪ cw;gj;jpahsu;fspd; ngau;fs; kw;Wk; Kftupfs; (KftupahdJ city, street Mfpatw;iwf;
nfhz;bUf;Fk;)
▪ cjpupg;ghfq;fspd; cjpupg;ghf ,yf;fk; kw;Wk; mJ gw;wpa tptuzk; (description)
▪ thbf;ifahsu;fspd; ,yf;fk; kw;Wk; ngau;
▪ fl;lisfspd; fl;lis ,yf;fk; (order number)
▪ xt;nthU fl;lisfSk; ntt;NtW mstpyjhd (quantity) cjpupg;ghfq;fisf;
nfhz;bUf;Fk;
jug;gl;l epiyikf;fhd ER tupg;glj;jpid tiuf. ahjhapDk; vLNfhs;fs;
gad;gLj;jg;gbd; mtw;iwj; njspthff; Fwpg;gpLf.
[6 marks]
(b) gpd;tUk; jutl;ltizahdJ Xu; epWtdj;jpdJ Copau;fs; (employees) njhlu;ghd
tpguq;fisf; fhl;Lfpd;wJ.
Employees
EmployeeNo DepartmentNo EmployeeName Department
1 101 Amith HR
2 102 Divya IT
3 101 Rama HR

(i) NkYs;s jutl;ltiz ve;j nrt;td; tbtpy; cs;sJ vd;gjid cupa fhuzj;Jld;
epahag;gLj;Jf.
(ii) NkYs;s jutl;ltizapid mLj;j nrt;td; tbtpwF khw;Wf. ml;ltizfis
mikg;G tbtpy; vOJf.
[2+3=5 marks]
(c) gpd;tUk; ‘Persons’ vDk; jutl;ltizapidf; fUJf.
PersonID FirstName LastName City
P001 John Joe Colombo
P002 Perera Silva Galle
P003 Jamuna Sivarasa Jaffna
P004 Hakeem Aslum Kandy
P005 Vimali Nathan Jaffna

(i) ‘P003’vDk; egupdJ (person) gjptpid ml;ltizapypUe;J ePf;Ftjw;Fj; Njitahd SQL

$w;wpid vOJf.
(ii) select PersonID,FirstName,City from Persons where City=’Jaffna’; vDk; SQL $w;whdJ
ml;ltizf;Fg; gpuNahfpf;fg;gLk;NghJ ngwg;gLfpd;w tUtpistpid vOJf.

[2+2=4 marks]
[gf;. 15 Ig; ghu;f;f
 AL/2022/20/T-II -15-

(9)
(a) xU Fwpj;j vz;zpf;ifapyhd (N vd;f) ghlg;Gs;spfs; gadupdhy; cs;sPL nra;ag;gl;L>
mtw;wpy; 100 my;yJ 100 ,Yk; Fiwe;j Gs;spfs; khj;jpuk; fhl;rpg;gLj;jg;glNtz;Lk;.
,jw;fhd gha;r;rw;Nfhl;Lg;glj;jpid tiuf.
[6 marks]
(b) gpd;tUk; gha;r;rw;Nfhl;Lg; glj;jpidf; fUJf.

Muk;gk;

L vDk; gl;baypid
cs;sPL nra;f

S vDk; vz;zpid
cs;sPL nra;f

count = 0, j = 0,
N = gl;baypd; ePsk;

,y;iy Is
L[j] > S ?

Mk;

count = count + 1

j=j+1

Is Mk;
j<N?

,y;iy

count ,id ntspapLf

KbT

(i) gl;bay; L MdJ 5, 4, 7, 4, 4, 3, 2, 1, 5, 6 vDk; vz;fisAk;> cs;sPL S MdJ 3 MfTk;

,Ue;jhy;> gha;r;rw;Nfhl;Lg; glj;jpd; tUtpistpid vOJf.
(ii) gha;r;rw;Nfhl;Lg; glj;jpd; Nehf;fj;jpidr; RUf;fkhf tpsf;Ff.
(iii) gha;r;rw;Nfhl;Lg; glj;jpd; %yk; jug;gLfpd;w jUf;fj;jpw;fhd igj;jhd; FwpKiwapid
vOJf.
[2+2+5=9 marks]

[gf;. 16 Ig; ghu;f;f

 AL/2022/20/T-II -16-

(10)
(a)

(i) nkd;nghUs; mgptpUj;jpapd; ,Wjpf;fl;l epiyfspy; Kiwikg; guhkupg;G (system

maintenance) Njitg;gLtjw;fhd ,U fhuzq;fisr; RUf;fkhf tpsf;Ff.
(ii) gadu; Vw;Gr;Nrhjid (user acceptance testing) vd;why; vd;d vd;gjidAk;> ahuhy; mJ
Nkw;nfhs;sg;gLfpd;wJ vd;gjidAk; RUf;fkhf tpsf;Ff.
[2+2=4 marks]

(b) 0 njhlf;fk; 64K tiuAs;s 16 - gpw;Wf;fs; nfhz;l nka;epfu; Kftupfisg; (virtual addresses)
gad;gLj;jj;jf;f xU fzpdpapidf; fUJf. ,f; fzpdpapdJ ngsjpf epidtfj;jpdJ
gUkd; 32 KB MFk; vdTk;> xU gf;fj;jpdJ gUkd; 4 KB vdTk; nfhs;f.
(i) xU gf;f vz;zpidj; (page number) Njf;fp itg;gjw;F vj;jid gpw;Wf;fs; Njit?

(ii) xU rl;lf vz;zpidj; (frame number) Njf;fp itg;gjw;F vj;jid gpw;Wf;fs; Njit?
(iii) nka;epfu; epidtfj;jpdJ ngau;r;rp (offset) vj;jid gpw;Wf;fshFk;?

[2+2+2=6 marks]

(c) gzpnray; Kiwik xd;wpy; gad;gLj;jg;gLfpd;w> njhlu;r;rpahd ,l xJf;fl P ;L KiwapdJ

(contiguous space allocation) xU mD$yj;jpidAk;> xU gpujp$yj;jpidAk; vOJf.

(d) gzpnray; Kiwik xd;wpy; gad;gLj;jg;gLfpd;w> ,izg;G ,l xJf;fl

P ;L KiwapdJ
(linked space allocation) xU ,ay;gpid vOJf.

[3+2=5 marks]

***

[KbT