CA PE II Question Papers Group II Information Technology November 2002
CA PE II Question Papers Group II
Information Technology November 2002
This Paper has 50 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
1. (a) Convert the following from one number system to another number system along with the working notes: 5×1=5
(i) (334.625)10 = ()2 (0)
(ii) (1101101.0101)2 = ()10 (0)
(iii) (7523)8 = ()16 (0)
(iv) (15AE)16 = ()10 (0)
(v) (238.5)10 = ()8 (0)
(b) Describe briefly, the following terms with reference to Information Technology: 5×1=5
(i) The data bus (0)
(ii) Intelligent terminal (0)
(iii) Overlay (0)
(iv) Packet switching (0)
(v) FTP (0)
(c) Give one or two reasons for each of the following: 5×1=5
(i) The presence of parity bit in the Coding system. (0)
(ii) Integrated circuits are used for primary memory and not for secondary storage. (0)
(iii) Use of Multiplexer in data communication (0)
(iv) Disk formatting (0)
(v) Preference of relational database model with comparison to hierarchical database model. (0)
(d) Write True or False for each of the following: 5×1=5
(i) In CD ROM drive, the read/write head touches the surface of the disk. (0)
(ii) Formatting of numbers in Excel 2000 in similar to formatting in WORD 2000 (0)
(iii) In MS–WORD, if the font size is 10 points and the line spacing is set to 1.5, then line spacing will be approximately 15 points. (0)
(iv) DOS based software cannot be executed on WINDOWS 95/98 (0)
(v) A graph created in Excel can be copied and linked to a power point presentation slide. (0)
2. Distinguish between the following: 5×4=20
(i) Dynamic RAM and Static RAM (0)
(ii) Local area network and Wide area network (0)
(iii) Voice synthesizer system and Voice recognition system (0)
(iv) Audit around computer and Audit through the computer (0)
(v) The Internet and the Intranet (0)
3. (a) Explain Database Management Systems (DBMS).Why does it being preferred with comparison to Traditional File Processing Systems. 6 (0)
(b) A moving arm disk – storage device has the following specifications:
No. of tracks per recording surface = 200
Track storage capacity = 62,500 bits
Disk rotation speed = 2,400 rev./minute
Estimate the average latency and the data transfer rate of this device.
(c) An insurance company follow the following rules:
(i) If a person’s health is goods and age in between 20 and 40 years and lives in a city and sex is male, then the premium is Rs. 20 per thousand and he will be insured for maximum amount of Rs. 10.0 lakhs
(ii) If a person satisfies all the above conditions, except that sex is female, then the premium is Rs. 15 per thousand and maximum insured sum will be Rs. 15.0 lakhs
(iii) If a person’s health is poor and age is between 20 and 40 years, but lives in a village. For a male sex, premium is Rs. 50 per thousand and maximum insured sum is Rs. 1.0 lakh only.
(iv) In all other cases, the person is not to be insured.
Draw a flow chart to find the eligibility of a person to be insured, premium rate and maximum amount of Insurance.
4. (a) Discuss the role of Internet in the development of e–commerce. Describe the benefits of e–commerce. 10 (0)
(b) A wholesaler has three commodities to sell and has three types of customers. The discount is given as per following rules:
(i) For Govt. orders, 15% discount is given irrespective of the value of the order
(ii) For orders of more than Rs. 20,000, an agent gets a discount of 20% and the retailer 15% respectively.
(iii) For orders of value between Rs.10,000 and Rs. 20,000, agent gets discount 15% and the retailer gets 10%
(iv) For order of value less than Rs. 10,000 the agent and retailer get discount 10% and 5% respectively.
The above rules do not apply to furniture items. However, in case of furniture items, a flat rate of 10% discount is admissible to all type of customers.
Prepare a limited entry decision table.
5. (a) Briefly describe the procedure of document imaging. Write the advantages of Image Processing System. 5 (0)
(b) Briefly explain the concept of Mail merge. 5 (0)
(c) Define the following financial functions used in MS–Excel 5×1=5
(i) DB (0)
(ii) FV (0)
(iii) NPV (0)
(iv) PMT (0)
(v) IRR (0)
(d) Define the following terms related to MS – WORD 5×1=5
(i) Fonts (0)
(ii) Drop Cap (0)
(iii) Header (0)
(iv) Section (0)
(v) Text Wrapping (0)
6. (a) What is a Computer network? Describe the various networking architectures 5 (0)
(b) What tools are available to protect the information in network against intrusion or misuse? Discuss. 5 (0)
(c) Describe the procedure to perform Computer Assisted Auditing using generalised audit package. 5 (0)
(d) Describe the various facilities to be provided by the user friendly accounting software package. 5 (0)
7. Write short notes on the following: 4×5=20
(i) Program Library Management System (0)
(ii) Expert Systems (0)
(iii) Storage Area Network (SAN) (0)
(iv) Computer Crimes and Penalty in IT Act, 2000 (0)