The Institute of Chartered Financial Analysts of India University 2005 PE- II Information Technology - Question Paper

Roll No.....................

Total No. of Questions7 ] Time Allowed 3 Hours

Marks

(a) Convert the following from one number system to another system along with 1x5=5 the working notes:

) io ) 2 ) 16 ) 2 ) 16

lowing terms with reference to Information Technology: 1x5=5

CS

(c)    Give one or two reasons for each of the following:

(i)    Use of Modem

(ii)    Use of Graph Plotter

(iii)    Use of Subroutine

(iv)    Use of Operating System

(v)    Need of Protocol Converters.

(d)    Write True or False for each of the following:

(i)    Digital computer process data input in a continuous form.

(ii)    Each side of DVD can hold upto 4.7 GB data.

(iii)    Speed of Non-Impact Printers is measured in LPM.

(iv)    Microcomputer are based on RISC architecture.

(v)    E.X.NGN offers 72 basic reports in accounting.

2.    Distinguish between the following:

(i)    DDL and DML

(ii)    Dumb Terminal and Intelligent Terminal

(iii)    LAN and WAN

(iv)    Computer Aided Design (CAD)/Computer Aided Manufacturing (CAM)

(v)    Sequential File Organization and Random File Organization.

3.    (a) Define an Expert System. Explain its benefits.

(b) What are the constituents of Data Centre?

CS

(c) A water distribution company has two categories of consumers (Domestic 10 and Commercial).

The charges of water per unit consumed by these consumers are Rs. 5.00 and Rs. 8.00 respectively. The computer database of the company has the following information:

-    Consumer's name

-    Category

-    Units consumed

-    Bill date

-    Date of payment.

The company processes bills according to the following criterion.

If the consumer is domestic and pays his bill within 10 days of the bill date,

7% discount is given. If he pays the bill within 15 days, no discount is given. If he makes the payment after 15 days of the bill date, 10% surcharge is levied. For commercial consumers, corresponding percentages be 15%, 0% and 15% respectively.

4.    (a) Explain the various functions of communications software.    5

(b)    Explain any five communication interface devices.    5

(c)    Discuss the several integrity control that DBMS has to support.    10

5.    (a) Explain "Decision table". Explain in brief four parts of decision table.    5

(b)    Describe any five formatting features available in MD-WORD.    5

(c)    Define the following functions with respect to MS-EXCEL:    1x5=5

(i)    STDEV

(ii)    TRANC

(iii)    SQRT

(iv)    LN

(v)    PV.

(d)    Explain any five features offered by e-mail software.    5

6.    (a) Explain white box approach for Auditing.    5

(b)    Explain in brief the advantages of Optical Character Reader.    5

(c)    Explain the various matters on which power of controller can make rules    5 under Section 89 of Information Technology Act.

(d)    What are the different OLE automation support provided by E.X.NGN    5 software?

7.    Write short notes on the following:    5x4=20

(i)    Parallel Processing

(ii)    IT Act, 2000

(iii)    Extranet

(iv)    Video Conferencing.

CS

You are here: PAPER The Institute of Chartered Financial Analysts of India University 2005 PE- II Information Technology - Question Paper

•  
• Top

• Skip to content