CA PE II Question Papers Group II
Information Technology May 2006
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 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) (101101.1101)2 = ()10 (0)
(ii) (56.57)8 = ()16 (0)
(iii) (36.125)10 = ()2 (0)
(iv) (11001.10)2 = ()8 (0)
(v) (426.40)8 = ()10 (0)
(b) Describe briefly, the following terms with reference to Information Technology: 5×1=5
(i) Structured Query Language (SQL) (0)
(ii) Drag (0)
(iii) Bidirectional Printing (0)
(iv) Formatting (0)
(v) Internet Service Provider (ISP). (0)
(c) Give one or two reasons for each of the following: 5×1=5
(i) Use of Dynamic Processing (0)
(ii) Use of Cache Memory in processor (0)
(iii) Use of RS–232C Port (0)
(iv) Use of Bridges in the Network (0)
(v) Use of drivers. (0)
(d) Write True or False for each of the following: 5×1=5
(i) MS–Windows is a multi tasking operating system. (0)
(ii) Magnetic tape supports random file organization. (0)
(iii) The default number of worksheets in an MS–EXCEL work book is three. (0)
(iv) In MS–WORD, Drop cap can be selected from Tool Menu. (0)
(v) Flash memory uses solid state chips to store data and the data stays recorded only when the power supply is turned on. (0)
2. Distinguish between the following. Answer any four: 5×4=20
(i) Key to disk and Key–to–diskette (0)
(ii) Serial transmission and Parallel transmission (0)
(iii) Ring Network and Mesh Network. (0)
(iv) Centralized processing and Distributed processing. (0)
(v) Hardware and Software. (0)
3. (a) What is Decision Support System (DSS)? Explain its various components 5 (0)
(b) Explain briefly various Disaster Recovery (DR) plans for eliminating Down time. 5 (0)
(c) Draw a flow chart to compute and print Income–tax, Surcharge and Education cess on the income of a person, where income is to be read from terminal and tax is to be calculated as per the following rates:
Slab
(Rs.) Rate
(i)
(ii)
(iii)
(iv) 1 to 1,00,000
1,00,001 to 1,50,000
1,50,001 to 2,50,000
2,50,0001 onwards
Surcharge
Education cess No tax
@ 10% of amount above 1,00,000
Rs. 5,000 + 20% of amount above 1,50,000
Rs. 25,000 + 30% of amount above 2,50,000
@ 10% on the amount of total tax, if the income
of a person exceeds Rs. 10,00,000
2% on the total tax
10 (0)
4. (a) Briefly discuss features of data centres. 5 (0)
(b) Describe various functions performed by a Database Administrator. 5 (0)
(c) Define Database. Explain in brief different types of databases. 10 (0)
5. (a) Describe briefly various benefits provided by online systems. 5 (0)
(b) Explain various benefits offered by Electronic Data Interchange (EDI). 5 (0)
(c) Define the following functions used in MS–EXCEL: 5×1=5
(i) ABS (0)
(ii) NPER (0)
(iii) AVERAGE (0)
(iv) ROUND (0)
(v) PROPER (0)
(d) Explain briefly, the enhanced features of power point. 5 (0)
6. (a) Explain the importance of “Data Volume” and “Usage Analysis” in the design of database 5 (0)
(b) Define the following terms with reference to Section 2 of Information Technology Act, 2000: 5×1=5
(i) Key Pair (0)
(ii) Originator (0)
(iii) Digital Signature (0)
(iv) Secure System (0)
(v) Computer Network. (0)
(c) Explain the advantages of decision tables. 5 (0)
(d) Explain major steps involved in using the CAATs. 5 (0)
7. Write short notes on the following. 4×5=20
(i) Smart Card System (0)
(ii) Language Translators (0)
(iii) Network Attached Storage (NAS) (0)
(iv) Program (Parallel) Simulation. (0)