part - a - answertm
DESCRIPTION
superTRANSCRIPT
1
gFjp – II (A-mikg;Gf; fl;Liu)
(1)
(a) jpuhd;rp];lh; - 3 Mk; jiyKiwf; fzpdp
Ez;nrayp - 4 Mk; jiyKiwf; fzpdp (Gs;sp 01)
4 Mk; jiyKiwf; fzpdpapd; mD$yq;fs;
Tpiy FiwT
Ntf mjpfhpg;G
msT rpwpajhfpaik…. (Gs;sp 01)
(b) CISC - ,J intel epWtdj;jpdhy; Kw; fhyj;jpy; Ez;nrayp jahhpg;gjw;fhf cUthf;fg;gl;l
KiwahFk;. ,it x86 vd mwpKfg;gLj;jg;gl;lJ. Intel, AMD tif fzpdpfs;
gad;gLj;jg;gl;ld. rpf;fyhd Kiwapyhd mwpTWj;jy;fSf;F mika ,aq;Ftjhy; ePz;l Neuk; nrytplg;gLk;.
RISC- rpf;fyw;w Kiwapyhd mwpTWj;jy;fSf;F mika ,aq;Ftjhy; Fiwe;j Neuk;
nrytplg;gLk;. Apple , Macintosh fzpdpfspy; gad;gLj;jg;gLfpd;wJ.
(Gs;sp 1 x 2 = 2)
(c) -123.75 IEEE Floating Point Single Precision Representation
i. sign bit – 1
ii. 1111011.112
iii. 1.11101111 x 26
iv. 6
v. 11101111
vi.
( (Gs;sp 1 x 6 = 6)
(2) (a)
nkd;nghUs;fs; tif
tl;L xUq;fikj;jy; (Disk Defragmentation) gad;ghl;L nkd;nghUs;
Xnguh (Opera) gpuNahf nkd;nghUs;
nkfpd;;nlh]; (Macintosh) ,af;f Kiwik
];fphpd; Nrth; (Screen Server) gad;ghl;L nkd;nghUs;
[_k;yh (Joomla) gpuNahf nkd;nghUs;
kpd;l; (Mint) ,af;f Kiwik
(Gs;sp 0.5 x 6 = 3)
1 1 0 0 0 0 1 0 1 1 1 1 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Sign bit Exponent (8 bits)
Mantissa (23 bits)
2
(b) (i) epidtf xJf;fPL (Memory Allocation)
fzpdp xd;wpid ,af;Fk; NghJ vz;zpay; tUtpistpidg; ngw;Wf; nfhs;tjw;F mjw;fhd
epuyhf;fy; epidtfj;Jld; njhlh;G nfhs;s Ntz;Lk;. ,jw;fhd ,lg;gug;ghdJ Kjd;ik
epidtfj;jpy; NghjpasT fhzg;gLtJld; chpa ,lg;gug;ghdJ xJf;fg;gLjYk; Ntz;Lk;.
(i) epidtfk; khw;wg;gly; (Memory Swapping)
jahh; epiyapYs;shd ,af;fkhdJ ngUksT Kjd;ik epidtfj;jpy; jq;fpapUf;Fkhapd;>
tpiuthf ,aq;f Ntz;ba NtnwhU ,af;fj;jpw;fhf Kjd;ik epidtfj;jpy; cs;s ,lj;ij
xJf;fpf; nfhLg;gjw;fhf Vw;fdNt Kjd;ik epidtfj;jpy; jq;fpapUe;j ,af;fkhdJ Jhpjfjp
epidtfj;jpw;F khw;wg;gLtJld; kPz;Lk; Njitg;gLk; re;jh;gj;jpy; ,af;fj;ij jahh; epiyf;F
nfhz;L tUk; (Gs;sp 1 x 2 = 2)
(c) (i) gf;fq;fspd; vz;zpf;if (Total no. of pages) = 28
= 256 (Gs;sp 1)
(ii) [01011101|0100111101]
Pages displacement
(Gs;sp-01) (Gs;sp-01)
(d)
Fat 32 NTFS
Nfhg;gpd; cah; ngWkhdk; tiuaWf;fg;gl;Ls;sJ.
Nfhg;gpd; cah; ngWkhdk; tiuaWf;fg;gltpy;iy
Nfhg;nghd;wpid ngahpLk; NghJ mjd; ePsk; tiuaWf;fg;gl;Ls;sJ.
Nfhg;nghd;wpid ngahpLk; NghJ mjd; ePsk; tiuaWf;fg;gltpy;iy
ghJfhg;gw;wJ ghJfhg;ghdJ
Unicode ,idg; gad;gLj;jp Ntiy nra;a KbahJ
Unicode ,idg; gad;gLj;jp Ntiy nra;a KbAk;
(Gs;sp 1 x 2 = 2)
(3) (a)
(Gs;sp 4)
name FN
MN LN
TpNo
hour
age
DOB
follow Course
CourseName
CourseID
employee
EmpN
o
3
(b) Copah;fSf;Fk; fw;if newpapw;Fkpilapyhd njhlh;G m:n MFk;
(Gs;sp 1)
(c) gq;fPl;L gz;G (Descriptive attribute)
Copah;fspd; Nrit Neuk; my;yJ fw;if newpahdJ Jizg; gz;G my;y. ,it cwTKiw
rhh;e;jit.
(Gs;sp 2)
(d) Employee (EmpNo, FN, MN, LN, DOB, Age)
TpNo (EmpNo, TelNo1, TelNo2)
Flow (EmpID, CourseID, hours)
Course (CourseID, CourseName)
(Gs;sp 3)
(4) (a)
epidtf tif
(Memory type)
gz;Gfs;
ngsjpf
msT
(Physical
size)
mZfy;
Neuk;
(Access
time)
mZfy; Ntfk;
(Access speed)
nfhs;ssT
(Capacity)
xU igw;Wf;fhd
fpuak;
(Cost per byte)
epidTg;gjpT
(Register) 1 1 5 1 5
tpiuT epidtfk;
(Cache Memory) 2 2 4 2 4
Jizj;
Njf;fq;fs;
(Secondary storage)
4 4 2 4 2
njhiy Jizj;
Njf;fq;fs; (Remote
secondary storage)
5 5 1 5 1
vOkhW mZfy;
epidtfk;
(Random Access
Memory)
3 3 3 3 3
(Gs;sp 0.2 x 20 = 4)
follow employee
course
employee
follow
course
do do
m n
m n
follow course emp
hours
4
(b) (i)
,af;ftpay; vOkhw;W mZfy; epidtfk;
(D-RAM)
epiyapay; vOkhw;W mZfy; epidtfk;
(S-RAM)
1.fsQ;rpag;gLj;jp itj;Js;s VjhtJ jftiy mbf;fb Gj;Jzh;T+l;l Ntz;Lk;.
,e; epidtfj;jpYs;s juTfs; mbf;fb Gj;Jzh;T+l;lg;gl khl;lhJ
2.Ntfk; Fiwe;jJ Ntfk; $baJ
3.tpiy Fiwe;jJ tpiy $baJ
(Gs;sp 1 x 2 = 2)
(ii) juT CLflj;jy; Ntfk; mjpfhpj;jy; my;yJ FWfpa Neuj;jpDs; juTfis CLflj;jy;.
(Gs;sp 1)
(c) (i) Create Table Student
(
Ad_NO Varchar(10) Not Null,
Std_name Varchar (50),
Grade Varchar (10),
Gender Varchar (7),
Primary Key (Ad_No));
)
(ii) insert into Student (Ad_No, Std_name, Grade, Gender)
Values (‘A005’,’Nimal’,’12 sc’,’male’);
(iii)Alter Table Student Add Tel-No Varchar (10);
(Gs;sp 1 x 3 = 3)