AHSEC HS 2nd Year Question Paper 2022 Computer Science and Applications

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'
qA Program
Pointer €it declare 9t{' initialize <R$t {l-F C++-s
h{t
@ Writc SQL to create a table named student with 4 fields namely
:

, 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 4 x 4 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'