CA PE II Question Papers Group II

Information Technology November 2006

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 system along with the working notes: 5×1=5
(i) (1357)10 = ()2 (0)
(ii) (1463)10 = ()8 (0)
(iii) (101101110)2 = ()16 (0)
(iv) (573)8 = ()16 (0)
(v) (1100100110)2 = ()8 (0)
(b) Describe briefly, the following terms with reference to Information Technology: 5×1=5
(i) Interpreter (0)
(ii) stored Program Concept (0)
(iii) Toggle (0)
(iv) Object Program (0)
(v) Router (0)
(c) Give one or two uses for each of the following: 5×1=5
(i) Use of MACROS (0)
(ii) Use of BIOS (0)
(iii) Use of Parallel Ports (0)
(iv) Use of Web Browser (0)
(v) Use of Repeaters (0)
(d) Write True or False for each of the following: 5×1=5
(i) Compiler is one of the hardware devices in a computer. (0)
(ii) The Address BUS is a set of wires that connects the CPU and RAM and carries the memory address. (0)
(iii) The F2 key is used to edit the formula cell in a spreadsheet. (0)
(iv) A spooling software is used to compensate the speed difference between the computer and its peripheral devices. (0)
2. Distinguish between the following. Answer any four 4×5=20
(i) Cache memory and ROM (0)
(ii) On line system and Batch processing (0)
(iii) Ring Network and Star Network (0)
(iv) Analog computer and Digital computer (0)
(v) Network–attached storage and Direct–attached storage (0)
3. (a) Describe various factors which determine the best file organization for an application. 5 (0)
(b) Describe the various types of data communication modes. 5 (0)
(c) An electric supply company charges the following rates for its domestic consumers:
No. of units consumed Charges/unit
(Rs.)
For the first 200 units 1.60
For the next 300 units 2.10
Over 500 units 3.90
Surcharge @ 20% of the bill is to be added to the charges.
Draw a Flow chart for the above, which will read the consumer number and the number of units consumed and print out the total charges with the consumer number and the units consumed.

10 (0)
4. (a) What are the important decisions which influence the physical design of a Database? Explain. 5 (0)
(b) Describe briefly the various features of Data centres. 5 (0)
(c) Explain the benefits offered by electronic commerce application and implementation. 10 (0)
5. (a) Explain the concept of mail merge used in MS–WORD. 5 (0)
(b) Explain the various types of decision tables. 5 (0)
(c) Explain briefly the various tools offered by MS–WORD for efficient writing. 5 (0)
(d) Define the following functions used in MS–EXCEL: 5×1=5
(i) DMAX (0)
(ii) VAR (0)
(iii) SUM (0)
(iv) INT (0)
(v) FV (0)
6. (a) Explain the duties of Certifying Authorities under Section 30 of Information Technology Act. 5 (0)
(b) Write down the typical steps in using audit package 5 (0)
(c) Describe the salient features of EX.NGN accounting package. 5 (0)
(d) What do you mean by object–oriented programming? Explain its advantages. 5 (0)
7. Write short notes on the following. Answer any four 5×4=20
(i) WORM Disks (0)
(ii) Bar Code Reader (0)
(iii) Web Casting (0)
(iv) World Wide Web (0)
(v) Digital Signature (0)