CA PE II Question Papers Group II
Information Technology November 2004
This Paper has 42 answerable questions with 0 answered.
Total No. of Questions—7]
Time Allowed : 3 Hours
Maximum Marks : 100
Answers to questions are to be given only in English except in the cases of candidates who have opted for Hindi medium. If a candidate who has not opted for Hindi medium, answers in Hindi, his answers in Hindi will not be valued.
Question No.1 is compulsory
Answer any four from the rest
Marks
1. (a) Convert the following from one number system to another number system along with the working notes: 5×1=5
(i) (765.625)10 = ()2 (0)
(ii) (11011010.1101)2 = ()10 (0)
(iii) (9876)10 = ()8 (0)
(iv) (7654)8 = ()16 (0)
(v) (AD5)16 = ()10 (0)
(b) Describe briefly, the following terms with reference to Information Technology: 5×1=5
(i) Access time (0)
(ii) Buffer (0)
(iii) Multiplexer (0)
(iv) HTML (0)
(v) CMOS (0)
(c) Give one or two reasons for each of the following: 5×1=5
(i) Use of Cache memory (0)
(ii) Use of Parallel port (0)
(iii) Use of gateway in Computer network (0)
(iv) Use of Auto Text feature in MS WORD (0)
(v) Need of Diagnostic Routine in System Software. (0)
2. Distinguish between the following: 5×4=20
(i) Semi–conductor memory and Bubble memory (0)
(ii) Online system and Real time system. (0)
(iii) Client–server architecture and Peer to Peer architecture. (0)
(iv) Ring network and Star network. (0)
(v) Intranet and Extranet. (0)
3. (a) Explain the different steps involved in Image processing. 5 (0)
(b) What do you mean by Structured Querry Language (SQL)? Explain its utility in databasemanagement. 5 (0)
(c) A bicycle shop in a city hires bicycles by the day at different rates for different models as given below:
Model No. Hire rate per day
Model No.1 Rs. 10
Model No.2 Rs. 9
Model No.3 Rs. 8
Model No.4 Rs. 7
In order to attract customers, the shopkeeper gives a discount of 15 percent to all those customers, who hire a bicycle for more than one week period. Further to attract womencustomer he gives additional discount of 10 percent irrespective of hire period. For every bicycle hired a security deposit of Rs. 25 must be paid.
Draw a flow chart to print out the details of each customer such as name of customer, bicycle model number, number of days a bicycle is hired for, hire charges, discount and total charges including deposits.
10 (0)
4. (a) Briefly explain various types of communication services used to transmit data in a network. 5 (0)
(b) Explain the different types of payment systems in E–commerce 5 (0)
(c) Discuss the various components of database environment. 10 (0)
5. (a) Explain the concept of mail merge used in MS WORD. 5 (0)
(b) Briefly describe about the different views of slide offered by Power Point to create a better presentation. 5 (0)
(c) What do you mean by Direct Data Entry (DDE) system? Give a brief description of Optical Character Reader. 5 (0)
(d) Define the following functions used in MS–EXCEL: 5×1=5
(i) SUM (0)
(ii) COUNT (0)
(iii) PMT (0)
(iv) FV (0)
(v) INT (0)
6. (a) What do you mean by generalized audit package? Write down the typical steps in using audit package. 5 (0)
(b) Explain the various matters on which central government can make rules under Section 87 of Information Technology Act. 5 (0)
(c) Describe the salient feature of EX.NGN accounting package. 5 (0)
(d) Explain the chief uses of internet 5 (0)
7. Write short notes on the following: 4×5=20
(i) Program Library Management system (0)
(ii) Computer Output Microfilm (COM) (0)
(iii) Graphical User Interface (GUI) (0)
(iv) Distributed Database. (0)