CA PE II Exam Papers Group II

Information Technology November 2008

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 alongwith the working notes: 1×5=5
(i)
(11.8125)10 = ( ) 2
(0)
(ii)
(71.554)3 = ( )16
(0)
(iii)
(ABCD)16 = ( )10
(0)
(iv)
(110101100.01101)2 = ( )8
(0)
(v)
(10110.101)2 = ( )10
(0)
(b) Describe briefly, the following terms with reference to Information Technology: 1×5=5
(i) Domain Name. (0)
(ii) Computer Output Microfilm (COM) (0)
(iii) Parallel Ports (0)
(iv) Bridge (0)
(v) Security Software. (0)
(c) Give one or more reasons of use for each of the following: 1×5=5
(i) Parity Bit (0)
(ii) Protocol Translator (0)
(iii) CMOS (0)
(iv) Web Browser (0)
(v) Data Bus. (0)
(d) Write True or False for each of the following: 1×5=5
(i) Bubble memory can be used for auxiliary storage. (0)
(ii) MS DOS is a 32 bit operating system. (0)
(iii) Relational Database model specifies the relationship among data elements in advance. (0)
(iv) ‘Duplex Printer’ prints on both sides of a sheet of paper at the same time. (0)
(v) Electronic spreadsheet application is designed primarily to perform word processing. (0)
2. Distinguish between the following: 4×5=20
(i) DDL and DML. (0)
(ii) Third generation language and Fourth generation language. (0)
(iii) System Software and Application Software. (0)
(iv) Parallel transmission and Serial transmission. (0)
(v) LAN and WAN. (0)
3. (a) Describe various factors which determine the best file organization for an application. 5 (0)
(b) Explain, why Internet has dramatic impact on the scope of business applications. 5 (0)
(c) The goods imported from the foreign countries are classified into four categories for the purpose of levying Custom duty. The rate of Custom duty on value of goods ‘V’ for each category is given below:
Category (K)
(1)
(2)
(3)
(4) Type of Goods
Electronic items
Heavy machinery
Footwear items
All other unclassified items Custom Duty (%)
10
15
20
25
Draw a flow chart to compute appropriate custom duty including educational cess at the rate of 3% of the value of custom duty.

10 (0)
4. (a) Explain the various functions of communications software. 5 (0)
(b) Discuss the various challenges faced by management of data centre. 5 (0)
(c) What do you mean by Artificial intelligence ? Describe four types of Artificial Intelligence used in Information Technology. 10 (0)
5. (a) Describe the salient features of Hierarchical Database. 5 (0)
(b) Describe any five formatting features available in MS–WORD. 5 (0)
(c) Explain the pre–defined function FV (rate, nper, pmt, pv, type) available in MS–EXCEL. 5 (0)
(d) Define the following functions used in MS–EXCEL: 5
(i)
STDEV ( )
(0)
(ii)
ABS ( )
(0)
(iii)
VAR ( )
(0)
(iv)
LN ( )
(0)
(v)
SUM ( )
(0)
6. (a) What considerations should be given while using CAATs in Small Business ComputerEnvironment ? Discuss in brief. 5 (0)
(b) What do you mean by Generalised Audit Packages (GAPs). Write down the typical steps in using Audit package. 5 (0)
(c) Describe about the various actions which warrant penalty under Section 43 of the Information Technology Act, 2000. 5 (0)
(d) Explain the chief uses of Internet. 5 (0)
7. Write short notes on any four of the following: 5×4=20
(i) Spooling Software. (0)
(ii) Program Library Management System (0)
(iii) Object Oriented Programming (0)
(iv) Network Attached Storage (0)
(v) WINDOWS. (0)