CA PE II Question papers Group II

 Information Technology May 2004

This Paper has 47 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) (246.125)10 = ()2 (0)
(ii) (101101.1011)2 = ()10 (0)
(iii) (426.5)10 = ()8 (0)
(iv) (A2B4)16 = ()10 (0)
(v) (7654)8 = ()16 (0)
(b) Describe briefly, the following terms with reference to Information Technology: 5×1=5
(i) Accumulator (0)
(ii) Data Independence (0)
(iii) ASCII Code (0)
(iv) Client (0)
(v) PPP (0)
(c) Give one or two reasons for each of the following: 5×1=5
(i) Use of USB connector (0)
(ii) Use of Video RAM (0)
(iii) Need of FAT (0)
(iv) Use of File pointer (0)
(v) Need of hub in a network. (0)
(d) Write True or False for each of the following: 5×1=5
(i) One MB represents 1000KB. (0)
(ii) Every formula written in MS-EXCEL has to begin with a dollar ($) sign. (0)
(iii) Cache memory acts as temporary memory and boosts processing power significantly. (0)
(iv) A modern provides the connection between server and work station. (0)
(v) A spooling software is used to compensate the speed difference between the computer and its peripheral devices. (0)
2. Distinguish between the following: 5×4=20
(i) Control unit and Arithmetic/logic unit. (0)
(ii) Impact printer and Non–impact printer. (0)
(iii) Compiler and interpreter. (0)
(iv) System software and Application software. (0)
(v) Horizontal partitioning and vertical partitioning (with reference to database). (0)
3. (a) Describe the various factors which determine the storage capacity of a magnetic disk. 5 (0)
(b) Explain the various components of a decision support system. 5 (0)
(c) A company ABC Ltd. is engaged in selling consumer goods to different categories of customers. In order to increase its sales, different types of discounts are offered to customers. The policy of discount is as given below:
(i) On cooking range, a discount of 12 percent is allowed to dealers and 9 percent to retailers irrespective of the value of the order.
(ii) A discount of 12 percent is allowed on washing machine irrespective of the category of customer and the value of the order.
(iii) On decorative products, dealers are allowed a discount of 20 percent provided that the value of the order is Rs. 10,000 and above. Retailers are allowed a discount of 10 percent irrespective of the value of the order.
Draw a flow chart to calculate the discount for the above policy.

10 (0)
4. (a) Discuss the various data transmission techniques used in computer network. 5 (0)
(b) What are the important decisions which influence the physical design of a database? Explain. 5 (0)
(c) What is an expert system? Explain the various elements of an expert system. Also write its advantages. 10 (0)
5. (a) Explain briefly, the various tools offered by MS–WORD for efficient writing. 5 (0)
(b) Discuss the important features of MS–POWER POINT. 5 (0)
(c) Describe the various types of charts which can be created through MS–EXCEL. 5 (0)
(d) Define the following functions used in MS–EXCEL: 5×1=5
(i) DMAX (0)
(ii) RATE (0)
(iii) ABS (0)
(iv) PPMT (0)
(v) VAR (0)
6. (a) What do you understand by Local Area Network? Describe its basic components. 5 (0)
(b) Explain the duties of certifying authority in respect of digital signature. 5 (0)
(c) What major steps are required to be undertaken by the auditor prior to implementation of a CAAT? Explain. 5 (0)
(d) What do you mean by object oriented programming? Explain its advantages. 5 (0)
7. Write short notes on the following: 4×5=20
(i) Tele Conferencing (0)
(ii) Windows NT (0)
(iii) Web Casting (0)