[ Code No. 7052 J For Scheme-/ & Scheme-// Ca11didates
Time : 2 Hours Cool-off time: 15 Minutes
[ Second Year - March 2015 ) Pati - III
COMPUTER APPLICATION (Commerce) Maximum : 60 Scores General Justructio11s to Candidate.,· : • There is a 'cool-off time' of 15 minutes in addition to the writing time of 2 hrs. • You are not allowed to w1ite your answers nor to discuss anything with others during the 'cool-off time'. • Use the 'cool-off time' to get familiar with questions and to plan your answers. • Read questions carefully before answering. • All questions are compulsory and only internal choice is allowed. • When you select a question, all the sub-questions must be answered from the same question itself. • Calculations, figures and graphs should be shO\vn in the answer sheet itself. • Malayalam version of the questions is also provided. • Give equations wherever necessary. • Electronic devices except non-programmable calculators are not allowed in the Examination Hall.
•
m1<3~1~ ffi)CllCDJrmID1m oJJ,O@Cll
15 Cll1m1g 'anlW 630n.C' 6)6)5o'
~6raOCDJ1a>1d)6)2,o.
m~
cruCllCDJcmID
CDJru1m1'2lo msanIDO(]ffiO oJOS1~.
e
~mm> ©67ID
•
n{j)~O (]!IJOBJi67IDW
e
63©6
~ oJ (] !1-l o B.:\ 67ID ~6 o
•
~mlID©@Cll!9J,
(]!IJOB.,\ffi
..a,GmtDG) anl 3EUJ, ..a,<.13,
(] !1-l o B.\ m cm @ 6) cm a>6> 6TO'ro')56o d)6)6ra cm o6TT).
!l-l1Llru ~rmmm (]oJ~o1m8
~6raOCDJ1©1<00Gmo.
•
(]!IJOBJi67IDW CllQJCDJO~rmID1EU6o mm8cfh1CDJ13J,ri.
•
~ru.:\'216 ~ cru.oEU cmID' cru Cll ruo an.,\ 67ID
•
(]LoJOL
@!IJ~omo..a,oml'l:f>
..a,om8d)6)2,(]EUgo6..a,®
631Pl6>anJ,~
E»a>6
mQJcfu(]LSOGmlah !?2oJan©GmQIJ,o oJ©°lcM:!OnD0~1m8 ~oJ(]
7052
1
P.T.O.
1.
Create an interface in VB for displaying a message "Welcome" when a user clicks a button. (Scores : 2)
2.
_____ is a VB interface where the controls are placed.
,., .)
.
(a)
Fonn
(b)
Property window
(c)
Toolbar
(d)
Project explorer window
(Score : 1)
Explain any two file system controls in VB.
(Scores: 2)
4.
Raju wants to create a login screen which is similar to windows login screen. Write down the controls needed in VB and the prope1iies that must be set for it. (Scores : 2)
5.
The VB control which allows the user to type in data.
6.
(a)
Combo Box
(b)
Text Box
(c)
Check Box
(d)
LabeL
(Score: 1)
Identify the following in VB : (i)
Double
(ii)
"Visual Basic"
(iii) A= 5 (iv) Dim Bas string
(Scores: 2)
7.
Design a VB application to find the sum of first Nodd numbers.
(Scores: 3)
8.
The maximum length of a VB variable name is _ _ _ characters.
7052
(a)
255
(b)
128
(c)
8
(d)
64
(Score: 1)
2
1.
63©6 user 63©6 button click 6).!l.Jc:g{;l,.!l..l~om~~
2.
4.
VB intedace create
Controls place
6>.!l..l
Fonn
(b)
Property window
(c)
Toolbar
(d)
Project explorer window
Windows-a:eJCID6
riJ()6TOlIDCID1moruCR>_,\12lO(J}) VB 5.
6.
6>.!l.J~~cfh.
message display ( cruccB.t:>cScru : 2)
VB interface omcmom> ?
(a)
mo~6ru1m
n.mcm
63(1)6
login
screen
controls-~o properties-~o
create
n.fil!96CID6cfh.
6).!l.Jc:g{6mo.
( crucc.&:JcScru : 2)
User-m data type 6>.!l..lffi60JB1c006CTn VB control oij3® '? (a)
Combo Box
(b)
Text Box
(c)
Check Box
(d)
Label
( cruCclb:J© : 1)
VB-<"03 CIDJ6)!9 riJ()(J));i,cmru n4)6)omm) OJ_,\a3CIDl2lOt006
Double
(ii)
"Visual Basic"
(iii) A== 5 (iv) Dim Bas string 7.
~B_,\6)
N odd nurnbers-6>CJ'A CIDJcfu
( cruccfh:J©cru : 2) cfu06mOm6~
VB application design 6).!l..lc:g{Jcfu. ( m>cc.&::>©cru : 3)
8.
7052
63(1)6 VB variable name-6)CJ'A maximum length _ _ _ (a)
255
(b)
128
(c)
8
(d)
64
~m>.
( mlCclb:J© : l) 3
P.T.O.
9.
The rollno and marks of students in a class are entered in the coITesponding elements of two distinct arrays 'rno' and 'marks'. Write the VB procedure to accept the roll no of a student and display his/her marks. (Scores : 3)
I 0.
Write the output of the following expression : (i)
ASC ("A")
(ii)
Lett ("Visual Basic", 6)
(Scores: 2) (Score: 1)
11.
The index of the first element of an array is - - - - -
1.2.
A database table book contains bookno. title, author and price. Design a VB application with the following facilities : (i)
Add new book to the table
(ii)
Modify existing details of a pm1icular book.
(Scores: 5)
(iii) Display books one by one. 13.
The file extension of MS-Access database is - - - (a) .FRM (b)
.MOB
(c)
.MS
(d)
.DAT
14.
(Score: 1) tag is used to place an inline image in an HTML.
(a)
SRC
(b)
IMG
(c)
ALT
(d)
HREF
(Score: 1) (Scores: 2)
15.
How will you create a Hyperlink in an HTML document'?
16.
Design an HTML fonn for accepting name, rollno and marks of three subjects of a (Scores : 3) student.
17.
Explain any two table attributes.
18.
XML stands for - - - -
7052
(Scores: 2) (Score: I) 4
9.
63a>J ~o~16>e.i ru1Bjodro)u:i1ca,~66>5 0<10u3 mm.Ja>Jo, :2lOdd}6')Jo ai61"'@ OJc\.!LlcnJrro1a>1d}6')J/IDJ. 63a>J ru1BjOdcmu:i1WJ6>5 0<1::>u8 mm.Jd accept 6>.!Ll~JOm.Jou3 amwo~J6>5
12lodc00 display
6>.!Ll~OmJ~
VB procedure n;J)!P6c3m) : 3)
10.
m>06>!P~<1WJcm expression-cfu~J6>5
(i)
ASC ("A")
(ii)
Left ("Visual Basic", 6) ~Bj6>
11.
6la>J [email protected]
12.
63<1>6 database table-ro3
output n4)!P.),
~6TD.
element-G>oR index _ _ _ _
!P~<1WJcm
( m)cclb:>© : 1)
data store 6>.!LlcnJ1d}6')6cm6,
bookno, title, author, price. m>06>!P~<1WJcmOJcnJd}6')6~
VB application design
(i)
Table-ro3 nJJm>lw book add
(ii)
m1e.iru1e.iJ~
13.
:
6>.!Ll~Jcfu.
63a>J book-6>oR details modify
(iii) Books 6loaaiocmow1 display
6>.!Ll~Jcfu
6>.!Ll~Jc:81.
6>.!Ll~Jcfu.
~6TD.
MS-Access database file-6>oR extension . (a)
.FRM
(b)
.MOB
(c)
.MS
(d)
.DAT
(a)
SRC
(b)
IMG
(c)
ALT
(d)
HREF
( m)ccJb:><'& : 1)
( m)ccfho© : 1) 6>.!Ll~&cmro)
15.
6l©J HTML document-ro3 n4)6m6>mwo6TD Hyperlink create
16.
63©.). student-6>oR name, rollno, marks of three subjects accept form design 6>.!Ll~.).cfu.
'? ( m)cclb:>@m) : 2)
6>!Ll~Om.).~
63©J HTML ( m)cclbo©m) : 3)
( m)cclb::>© : 1)
7052
5
P.T.O.
19.
Explain the applications of scripting language.
(Scores : 2)
20.
Explain different fact finding techniques.
(Sco1·es : 5)
OR
21.
What-is feasibility study'? Explain the three aspects in the feasibility study.
22.
is a chart listing all the logical conditions and actions.
(Scores: 5)
(Score : 1)
23.
Explain the advantages of DBMS over conventional file system.
(Scores: 5)
24.
Differentiate primary key and super key.
(Scores: 2)
25.
The result of the operation
26.
Explain different SQL data types.
()(department=
··sa1c<)employee) is _ _ __
(Score: 1)
(Scores : 5)
OR
27.
Write SQL for : (i)
Create a table with the following data : employee code, name. basic pay, department designation.
(ii)
List all employees in "purchase" department.
(iii) List name and designation of all employees with basic pay~ 20000.
28.
29.
7052
(iv)
List all engineers
(v)
List all managers in "Sales'' department.
(Scores : 5)
is a set of rules used for transferring files from one computer (or network) to another computer (or network). (a)
FTP
(b)
HTTP
(c)
TCP/IP
(d)
WAP
(Score: 1)
(Scores: 3)
Distinguish Bridge, Router, Gateway.
6
19.
Scripting language-6>oR applications rul(J()Bicfu@lc002cfu.
20.
rulrulw
21.
22.
Feasibility
study
nmcmoroS
n4)CTID::>m)
')
Feasibility
study-6>e.i
i2lJm5'
rulrulw
(m>ccB>omm> : 5)
®eJ6lffi6>~<;tjQ1
OJ1(J()B,cfu(1)1c00Jcfu.
___ logical
conditions-~o actions-~o
Conventional file system-roS mlm)
list 6>.!2..lcgiJcm chart
DBMS-mJ~
(m>ccB>:i© : t)
~m).
crurulcworftl
(m>ccB>omm> : 5) 24.
Primary key, super key nmcmlru ano@.!2..lCRlJ.cili.
26.
SQL-6>e.i ru1ru1w data types rul(J()Bicfu@lc00J,cfu.
(m>ccB>:imm> : 5)
amQ~m,larn
27.
!P<;tjOl!))J, cmrum>c002~ SQ L n4)!PJ, ®6cf), : (i)
!P<;tJOl!))Jcm data
~<1.!Cll!)):Jcnl~
63mJ table create 6>.!2..lCRlJcfu:
employee code. name. basic pay, department, designation (ii)
"Purchase" department-6>e.J
n©~p
employees-6>oR list display 6>.!2..lCRlJcfu.
(iii) Basic pay 20,000-Cll2l:J cmoan1ro3 cfuJSJ®CleJ:J name, designation nmcm1ru display 6>.!2..lcgiJcili. (iv)
n©~P
(v)
"Sales" department-6'>e.i
files transfer
29.
7052
n©~P
employees-6>oRl!))Jo
Engineers-6>ffil!))Jo display 6>.!2..lCRlJcfu.
~m)
28.
~!!))
nm~o
managers-6>ffil!))Jo display 6'>.!2..lCRlJcfu.
(cruccB>:>©cru : 5)
63(1)6 computer/network-roS m1m5' 12l6>Q:J@J computer/network-Cle.JmlcOO'
6>.!2..lCRlOffiJ~
set of rules-6'>m <1.IOl!))Jcm Cl<1.1©.
(a)
FTP
(b)
HTTP
(c)
TCP/IP
(d)
WAP
Bridge, Router, Gateway nmcm1rul!))J6>S OJ.,\®_\:JcnJ6ID3u3 n©!PJ®Jcili.
7
( cruccB>:>m : 1)