Full Text Transcript
...
'-
IPS- II
MA'1
2ft" GROUP.IIPA13sR:§
Roll No ,........................
.INfORMATJJi~~UiBtBiH
fl
Total No. of Questions-51 [Total No. of Printed Pages-6
4
..
Time Allowed-3 Hours Maximum Marks-IDD
OCM
Answers to questions are to be given only in English except in the case of candidates
who have opted for Hindi medium. If a candidate who has not opted for Hindi
medium, his answers in Hindi will not be valued.
Attempt all questions.
Marks
1. (a) Define the following functions used in MS-Excel : 5
(i) ABS (x)
(ii) LN (x)
(iii) RAND
(iv) MAX (Range)
(v) AVG (Range).
(b) Describe briefly, the following terms w.r.t. IT : 5
(i) Boot Record
(H) Gateway
(Hi) Virus
(iv) Packet Switching
(v) Indexed File Organisation.
OCM P.T.O.
;?
{2 )
OCM Marks
,"".
(c)' Give one or more reasons of use for the following: 5
(i) DDE devices ...
Oi) Cache Memory
(iii) Protocol Translator
(iv) Linked list
(v) Bridges.
\ 5
(d) Wr,ite True or .False for each of the followin~
(i) During data processing, in a computer system, the actual execution of
the instructions takes place in the hard disk.
(ii) MS-Power Point is presentation graphics software for slide, overhead
projector and multimedia applications.
(iii) Video Controller is an intermediary device between CPU and VDU.
(iv) Hub is a device or, in some cases, software in a computer, that determines
the next network point to which a packet should be forwarded toward its
destination.
(v) Once the data has been written onto the CD-ROM, it can qnly be read,
not be updated or change~.
2. Distinguish . between the following: 4x5=20
(a) File Volatility and File Activity
a
(b) Cent'ralised processing and distributed processing
(c) MODEM and Multiplexer
(d) Syntax apd Semantics
(e) Data definition language and Data Manipulation language.
3. (a) What is Firewall? Can it prevent a virus frqm entering the system? What 5
steps must be taken to prevent virus from infecting a Computer system?
(b) What is Database? Explain atleast three key decisions which are required to 5
design a physical database.
OCM
I
,.
~
"-
(3 )
OCM Marks
(c) (i) What is the use of drawing program Flow chart? 2x2=4
(ii) Content of variable A is 10. What will be its content after execution of ~
statement A = A-5.
(d) For the purpose of selling its products to different categories of Customers, 6
a Company has segregated its products in Class A and B categories. Company
offers discount to its customers against the following discount policy:
(i) On class A items, a discount of 10% is allowed to wholesalers and 8% to
retailers.
..
(ii) Discount of 12% is allowed on all class B items irrespective of the class
of customers.
Draw the Flow Chart to print customer name, discount applicable for 3 customers.
Please note that customer can purchase only one class of items.
4. (a) Explain briefly the functions performed by Communication software. 5
"
(b) ~Define an operating system and discuss its various functions. 5
(c) Define the scope of Information Technology Act, 2000. 5
(d) Explain 5 basic features offered bye-mail software. 5
I
5. Write short notes on the following: 5x4=20
(a) e-commerce
I
(b) Smart Card System
(c) White Box app/oach for an audit
(d) Program Library Management System.
'I
OCM P.T.O.
)
( 4)
OCM Marks
(Hindi Version)
t m ~
~ ~ -4m ~ ~
TI 11d&nf~ coT~1~ct1~r~-'QI.~iRT ~&m "%IT ~ I ..
em 11da:nm~ iRT ~&m ~ "%IT~,
<1fu:
iRT -4~ ~ ~,
..
~ m
-aT~ iRT -4 ~ ~ ~ Cf)f ~~ict11 I
~~~~I
1. (31) MS-Excel -4 ~ r1~r(1r~d ~ (Functions) coT'1ft~ ~ : 5
(i) ABS (x)
(ii) LN (x)
(iii) RAND
(iv) MAX (Range)
(v) AVG (Range).
(6f) ~ ~l:.Ilfllct1(1Information Technology) ~ *<4 if r1~r~r(gd ~I<IJC\ICcf<n111~ 5'
~~:
(i) ~ ftcnrt (Boot Record)
(ii) ~ (Gate ways)
(iii) ~ (Virus)
~
(iv) rtel r..,j4I (Packet Switching)
~
(v) ~ ~ (Indexed File Organisation).
(~) r1~r~r~d coT~ -4 ffi ~ ~ <rr31f~ CfiRUfT~ : 5
(i) m~ ~ m m ~ dljct1~U(DIDEdevices)
~
(ii) oTIi <rr (Cache)
(iii) ~IG"'Ict1I<c:.;1(i*i~G~(Protocol Translator)
(iv) fujq;s ~ (Linked list)
(v) ~ (Bridges).
OCM
M-
-....
III
... I,
l..-
(5)
OCM Marks
(~) r1I-jr~r~\1~ iti ~ ~ <:fT~ (TrueorFalse) ~ 5
:
.
~
(i) ct>~c.'" "B~ !>IT~a.j~it1i ~ ~Jlnstruction's) en) (Execution)mi. ..
~"B~~.~I I
(ii) M.S. 'Power Point o/;ill.tc.~~""~, 3.iICl"'~-5, \.I1~ctc.'"Cf~ +i~I+ilr-5~1 iti ~
~~~~I
~ ~
~ ~ ~
(iii) ~'I-R (CPU)Cf~~T (VDU) iti
rClr-5'4l ch<;(I~'"
~ Cfi1~Lfct>"'U;'~I
I
~ ~
(iv) ~ (HUB) ~ <:fT o/;ill.tc.~~{ ~ ~ fq) ~ en)31'R~ - dCf)~-:qR iti
~ ~ "BWTffi ~ ~\1~I\11,~ I
(v) ~ (Data) ~ ~ qn:CD-ROM 'R fffisITTf7TcIIT~ ~ ~T~ ~ I ~
~ -;:ffi~f ~ I
2. r1I-jf~r~\1"B ~ o/;i+i~I~~: 4x5=20
(i) ~ Cfft Lfn.Cld1:{n~\1(1File Volality) Cf~ ~ Tffufqf~ (File Activity)
(ii)ifG"'~I~\]"-5 \.IT~r~~1Cf~:rrr~'~'<J~c.-5 \.IT~r~~1
~
(iii) Cf~ +i<:c.~1CRP:
.
(iv) ft:pRCffiCf~ o/;il~r.~cm
/
(v) ~ ~F~'~:{11~~ Cf~ ~ ~.n~~:{11~ I
1
3. (31) Lf11~"'ClI<c:p1:n ~? cp:n~ cwm:r (Virus) en) ct>~c.'" "B ~ it "itcf1~ ~ I ~ 5
en) cn~c.'" "B ~ it ~ iti ~ cp:n~ fq)it ~ ~ ~?
I
I
(-q) -51c.I~o/ , ;cip:n ~? -51c.I~o/;i *T r-5~1~1 m iti ~ Cfili-it-Cfili cfAetA it Ruf<:~r mit? 5
\
I
~?
('B) (i) >ffirp:J LK11'C1ltCfi1cp:n W'R' 7 2x2=4
(ii) ~ A em l1R 1a ~ I A =A-5 ~z4'G Execute m iti ~ A emcpnl1T1
ifrn I
OCM p.T.a.
""""'
.
~
r ~.
;RIff ..,..I
( 6 )
OCM Marks
(~) 3:r:RT~ ffi it1 ~ ~ ~ ~ w:R~ <itcD 'qTTTiff ~ t IcD 'I1P1A 6
"ij~ B ~ I w:R ~ it1~ ~ ~ r$W>ld.-c. ljTrC1~1 ~ t I r$W>ld.-c. ljTrC1~.n 4
~~tl
(i) A 'I1P1it1 ~ iR QIC1~C1\\<it~ 10% r$W>ld.-c."ij~ ~ cxwml <it 8%
~
r$W>ld.-c. I
~ ~
(ii) B 'I1P1it1 ~ iR 12% r$W>ld.-c. I
~ ljTrC1~<1it 'I:ZfRif ~ ~lJ:~1-q12:~ ~ q,\-C.I-!\CfiT1fli"ij~ r$W>ld.-c.~
~, -q"ijJ ~ I"% ~1-q12: cfR q,\-C.I-!i\t1~ iRT ~ I~ 'I:ZfR~ ~ ~
t ~
~ m 'I1P1it1 item q,\-C.I-!\ ~ ~ I
~ 5
4. (31) M~ r'iGljl~'i ~'qlJT "ffi"CR~71l:(Functions of Communication Software)
«I-!~I~~I
t
(Gf) ~Tlj~r~11 ~ <FIT ? ~ ~ Cf)flf ~ I 5
("B) ~ >l1'tj1~1q:,131f~, 2000CfiT ~ ~ I 5
(~) ~-~ ~m it1~ ~a:rur(Functions) ~I-!~I~~I 5
...
5. r'i~rC1r\5jdiR maJC<lrc.U-Jrul<~.Ji : 4x5=20-
~
~~m ~ (e-commerce)
(i)
~..
(ii) BTIi ~ (Smart Card System)
(iii) q,~c.\ it1l1T'tZf11it ~a:rur (White Box approach for an audit)
(iv) W1l1~«1q,IC1<.J~~ ~ I
,
OCM