CA PE II Question Papers Group II

Information Technology May 2005

This Paper has 48 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) (1267.3125)10 = ()2 (0)
(ii) (10110.101)2 = ()10 (0)
(iii) (1234)8 = ()16 (0)
(iv) (B2C)16 = ()2 (0)
(v) (10110111.1)2 = ()8 (0)
(b) Describe briefly, the following terms with reference to Information Technology: 5×1=5
(i) Asymmetric crypto system (0)
(ii) Subroutine (0)
(iii) Parity bit (0)
(iv) Object oriented Database (0)
(v) FTP (0)
(c) Give one or two reasons for each of the following: 5×1=5
(i) Use of Serial Interface (0)
(ii) Use of Spooling Software. (0)
(iii) Use of Fire wall in the system (0)
(iv) Need of Repeaters in the network. (0)
(v) Need of Reference files. (0)
(d) Write True or False for each of the following: 5×1=5
(i) Flash memory chips are one form of static RAM chip. (0)
(ii) A sequential access file can reside only on a magnetic tape. (0)
(iii) A Personnel Computer based on the Intel 80386 chipset has 32 bit processor (0)
(iv) The speed of Dot matrix printer is measured in terms of CPS. (0)
(v) Outline view of MS–POWER POINT permits frequent switching between text and object on a slide. (0)
2. Distinguish between the following: 5×4=20
(i) Synchronous and Asynchronous data transmission. (0)
(ii) RAM and ROM (0)
(iii) Multiprogramming and Multiprocessing (0)
(iv) Third generation and Fourth generation languages. (0)
(v) Fixed length field and Variable length field (with reference to database). (0)
3. (a) Describe briefly, why a file processing system reduces effectiveness of the end user applications? 5 (0)
(b) Describe the salient features of Hierarchical database. 5 (0)
(c) A bank has 500 employees. The salary paid to each employee is sum of his basic pay. Dearness Allowance and House rent allowance. For the purpose of computing house rent allowance bank has classified his employees into three classes A, B and C. The house rent allowance for each class is computed at the rate of 30 percent, 20 percent and 10 percent of the basic pay respectively. The dearness allowance is computed at a flat rate of 60 percent of the basic pay.
Draw a flow chart to determine the percentage of employee falling in the each of the following salary slab:
(i) Above Rs. 30,000
(ii) Rs. 15,001 to Rs. 30,000
(iii) Rs. 8,001 to Rs. 15,000
(iv) Less than or equal to Rs. 8,000.
10 (0)
4. (a) Explain the working principle of Electronic Data Interchange (EDI). 5 (0)
(b) Describe the various services provided by Data centre. 5 (0)
(c) Discuss the various components of a Local Area Network (LAN) 10 (0)
5. (a) With reference to word processing, differentiate between the following: 3+2=5
(i) Text Editor and Word Processor (0)
(ii) Type face and Font. (0)
(b) What do you mean by Artificial Intelligence? Describe any two types of artificial intelligence used in Information Technology. 5 (0)
(c) Describe any five categories with their purposes under which various functions available in MS–EXCEL are classified. 5 (0)
(d) Define the following functions used in MS–EXCEL: 5×1=5
(i) IRR (0)
(ii) LEN (0)
(iii) DMIN (0)
(iv) POWER (0)
(v) MOD (X/Y) (0)
6. (a) Which areas of DBMS should be addressed while maintaining a database? 5 (0)
(b) Describe the Integrated Test Facility (ITF) method used in conducting audit 5 (0)
(c) Describe about the various actions which warrants penalty under the Section 43 of the IT Act, 2000. 5 (0)
(d) Briefly explain the various tools available to protect informations against instructions. 5 (0)
7. Write short notes on the following: 4×5=20
(i) Firmware (0)
(ii) Data dictionary (0)
(iii) Storage area network (0)
(iv) Microsoft windows (0)