Page 2
SECOFM YEAR HIGHER SECOhII}ARY EXAMINATION
S * ir,tp ;l,Q;,;-e*Sr.:'-c,l,t E',fip{r'
COMPUTER APPLICATION
{coMMERCE)
Maximum:60 Scores Time : 2 Hours
Anslver any 5 questions from I to 6. Each correct ansrryer carries 1 score.
t a;rox* 6 rr:6)ra{rtgg c-qr3{3J66'Bg1c* *Socra'}erg" s ,,41qgraro'r')nY gro'oroo ,.$)v;or;a
533cCI3 coo.l gronnramml')mg" r miea:rd ofkol".
l.Write down the name of header file needed for using string functions in C++,
mils'l"0i .,ooud"urn3a00 enJcolSrnlaer;rmror'loi C++ G(.-Jrtora'lnil guilogsScoYocfie
o.oruld "ncolejloo$ clrd rnaf,a;a.
2. Pick the odd one out fronn the following.
a) HTML b) ALIGN c)HEAD dIBODY
i o !p e, ] 6'rnJ m ru tol'l ail flfl rrd ru.1 an miroa x$ (d' 6 ral ro6l Gyoyol sJ df4 e.
ro.r
1
a) HTML b) ALIGN cIHEAD d)BODY
3. Name the keyword used in JavaScript to declare a variable.
e rrurnlp1oje'lafr c rrio'lcumflgS aoa g rur'l gorb o .t:q 3rnJ*:eo: rrn'16$Jm
a"lcrurinri *Slv;ropa.
4. Write an example for FTP software.
FTP crrur"i'SoruolcfioY 6rCIJ ea3*flo6ftlo .$;v3rol34.
5. The number of rows in a relation is called
a ra; cfl c e.r.s rn'la e.r or ro'l a g J 6) s -0 ep rorcr1 am .,S)mY
',JoeDJmJ.
6. Write an example for open source ERP.
argerCI emr$mi ERP d6y 6toJ Oofnnoemo .g)v;rorJe.
:*
1 P.T.O
Page 3
Answer any 9 questions &om 7 ta l8- Each c*rrect answer carries 2 score.
z a3o'rtr* 1B nrcloorygg c_l:fsJffir3dl{d *$erorm'}e{* 9 *g}qgarmllr# gon*roo *$;v;roga
63JGof enCI"l gro'nnotaro'r''lrnJo 2 rnica:d rrilroio.
7. What is meant by type conversions? Write down its different types.
oasoi aerfrcrud.ucfr .slrmroJoa:end ecquo'ldoJrmoY *Slnd'r
ru1ru)urCIoo aerDocur0"umsaog &Jcild *$v;ror;a.
B. List down the type modifiers in C++.
c++ (il Agg oosa1" carm'l.,ncoro3ao0 dsgl o-eJqJe.
9. a) Define an array
b) Calculate the total bytes reserved for the array declaration given below
float a[10];
a) coJ GraGo m'larurrldCIJe..
b) e.{ojos oarsJroro'r1o1aerJcm croeooiaerrcofl rn'}oer'lrucoiaeiJrm oerenrgsaoD
&6md6)3d6'te.
float a[10];
10. Consider the C++ code segment given below
cout< <"Enter the name";
cin > > my_name;
cout< <'The entered name is"< <my_name;
a) What will be the output if we give an input as "Good Morning"?
b) What change has to be made in the code to get the same output for the
input "HSE EXAMINATION 2023"?
-s{ruos oarsSrororlo'laoJrm C++ carad ;o'l(/)ern'l6oJdJ
cout< <"Enter the name";
cin > > my_name;
cout< <'The entered name is"< <my_name;
a) "GOOD MORNING"*['ym gc'b*.r;S cnaf,a;ernnod at$.-.r;$ *$no'rrco:'lo'1aet3"z
b) *HSE EXAMINATION 2123'.$1rm gcD-.r;5 maf,a'lo:rail Gracto or$*.r3$
^Ornfr afeo oJoJorolcrno?
algSrmtoflaY carniflas
11. Give the name of C++ built-in functions required for following operations
a) convert'a' to 'A'
b) find the square root of 25
2 P.T.O
Page 4
-a{clr6s oelsJ(0t0'}o1oer3rm 6tltJco"urnJarcfraei crocu00JafcD c++ enfldfi
gc0 .od"urn;egJos c;rd *SlspJorJa
a) 'a' oe) 'A'Gr6ol') ,-ro'lrurtorolrno o-oJqJe.
b) zs oafl rurdga3uo aene;j)s1acr3rmor1r#.
12. Write any four attributes of <body> tag.
< bod y > s r to'.l or'$ *gorr*m'Ie{o 4 ror0 ts'}6ruJ3 Je gJ ss c *.lrd *$1 sr;ro'r; a .
13. Classify the following tags into container and empty.
<BR>, <HTML>, <H1>, <IMG>
ollslr CInn'.}o1d6'{rm sSmjeeg container, ernpty *$nn'}ermarn ffrr0ors'r'Jro'}G}gtrJo'Ue,.
<BR>, <HTML>, <H1>, <IMG>
14. Write an HTML code segment ta create the following list.
Storage Devices
A. Hard disk
B. CD
C. DVD
s.{ftt6}s aarsSm'rar1o'}eer3mr si}Sj m1{Aoalao;rmrol'}fl}}rlrmJese: HTML ce,:rui *S}e;o?e.
Storage Devices
A. Hard disk
B. CD
C. DVD
15. What are the advantages of writing JavaScript code inside the head section of
an HTML page?
s:rurmi1al*jfi e*,:a# HTML c,,.ra')on$ o*rrnd arnra,srn'la$ grrladsJmrotrmo't
6ldl ]6$ej gg tr'-.1c0) 3srn613rilr,r& .$;a co$ Io .
16. Differentiate primary key and foreign key.
oo1,:acfl d), c,,olcflcra a"l *grmlru rurmler3gg ruJro63fiuo *$)v;ro;a.
17. Specify the responsibilities of a DBA.
D BA ary o s eofin o ru :e'lfir)-Jdor ut ru; aro'ra ]6oJ e .
I
18. Write down the functions of mobile OS.
o a ) oo 6ru ail a r g co 91" cd *1 gU *1 o crfl ru rt m son sl u3 a
roT
S
^g;
3 P,T.O
Page 5
Answer an,y 9 questions from 19 to 29. Each corect answer carries 3 score"
I
rs a;rrnr* zg ruoo&{gg G-s.!r{3J6st3gjlr6 *gelcna'}erJo ^S}ffiroYoild e,orq,,rao *$}n;CIJa'.
6lrerof cmo'I gronneomflrnJo r rnie*,:*t ni}a,o.
19. Explain any three jump statements in C++.
c++ oe.t .Sonna'lelJo aJff6' smi cglq$oar0oSao0 rrilmrilaolocr;a.
20' Rewrite theliHffi:::';ilt whire roop
{
sum=suril*ii
)
-a{cuos oari;rolo'r1o1ael3rm carrui (o68ro while eti Qn-lccol) urlA a3g"l
*S1v3tol;a,.
for(int i= 1;iq=n;i++)
{
sum=suff}*i'
)
21. Write down the array declaration for the following
a) to store the scores of 50 students
b) to store the English letters
-o{ol6}s oarsJro"ro'r1o1acrJrm Groru@Jmrgoad6,raol'l ogg Graco n016co"scr}
.$;sr;o'r;4.
a) so oi'lr:.1rdro'rn1ag3as mieoyt cggrd o-a.rgJrmoiloi
b) g"ggl.d Ga6ruoroe00 cglqrrt o-r.rqJmol'lfiY
22. Predict the values of s1, s2 and s3 of the following code
int timesec(int h, int m=0, int s=0)
{
int sec-h*3600+ m*60+s;
return sec;
)
a) long s1 =timeSec(2, 10,40);
b) long s2=timeSec( 1,30) ;
c) long s3=tipleSec(3);
4 P.T.O
Page 6
-2{r}165 CIelsJoro}'lo'}aeiJrm ca:m'}efr s1, s2, s3 ^6)nn'lola)J6}s crilela0D
1*-rru-o-ilderJo
int timesec(int h,int m=0,int s=0)
t
int sec= h*3600+m*60+s ;
return sec;
)
a) long s1=timesec(2, LO,4A);
b) long s2=timesec(1,30);
c) Iong s3=timesec(3);
23. Explain different types of web hosting.
ru I oflooloo orueni e^n r gplo rnJec0 oilcne'laro1ao; a.
24. Wnte down the HTML entities for the following reserved characters
a) O b)& .)rM
-agoros oa:s3ro'nr'lolaeiSrm o'lrrudnYtri a3:*ads *3aEJ6)s HTML -S)fibg'}plaub
-$sr;ro3a.
a) @ b)& .)rM
25. Compare static and dynamic web pages.
6)ile"ld; erruenie,-.raJ&oeolJo 6lonumrald aruenYe*:EJeogo{o {alf{orCIoJo
6)-o.JqJe.
26. List out any 3 JavaScript events and their uses.
.,Serrlna'1e.{o 3 a}orf, rnytal.-id gruotoJ&SJo <rCIcr:G{os gft-icarlCIruJo *$v;ror;a
27. Name the components of SQL. Give examples for each.
SQL &ocn:f,clTlcrilo;ag;os c,-rrd *$n;ro;a. arcrornn'lrnJo eelanocrrlo rnaf,a3a.
28. What is ERP? State the relation between ERP and BPR.
ERp .'$rmroe.rnoYl ERP , BPR
^S'tmflru rolm1e.ggg crurftuo tarcrrirorrcrflaer;a.
29. Briefly explain thg cybercrimes against individuals.
ru.1 aror'l aod 66y c m o ro o;J gg 6,6) m ernr d eJ B eJ CIJ ec'nrfi rru o e,ril"iro a c nor'l ru ] ru o'l doJ e.
5 P.T.O
Page 7
Answsr anry 2 questians **m 30 to 32. Each correct ansurer carries 5 score.
30 aJ{m{d 32 r:-rc{oo{gg €-arscJ6tre€jln* *garoo'}e{o 2 *{)ffiroxlflni gro'rnoo
*SltrJoU&. aisr*l ceft"} gronromlaf'lrfiJo s micatd oilnno.
30. Write HTML statements for the following
a) To include checkbox in a form
b) To add the formula HzSO+
c) To create an e- mail hyperlink
d) To insert an irnage named 'rose.jpg'
e) To divide the page into two equal horizontal frames
rs] I s e ror mn'} ra'.} aeig rm ru csyei Gr$ ru teJ E 3G] HTM L c gq $ a a ort n3 a rr0 {) v3 ro3 a .
a) c :d} c* a-s: dd'c sru:drd g ub er g s3 toro'r; cm or'1 n{
"a
b ) H r S Oo *$)m c
^ardaga g oilsrgsJ orii1 rmff):lfiY
c ) g-a a efl {i* oa r6eild' rn1 d oa'} oeiS rm rrn"l rli
"n g
d)'rose"jpg' *$)rn gead gulogsgrom:Srmtor')rrY
e) orueni e*.;*'Jarn toJe:Jafan o6neJ to'loesilm ai*aor'lagorg:o:')
cr-il re e'l aer; rm ro:"] aY
31. Define database? List out its advantages.
ru:rgrcen'rmi cnldq-e.rldege? ronrorlarQ cmgea'nob ;gloogsJoroJo
32. Consider the following table'Employees' and write the output of the following
SQL queries
Emp Id Emp Name Designation Basicpay DA Gross Pay
101 Nayan Manager 1 5000 1000
102 Bhaska r Clerk 5000 250
103 Lekha Accountant 10000 500
L04 Meera Manager 1 5000 1000
105 Sachu Supervisor 12000 750
a. Update gross pay as the sum of basic pay and DA.
b. Select all details of Managers from the table.
c. Select the highest gross pay from the table.
d. Arrange the details of employees in ascending order of Basic Pay.
e. Delete the details of all clerks from the table
6 P.T.O
Page 8
rorf,oe rolnn1o1ao;rm 'Employees' csenilo0 *ro'loern'lgJ SQL a.rcflagSos eit$*{s
.S)v;ro;a.
Emp Id Emp Name Designation Basicpay DA Gross Pay
101 Nayan Manager 15000 1000
102 Bhaskar Clerk 5000 250
103 Lekha Accountant 10000 500
104 Meera Manager 1 5000 1000
105 Sachu Supervisor 12000 75A
a. eenrrmflai'c*-ror36sa{o m"loo: olJoscuJo {oJe O,ilceoSung elcnrmi c*.r *$;rm
".o"laf,n
d rsn..icruJ$ osrq;ar.
b. atern*riaro;ers a3v3ruo0 ojlcuoc'ng;o €Jt,oJarasrmror"lmJgg cg1;Soac0ti
^$;v3o;a.
c. csenildlail rn'lrm;o .OBruJ" a3s1o c1o:mi €.Lr orruerdS CIdqJe.
d. .$)oc.grcofla€Jos oiloae:ocoeono0 genrrrru1ai' G,Lrol,os Grgcof,.,rrem 1aarotorloi
1aeflao'ldoJ&.
e. e senilgjlaf, rn'lcm;o *$H3 grdaeYCIf oJoscn:Jo r:-ilcoe rocoeanoD *lnild
o_ilgJe.
7