CWA/ICWA Inter :: Information Systems and Technology: June 2004

*I-6(IST)* *Revised Syllabus*
Time Allowed : 3 Hours	Full Marks : 100
Answer Question No. 1 which is compulsory and any five questions from the rest.
Marks

(a)

Match column (1) with column (2):

1x10

(1)		(2)
(i) (ii) (ii) (iv) (v) (vi) (vii) (viii) (ix) (x)	Spreadsheet String Range check Back-up-files Audit Trail URL HTTP ISDN Modern Bitmap	(a) (b) (c) (d) (e) (f) (g) (h) (i) (j)	To ensure quick recovery. Location of an object on the Internet. To communicate with other computers via telephone lines. Access method used on Internet. An image in digital form. Digital Communication lines. A grid of vertical columns. A form of editing of data. Reference back to original source. Connected sequence' of characters or bits.

(b)

Fill in the blanks:

(i)	While using MS-Word, the backspace key on the keyboard, if pressed, deletes the character to the ________ of the current cursor position.
(ii)	MS-Office contains MS-Access, MS-Power Point and ________.
(iii)	________ number system has a base of 16.
(iv)	The study of the behaviour of a physical or hypothetical system is done by ________.
(v)	The total volume of work performed by the computer system over a given period of time is termed as ________.

1x5

(c)

Choose the most appropriate answer out of the four alternatives in each set:

1x5

(i)

One KB stands for

(A) 100 bytes;

(B) 1000 bytes;

(C) 999 bits;

(D) 1024 bytes.

(ii)

A key-field implies

(A) Important field;

(B) Sequence/search field

(C) Alpha-numeric field;

(D) Only numeric field.

(iii)

Database System refers to

(A) Database;

(B) Query Language;

(C) Database and DBMS;

(D) DBMS only.

(iv)

For information recording the magnetic tape is divided into vertical columns called

(A) Channels;

(B) Tracks;

(C) Grid;

(D) Frames.

(v)

Assembly language is

(A) Machine dependent;

(B) Machine independent;

(C) Partly dependent and partly independent;

(D) Not a programming language.

(a)

"There can be many specialists in a database environment." Name at least four such specialists and the duties of any two of them who may be considered essential.

2+4+4

(b)

Distinguish between DBMS centralised architecture and client-server architecture.

Please turn over

( 2 )

I-6(IST)
Revised Syllabus

Marks

(a)

How many different character formations are possible in EBCDIC code?

(b)

Convent decimal number 99 to binary, octal and hexadecimal numbers.

2+2+2

(c)

Expand the following abbreviations:

1x8

(i)	HTML;	(ii)	GUI;
(iii)	NIC;	(iv)	ULSI;
(v)	ISAM;	(vi)	SDRAM;
(vii)	SQL;	(viii)	RISC.

Write short notes on:-

(a)	Contingency Planning;
(b)	Virtual Reality;
(c)	Integrated Circuits;
(d)	Hash Function.

4x4

(a)

You are interested to access the Internet facility sitting at home. What are the equipment and facilities that may be required to fulfill your desire?

(b)

"No company, big or small, can ignore the opportunity opened by the Internet." What are the various methods by which Internet can be accessed? What are the considerations for choosing the right alternative?

3+3

(c)

What do you mean by —
(i) Multimedia,
(ii) Video conferencing?

2+2

(a)

"It is better to depend on reputed ERP software packages than to develop such packages internally."

(i)	Do you agree with the above opinion? Furnish the reasons in support of your decision.
(ii)	On implementation of ERP, what will be the changes in the information processing system?

5+5

(b)

"In a computerised environment, a source document should be carefully designed for prevention and detection of errors at all stages of processing and gaining confidence of audit team when referenced back as original source."

The performance of a company having production fines of long gestation period is judged, inter alia, by two factors viz. (i) Value of Production (VOP), and (ii) Value Added (VA). The formula for calculating Value of Production is Sales plus Closing work-in-progress minus Opening work-in-progress and that of Value Added (V A) is Value of Production minus Cost of material consumed. Closing work-progress(W-I-P) is valued at cost or realizable value whichever is less. The performance during last financial year i.e. 2002-03 were as under:

	Rs. Crores
Closing W-I-P (alter valuation)	390
Value Added	75
Value of Production	525

During the year 2003-04 the figures related to performance are collected as under. It may be assumed that there is no change in the lanour and overhead structure, and full utilisations of the resources were made.

Closing W-I-P at cost:
Product — A000
Product — B
Sales (total)
Cost of materials consumed (total)
Realisable value of Closing W-I-P;
Product — A
Product — B

Rs. Crores

300
250
450
460

325
215

(a)

You are required to calculate -

(i)	Closing W-I-P after valuation,
(ii)	Value of Production, and
(iii)	Value Added.

3×3

(b)

(i)	Comment on the performance during the year 2003-04 compared to previous year.
(ii)	Give probable suggestions for improvement of performance.

4+3

(a)

"Use of computers must be controlled by a system of auditing in order to prevent any kind of adverse effect."

(i)	Narrate the basic objectives of information system auditing.
(ii)	Name the types of documentation required for smooth functioning of information system.

3
3

(b)

In the context of Internet, answer the following questions;

2x5

(i)	Write the expansions of the following two Web extensions: (a) edu, and (b) org.
(ii)	Write name of any two Internet Service Provider (ISP) in India.
(iii)	What is the distinction between uploading and downloading a file?
(iv)	Name any two benefits for using E-mail compared to conventional mail.
(v)	Differentiate between a Home page and a Web site.

__________