CA PE II Question Papers  Group II

Information Technology  May 2007

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) (3cB 98)18 = ()2 (0)
(ii) (———-)16 = 8 (0)
(iii) (111.12)8 = ()2 (0)
(iv) (10101010.101)2 = ()10 (0)
(v) (123.15)10 = ()16 (0)
(b) Describe briefly, the following terms with reference to Information Technology: 5×1=5
(i) FTP (0)
(ii) DBMS (0)
(iii) Duplex Printing (0)
(iv) Gateways (0)
(v) Asymmetric Crypto System. (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 of Macro in spread sheet (0)
(iii) Use of USB Port (0)
(iv) Use of Router (0)
(v) Use of Multiplexer (0)
(d) Write True or False for each of the following statements: 5×1=5
(i) Network database structure can be used to answer ad hoe queries. (0)
(ii) Computer Output Microfilm (COM) is Inspire as well as Output device (0)
(iii) One GB represents 10,48,567 bytes. (0)
(iv) Laser printers speed is measured in PPM (0)
(v) Screen resolution is measured in terms of Picture elements. (0)
2. Distinguish between the following: 5×4=20
(i) Master file and Transaction file. (0)
(ii) Logical record and Physical record (0)
(iii) Audio conferencing and video conferencing (0)
(iv) Sequential file organisation and Direct file organisation. (0)
(v) Client–server model and Peer to Peer model. (0)
3. (a) Explain in brief, the floppy disk as an auxiliary device. 5 (0)
(b) What is database structure? Explain relational database structure. 5 (0)
(c) A company offers discounts to customers on the following basis:
Quantity ordered Normal discount
Less than 101
From 101 to 500
From 501 to 1,000
More than 1,000 5%
10%
15%
20%
The normal discount as given above is admissible only if the Customer’s account balance is below Rs. 1,000 and the order value is Rs. 10,000 or more. If the admit does not satisfy both of these conditions, the discount is reduced by 2% and if only one condition is violated, the discount is reduced by 1%.

Draw a Flow chart to print customer name, discount offered and net amount payable for 25 customers.

10 (0)
4. (a) Explain the various views of a slide in MS—Power Point. 5 (0)
(b) Define an operating system and explain various functions performed by it. 5 (0)
(c) What are the integrity controls that DBMS package may offer? Explain in brief 10 (0)
5. (a) Describe the benefits of SAN. 5 (0)
(b) Explain the various views of a slide in MS–Power Point. 5 (0)
(c) Explain the various tools available to protect the information from intrusion and misuse. 5 (0)
(d) Define the following functions used in MS–EXCEL: 5×1=5
(i) LOG (0)
(ii) LEN (0)
(iii) ROUND (0)
(iv) COUNT (0)
6. (a) What is Image processing? Explain the steps required for image processing. 5 (0)
(b) Discuss the objectives of information Technology Act, 2000. 5 (0)
(c) Explain the following techniques of audit used by internal auditors: 5
(i) System activity file interrogation. (0)
(ii) Program comparison (0)
(d) Explain general management concerns in E–commerce. 5 (0)
7. Write short notes on the following. Answer any four: 5×4=20
(i) Voice messaging (0)
(ii) Wireless networks (0)
(iii) File management system (0)
(iv) Diagnostic routines (0)
(v) White box approach for audit (0)