The Institute of Chartered Financial Analysts of India University 2007 PE- II Information Technology - Question Paper
CA PE - II:: Information Technology : May 2007
Roll No.....................
Total No. of Questions7 ] [Total No. of Printed Pages2
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.l is compulsory Answer any four from the rest
Marks
1. (a) Convert the following from one number system to another system along with 1x5=5
|
the working notes: | |
|
(i) (3cB 98)18 = ( |
) 2 |
|
(ii) (..........)i6 =( |
) 8 |
|
(iii) (111.12)8 =( |
) 2 |
|
(iv) (10101010.101)2 = ( |
) io |
|
(v) (123.15)io =( |
) 16 |
(b) Describe briefly, the following terms with reference to information Technology: 1x5=5
(i) FTP
(ii) DBMS
(iii) Duplex Printing
(iv) Gateways
(v) Asymmetric Crypto System.
(c) Give one or two reasons for each of the following: 1x5=5
(i) Use of Firewall in the system.
(ii) Need of Macro in spread sheet
(iii) Use of USB Port
(iv) Use of Router
(v) Use of Multiplexer.
(d) Write True or False for each of the following statements: 1x5=5
(i) Network database structure can be used to answer ad hoe queries.
.... Computer Output Microfilm (COM) is Inspire as well as Output device.
(iii) One GB represents 10,48,567 bytes.
(iv) Laser printers speed is measured in PPM.
(v) Screen resolution is measured in terms of Picture elements.
2. Distinguish between the following: 1x5=5
(i) Master file and Transaction file.
(ii) Logical record and Physical record
(iii) Audio conferencing and video conferencing
(iv) Sequential file organisation and Direct file organisation.
(v) Client-server model and Peer to Peer model.
PD P.T.O. (2)
PD Marks
3. (a) Explain in brief, the floppy disk as an auxiliary device. 5
(b) What is database structure? Explain relational database structure. 5
(c) A company offers discounts to customers on the following basis: 10
|
Quantity |
Normal |
|
ordered |
discount |
|
Less than | |
|
101 | |
|
From 101 to |
5% |
|
500 |
10% |
|
From 501 to |
15% |
|
1,000 |
20% |
|
More than | |
|
1,000 |
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.
4. (a) Explain the various views of a slide in MSPower Point. 5
(b) Define an operating system and explain various functions performed by it. 5
(c) What are the integrity controls that DBMS package may offer? Explain in 10 brief.
5. (a) Describe the benefits of SAN. 5
(b) Explain the various views of a slide in MS-Power Point.
(c) Explain the various tools available to protect the information from intrusion and misuse.
(d) Define the following functions used in MS-EXCEL:
(i)NPV (ii) LOG (iii) LEN (iv) ROUND (v) COUNT
6. (a) What is Image processing? Explain the steps required for imaae processing.
(b) Discuss the objectives of information Technology Act, 2000.
(c) Explain the following techniques of audit used by internal auditors:
(i) System activity file interrogation.
(ii) Program comparison.
(d) Explain general management concerns in E-commerce.
7. Write short notes on the following. Answer any four:
5x4=
(i) Voice messaging
(ii) Wireless networks
(iii) File management system
(iv) Diagnostic routines
(v) White box approach for audit.
|
Attachment: |
| Earning: Approval pending. |
