Success-Gurus

PAPER - 6 : INFORMATION TECHNOLOGY

QUESTIONS

1. Define the following term briefly.

(i) Toggle

(iv) Accumulator

(vii) PCI Slots

(x) Duplex Printing

(xiii) Object Program

(xvi) SQL

(xix) Bridge

(xxii)PPP

(ii) Data item

(v) CMOS

(iii) EBCDIC System

(vi) Cursor

(viii) Intelligent Terminal (ix) Drag

(xi) Overlay

(xiv) Debug

(xvii)Client

(xx) FTP

(xxiii) ISP

(xii) Seek Time

(xv) Interpreter

(xviii) Multiplexer

(xxi) URL

(xxiv)Asymmetric Crypto System

2. Convert the following from one number system to another number system along with the

working notes:

(i) (324.25)10 = ( )2

(ii) (11101101.0101) 2 = ( )10

(iii) (6443)8

(iv) (568.5)10

(v) (292A)16

(vi) (10110101.11)2

(vii) (6DAF)16

= ( )16

= ( )8

= ( )10

= ( )8

= ( )2

(viii) (1001011.110101) 2 = ( )16

(ix) (CD.1C)16

(x) (310.04)8

= ( )8

= ( )2

3. Give one or two uses or reasons of each of the following:

(i) Use of Master File

(iii) Use of Parallel port

(v) Use of Disk Formatting

(vii) Use of Modem

(ix) Use of Firewall

(ii) Use of Data Bus

(iv) Use of Integrated Circuits

(vi) Use of Spooling S/W

(viii) Use of Hub

(x) Use of Intranet

(xi) Use of Auxiliary Storage Devices

(xii) Use of Boot Strap loader

(xiii) Use of Language Translators

(xv) Use of Router

(xiv) Use of Repeaters

4. Distinguish between the following:

(i) Thing Generation and Fourth Generation Language

(ii) Dynamic RAM and Static RAM

(iii) Control Unit and Arithmetic Logic Unit

(iv) Personal computing and Networking Computing

(v) Impact Printer and Non-impact Printer

(vi) CD-ROM and ROM BIOS

(vii) Multiprogramming and Multitasking systems

(viii) Systems software and Application software

(ix) Sequential File Organization and Random File Organization

(x) Online System and Real time system

(xi) Local area network and Wide Area network

(xii) Client-server Architecture and Peer-to-peer Architecture

(xiii) Network Attached Storage and Direct Attached Storage

(xiv) Audio Conferencing and Video Conferencing

(xv) Horizontal Partitioning and Vertical Partitioning

Data Processing

5. (a) Discuss various types of computer systems in brief.

(b) What do you understand by computer? Discuss Advantages and Limitations of

computer system.

Anatomy of Computer

6. (a) Discuss various features of central processing unit in brief.

(b) What do you understand by system memory? Discuss in brief various types of

system memory.

Computer Input Media and Devices

7. (a) Discuss various data entry devices used for transcribing source information on

magnetic media.

(b) What is screen resolution? Discuss various display adapters used in personal

computer.

Computer Output

8. (a) Discuss the main features of Chain printer and Drum printer.

(b) Discuss various non-impact printers viz. Thermal, Inkjet and Laser printer in brief.

Auxiliary Storage Devices

9. (a) What are the factors that determine the number of charters that can be stored in a

floppy diskette?

(b) Discuss various types of Optical Laser Disks in brief.

Software

10. (a) What are the various Files and Directories used in Opening System. Discuss in

brief.

(b) What is Language Translators? Discuss various types of Languages Translators in

brief.

Data Storage and Retrieval

11. (a) What are the factors that determine the best file organization for an application?

(b) What do you understand by Data Access and Organization Methods? Discuss

Sequential method in brief.

Database Management Systems

12. (a) What are the management problems of files processing system?

(b) Briefly describe various components of the database environment.

Advance Systems

13. (a) What is Decision Support System? Briefly discuss various characteristics of a

Decision Support System.

(b) What do you understand by Artificial Intelligence? Describe various types of

Artificial Intelligence.

Telecommunication and Networking

14. (a) What do you understand by Network Topology? Describe Various Network topology

in brief.

(b) Discuss in brief various components of a Local Area Network.

Internet and Emerging Technologies

15. (a) Describe the term Internet. What benefits are offered by the Internet?

(b) What is E-commence? Describe three general classes of E-commerce in brief.

Database Performance Monitoring

16. (a) What are the five areas of DBMS that should be addressed while maintaining a well-

tuned database? Discuss briefly.

(b) Discuss the importance of Data volume and usage analysis for physical design.

IT Act 2000

17. (a) Discuss the power of controller under 'OFFENCES' of chapter XI.

(b) Discuss the various objectives of the IT Act 2000.

Flow Chart

18. (a) What do you mean by Flowchart? Discuss benefits and limitations of flow chart.

(b) Draw a flow chart to compute and print for 25 transactions (assuming all are

correct).

The Gross Sales (GS)

Discount Allowed (DA), and

Net Sales (NS).

The input document shall provide the Quantity Sold (QS) and the Unit Price (UP).

The discount is allowed as under :

No. of units sold

Less than 100

100-200

201-500

501-1000

More than 1000

Discount admissible

Nil

2%

5%

10%

20%

Calculate Gross Sales, Discount allowed and Net Sales and must be printed on

every page.

Decision Table

19. (a) Discuss various types of Decision Table in brief.

(b) The details of procedure for dealing with delivery charges for goods bought from

Jindal and Company Ltd. is given below :

For calculating the delivery charges, customers are divided into two categories,

those whose sales region code is 10 or above and those with the code of less than

10.

If the code is less than 10 and the invoice amount is less than Rs. 10,000, the

delivery charge to be added to the invoice total is Rs. 200. But if the invoice value is

for Rs. 10,000 or more, the delivery charge is Rs. 100.

If the code is equal to or greater than 10, the corresponding delivery charges are

Rs. 250 and Rs. 150 respectively.

Prepare a decision table of the above procedure.

Word Processing

20. (a) Write various steps involved to performs Mail Merge.

(b) Discuss in brief various features of tables in MS-Word.

Spread Sheet

21. (a) Write the steps to create the Macro in Excel 2000.

(b) (i) FV

(v) SUM

(ix) PROPER

(ii) INT(x)

(vi) LEN

(x) CLEAN

(iii) COUNTIF

(vii) DMAX

(iv) ABS

(viii) UPPER

Business Project Management

22. (a) Discuss in brief various views in MS Power Point to create presentation in effective

manner.

(b) Explain the following concept in Ms-Power Point.

(i) Working with text

(ii) Working with slide master

Computer Aided Audit Techniques

23. (a) Describe the various factors which determine the use of Computer Assisted Audit

Techniques (CAAT).

(b) Describe the Integrated Test facility (ITF) method used in conducting audit through

computer.

Accounting Package

24. (a) Describe the various facilities to be provided by the user friendly accounting

software package.

(b) Explain the process of voucher entry in Tally 5.4 for the following:

(i) Purchase entry

(ii) Sales entry

25. Write short notes on the following.

(i) Bar Code Reader

(ii) Smart Card System

(iii) Diagnostic Routines

(iv) Wireless Networks

(v) Digital Signature

(vi) Web Casting

FOR QUESTION AND ANSWERS BOTH, CLICK TO DOWNLOAD ABOVE