CA PE II Question Papers Group II
Information Technology November 2003
This Paper has 51 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 questions 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) (101101.011)2 = ()10 (0)
(ii) (99.8125)2 = ()2 (0)
(iii) (B2C)16 = ()10 (0)
(iv) (2E7)16 = ()8 (0)
(v) (2508)10 = ()8 (0)
(b) Describe briefly, the following terms with reference to Information Technology: 5×1=5
(i) Asynchronous Transmission (0)
(ii) Secure System (0)
(iii) Stored Program Concept (0)
(iv) Bandwidth (0)
(v) Web Browser. (0)
(c) Give one or two reasons for each of the following: 5×1=5
(i) Use of Firewall in the system. (0)
(ii) Need for Boot record. (0)
(iii) Need for Macro in spreadsheet. (0)
(iv) Use of RS–232C port. (0)
(v) Importance of Firmware. (0)
(d) Write True or False for each of the following: 5×1=5
(i) Thermal printer is an impact printer. (0)
(ii) Time required to position the movable read/write head over the desired track is termed as seek time. (0)
(iii) In worksheet the cell 65231 to 256th column will be referred as IV 65231. (0)
(iv) In word processing package, Header and Footer can be selected from the VIEW menu. (0)
(v) In MS–POWER POINT, changes can be made on the individual slide without making changes in the slide master. (0)
2. Distinguish between the following: 5×4=20
(i) Data Bus and Address Bus. RAM (0)
(ii) Transaction File and Master File. (0)
(iii) Work Station and Micro–computer. (0)
(iv) Centralized Processing and Distributed Processing. (0)
(v) PROM and EPROM. (0)
3. (a) Define an Operating System and discuss its various functions. 5 (0)
(b) Describe the main functions performed by the Database Administrator. 5 (0)
(c) A bank accepts fixed deposit for a year or more and the policy on interest rate is as follows:
(i) If a deposit is less than Rs. 10,000 and for two or more years, the interest rate is 5% compounded annually.
(ii) If a deposit is Rs. 10,000 or more, but less than Rs. 50,000 and for two or more years, the interest rate is 7% compound annually.
(iii) If the deposit is Rs. 50,000 or more and is for one year or more the interest rate is 8% compounded annually.
(iv) On all deposits for five years or more interest rate is 10% compounded annually.
(v) On all other deposits not covered by the above conditions, the interest rate is 3%.
(vi) If the customer is holder of any type of account for last five years, an additional 1% interest is allowed.
Draw a flow chart to obtain the money in customer’s account and interest credited at the time of withdrawal.
10 (0)
4. (a) Explain various features offered by e–mail software. 5 (0)
(b) Describe the various factors which have contributed to the growth of Local Area Network (LAN). 5 (0)
(c) Discuss the several integrity controls that DBMS package supports. 10 (0)
5. (a) Communication software is an essential requirement of Data Communication system. Explain the various functions of this Data Communication Software. 5 (0)
(b) Describe any five formatting features available in MS–WORD. 5 (0)
(c) Define the following terms related to office productivity tools: 5×1=5
(i) PV (0)
(ii) LEN (0)
(iii) SQRT (0)
(iv) Goal Seek (0)
(v) Thesaurus (0)
(d) Define the following functions with respect to spreadsheet package: 5×1=5
(i) COUNT (range) (0)
(ii) STD (range) (0)
(iii) MOD (x/y) (0)
(iv) INT (x) (0)
(v) ROUND (x, n) (0)
6. (a) Explain Electronic Data Interchange (EDI) and its advantages. 5 (0)
(b) Explain the concept of communication protocols. 5 (0)
(c) What is General Audit Package (GAP)? Describe the various facilities to be provided by the GAP? 5 (0)
(d) Describe the scope of Information Technology Act, 2000 5 (0)
7. Write short notes on the following: 4×5=20
(i) Bar Code Reader (0)
(ii) Digital Signature (0)
(iii) Voice Messaging. (0)
(iv) White Box Approach for Audit (0)