CA PE II  Exam Papers  Group II

Information Technology November 2009

This Paper has 48 answerable questions with 0 answered.

Total No. of Questions — 7]
Time Allowed : 3 Hours

Maximum Marks : 100
Question No.1 is compulsory
Answer any four from the rest
Marks
1. (a) Convert the following from one number system to another number system along with the working notes: 1×5=5
(i)
(43.375)10 = ( ) 2
(0)
(ii)
(243)8 = ( ) 16
(0)
(iii)
(7B.773)16 = ( ) 10
(0)
(iv)
(163)10 = ( ) 8
(0)
(v)
(1000001.1010011)2 = ( ) 10
(0)
(b) Describe briefly, the following terms with reference to Information Technology: 1×5=5
(i) ASCII (0)
(ii) Access Time (0)
(iii) Extranet (0)
(iv) Repeater (0)
(v) Overlaying (0)
(c) Give one or more reasons of use for each of the following: 1×5=5
(i) RS–232C Port (0)
(ii) Circuit Switching (0)
(iii) Address Bus (0)
(iv) Cache memory in a processor (0)
(v) Digital Signature (0)
(d) Write True of False for each of the following: 1×5=5
(i) Flash memory is a volatile memory. (0)
(ii) Data bus is a mechanical device that connects CPU and other hardware devices on the motherboard. (0)
(iii) An object program is a machine language program that can be directly executed by a particular computer. (0)
(iv) MS–Windows is a multiprogramming and multitasking operating system. (0)
(v) More RAM can make the computer run faster. (0)
2. Distinguish between the following: 4×5=20
(i) CMOS and BIOS (0)
(ii) Dumb terminal and Intelligent terminal (0)
(iii) Batch processing and Interactive processing (0)
(iv) Synchronous transmission and Asynchronous transmission (0)
(v) Black box approach of audit and White box approach of audit. (0)
3. (a) What is meant by the ‘Direct Access File Organization’? Describe the “Direct Sequential Access” method. 5 (0)
(b) What is Decision Support System? Explain various components of Decision Support System. 5 (0)
(c) A book publisher of Accounts and Computer books offers discount to customers on the basis of Customer type and Subject as detailed below:
Customer type Subject Discount (%)
Book seller

Library Accounts
Computer
Accounts
Computer 10
20
5
10
If number of copies purchased is more than 10, then additional discount of 2% is allowed irrespective of the customer type and subject.

It is also assumed that there are 25 customers and complete details of each customer like customer name, type, subject, number of copies and unit price is required to be entered through the console.

Draw a program flow chart to calculate and print the net amount paid by each customer along with customer name. Also print the total discount allowed to all the customers.

10 (0)
4. (a) Describe ‘Mesh Network’ as a network topology. Also mention its advantages and disadvantages. 5 (0)
(b) Explain various security mechanisms to protect the information from intrusion and misuse. 5 (0)
(c) What is Document imaging? Explain various steps required for document imaging along with its advantages. 10 (0)
5. (a) Explain various data integrity controls, which are used in a database environment to ensure the accuracy and completeness of data. 5 (0)
(b) Write the various steps for creating a new macro in MS–Excel. 5 (0)
(c) Power Point 2000 offers different views to help you to create your presentations. Describe them briefly. 5 (0)
(d) Define the following functions used in MS–Excel: 5
(i) ROUND (0)
(ii) LEN (0)
(iii) DCOUNT (0)
(iv) DB (0)
(v) LOWER (0)
6. (a) What are the conditions prescribed in IT Act, 2000 for the purpose of Electronic Governance to retain documents, records or information in electronic form for any specified period? 5 (0)
(b) Explain the following miscellaneous techniques of audit in a computerized environment :
(i) System Activity file interrogation
(ii) Program Comparison
5 (0)
(c) Explain salient features of E.X. NGN Financial Accounting package. 5 (0)
(d) Explain Local Area Network (LAN) and its basic components. 5 (0)
7. Write short notes on any four of the following : 5×4=20
(i) Diagnostic Routines (0)
(ii) Electronic Data Interchange (EDI) (0)
(iii) Graphical User Interface (GUI) (0)
(iv) Turn Around Documents (0)
(v) Storage Area Network (SAN) (0)