II
Total number of pages - I
32T CSCA
2022
COMPUTER SCIENCE AND APPLICATIONS
( Theory )
Full Marks : 70
Pass Marks : 21
Time : Three hours
The figures in lhe ffiargin indicate full marks
for the questions.
Q. No. 7 corries 7 nnrk eoch 1x8 = 8
Q. No. 2 @rrics 2 nfirks eaclt 2x10 = 20
Q. No. 3 caries 3 nntks caih 3x9 = 27
Q. No. 4 ctrrbs 5 htorks each 5x3 = t5
Total = 70
Cotlhl.
1,. Answer the following : (any eight) 1x8:8
fr@tat wFFrEq<Ewml;
(n)
(b)
(c)
(d)
C++ -< 7R< datu type Vcm< <t t
k)
(J)
@)
3ZT CSCA t2t
(ln \4trat is SQL ?
SQLft ?
O 14/hat is a binary file ?
Binary file ft ?
0 Define constructor.
Constructor-R q(E} firll I
2. Answer the following questions : (at y tet ) 2x10=20
sEs, fi$ ffi q{S EE< ft$ z (ffi rEFt)
(a) What is function overloading ?
Function overloading ft I
(b) Define abstract class and concrete ciass.
Abstract class gf{. concrete class-{ I(@l fiTI I
(c) Define a destructor.
Desftuctor-< C(@t fr{ I
(d) State the commutative and associative law of Boolean algebra.
Boolean algebra-{ commutative gI{. associative law Bm{ ml t
32T CSCA t3l Cortttl.
(e) What is packet switching ?-
l'acket swrtchrng l<, ?
(fl Define Band#idth.
Bandwidth-< ri.el fd?n I
(&l State ftro qses of XML
xML-{ Iairdfi vm{ clt
(r) Define a Queue.
Queue-< ngt fi{ I
(i) Define a Stack.
Stack -< qiBt fr?fl I
0) State f.{,o advantages of LAN.
LAN -< tA IR{ b-Grl cll
(k) What is data transfer rate ?
Data transfer rate ft ?
(l) State the use of Karnaugh MaP.
Karnaugh Map -< {t<aF S6"l G1 I
(lr) What is a base class ?
Base class ft z
32T CSCA l4l
(r) Define Pointer.
fointer-< I."@l frfl I
3. Answer tny nite trom the fotlowing : 3x9=27
t6< i?rsrr4l?A o"r< €s< <t c
(r, Write briefly about the advantages of object oriented programming
language.
obiect oriented programming language -< 1R$rfl< u*s fr1n r
(17) State the Process of creating and writing text into a file'
.sBt file -s text create qf+ -ri1" 51 1qfufi1 B-e{ Gil I
(c) Differentiate 'pass by value'from'pass by reference''
'Pass by value' 9l{' 'pass by reference'-< "ndoJ fr{I I
(d) Write the codes in C"r+ to declare and initialize a Pointer'
Pointer €it declare 9t{' initialize <R$t {l-F C++-s qA Program
h{t
namely
Writc SQL to create a table named student with 4 fields
:
@
, SID, SNAME, ADDRESS and MARKS'
qEs frm fleta c{t rd sQL-< student aFK q{i table create GII 3
qT+ MARKS.
SID, SNAME, ADDRESS
cortul.
32T CSCA t51
(, Write the differences of Text file ard Binary fi1e.
Text file s{F[ Binary file-l tdol E<t r
6) What are the advantages of using SQL ?
sQL <I{qF eF 1frvE{{ fr ft r
(y' Explain the Push and POP operations on a stack.
Stack-( Push 9F. POP operations-< fr<m pft fr<n r
(r) Explain the process of selection sort with an example.
selecrion sort fhB< FrLT EtI{l.Ec pft fr"u r
(7) Explain the process of obtaining Sum of Product (SOP) using Truth
Table.
Truth Table <]T{< $R Sum of Product (SOp) F.ft €I rEifunF FTCI
1wftfi"<ttl
ft) Explain the aggregate functions of SQL.
, SQL-< aggregate 1rr.r61ion-T{< frTG {qR B{
(l) Explain tlree diftererLt types of network topologies.
Gfibt r<ot 6{Gttl network topologies-< Frr* fr$
(rr) Dilferentiate LAN from WAN.
LAN ql+ WAN-< {?fo, ft.fi
32T CSCA 16l \
(n) Write the advantages of Javir Script.
Java ftript < 1fumgfilIIt
4. Answer atty three from the following : 5x3=15
oq< frreteqt &fiDt s*r< Ee< q<tz
(a) Write a C++ Program to add two matrices of order 4 x 4.
ttt 4x4 clffs{ clt5rE EGwrtd c++ -s ebl program GFtl t
(b) Write a C++ program to impiement binary search in an array.
Array €i1s binary search eIlttt sR-<< (IK C++ -9 (bt program fr{l t
(c) Explain the concept of multiple inheritence'
MultiPle inheritence-:tr Flca 1u.E B"{tl r
. (d) Compare XML with HTML.
xML s HTML < dals Effi 61
k) Write briefly about DDL and DML with example'
DDL qFF DML_{ fiqCT h<q:{qu*o fi<tr
0 Write a C++ Program to delete an element from an array'
Anay 4BFI tf{l element qbt delete afrff g++ -v eBt program fr{ t
-x-
32T CSCA t7l
32T CSCA t8l 6'
