Test Papers / Previous Question Papers of IGNOU CIC4 The Applications June 2002

Certificate in Computing (CIC)

Term-End Examination

June, 2002

CIC-4: The Applications

Time: 2 Hrs
Maximum Marks: 70

A) Multiple Choice (Question numbers 1 to 30)

1. A standard interface which is either hardware or software, used for playing a digital instrument through PC interface on the card as an add on utility is:

(1) MIDI (2) MPEG
(3) JPEG (4) None of the above

2. _______ is used for scanning the pictures and putting them in digitized form in the computer.

(1) CD-ROM (2) Plotter
(3) Bar-coder (4) Scanner

3. Animator, 3D Studio, Corel Draw and Flash are

(1) Word processors (2) Spreadsheet packages
(3) Multimedia S/W (4) None of the above

4. Vid Edit, Pal Edit and Bit Edit are

(1) Video editing features for DOS
(2) Video editing features for Windows
(3) Video editing features for Apple Macintosh
(4) None of the above

5. A common digital sound file existing in PCs are known as _____________________.

(1) .WAV files (2) .MID files
(3) .GIF files (4) None of the above

6. QUICKTIME Multimedia S/W was developed by

(1) Apple for Macintosh machines (2) Microsoft for Windows based machines
(3) IBM for DOS based machines (4) None of the above

7. Delrina’s Winfax Pro 4.0 is a

(1) Database package (2) DTP package
(3) Information provider (4) None of the above

8. Personal Information Manager (PIM) is a tool that store (s)

(1) Reference materials (2) Project details
(3) Links, outlines (4) All of the above

9. Microsoft Excel is a powerful

(1) Spreadsheet package (2) Word processing package
(3) DBMS package (4) Communication S/W Package

10. Power Point presentation is a collection of

(1) Slides and Handouts (2) Speaker’s notes
(3) Outlines (4) All of the above

11. In Satellite based communication, VSAT stands for

(1) Very Small Aperture Terminal (2) Varying Size Aperture Terminal
(3) Very Small Analog Terminal (4) None of the above

12. The server controls the network and the function(s) is/are

(1) to manage files and run applications (2) to manage printers
(3) to manage fax and mails (4) All of the above

13. ________________ consists of a Notebook PC and a cellular phone.

(1) Small-business office (2) Satellite office
(3) Home office (4) None of the above

14. The file that stores for every item, the opening stock for the beginning of year and cumulative transaction details of all types of transactions is

(1) Item master file (2) Requisition file
(3) .YTD Balance file (4) Adjustment file

15. _____________ processes data reflecting changes to items in inventory.

(1) Inventory control system (2) Sales order processing system
(3) Pay Roll (4) None of the above

16. _____________ is a project control technique that can be used for several purposes including scheduling, budgeting and resource planning.

(1) PERT chart (2) Gantt chart
(3) Bar chart (4) Pie chart

17. Which are the files that an EDI creates when a document passes through the system?

(1) Internal format file (2) External format file and Transmission file
(3) Both (1) and (2) (4) None of the above

18. Preventing denial by one of the entities involved in a communication of having participated in all or part of the communication is

(1) Authentication (2) Access control
(3) Confidentiality (4) Non-repudiation

19. Pick out the wrong statement from the following with respect to the benefits of computerized production control.

(1) Enables Foremen to plan ahead
(2) More accurate information updated as and when required
(3) Better communication not possible (4) Over and under loads on facilities shown

20. CD-ROM can store upto _______________ data.

(1) 680 KB (2) 680 Bytes
(3) 680 MB (4) 680 GB

21. MIS is designed to provide information needed for effective decision making by

(1) Consumers (2) Workers
(3) Foremen (4) Managers

22. ATM stands for

(1) Automatic Teller Machine (2) Automatic Talking Machine
(3) Analog Teller Machine (4) Automatic Ticketing Machine

23. A system used to transfer debits and credits with the help of electronic pulses, which are carried through wire either to a magnetic disk or tape is

(1) EDI (2) E-mail
(3) EFT (4) MIS

24. Which of the following is incorrect with respect to “Point of Sale Terminal”?

(1) It processes transactions that occur over and over again.
(2) Allows the customer to pay for goods purchased with automatic account details
(3) It processes the payments of monthly bills.
(4) Fast cash withdrawals is possible.

25. _____________ was supposed to handle quick settlement of funds between RBI Banks, inter banks funds transfer for themselves/customers, message transfer etc.

(1) BANKNET (2) NICNET
(3) BITNET (4) COMPUSERV

26. Service(s) of EET is/are

(1) Credit Authorisation (2) Cheque verification and Check guarantee
(3) File look-up (4) All of the above

27. SP = (S + P)/(S +P/N) is

(1) NWP technique
(2) Richardson’s weather forecasting technique
(3) Amdahl’s law (4) Model equation

28. TISNET’s objective is

(1) to provide weather forecasting equation
(2) to provide trade information particularly to developing countries
(3) to provide database (4) None of the above

29. BISNET is computerised

(1) Online business information services (2) Govt. Network
(3) DBMS Package (4) None of the above

30. INDONET is first computer _________________ of India.

(1) Communication Network (2) Govt. Network
(3) Weather Forecasting Network (4) EDI

B) State whether True or False (Questions 31 to 70)

31. The Multimedia PC should be equipped with a monitor having Super Video Graphics Arrays Card.

32. An 8 MB memory enhances the performance of a Multimedia machine by 50% over 16 MB machines.

33. DESIGNER is one of the professional rating drawing and graphics package for DOS.

34. WAV Edit is the feature which works with the recorded digital audio and helps you to edit it.

35. A standard VGA which uses 16 colour needs 4-bits of storage to store the information.

36. Images stored in GIF format requires more space in disk when compared with BITMAP images.

37. 2D Animation is very time consuming but result obtained is spectacular in nature.

38. Edutainment is educational entertainment.

39. IMAGE Q is a DBMS package.

40. Voice View technology allows you to speak and send files on one line in a single call.

41. Symantic Act for Windows is a Contact Management Software.

42. Suits such as MS-OFFICE are combination of several S/W packages relating to office work.

43. DBASE III Plus package allows database creation, updation, displaying and printing.

44. DBASE III Plus is a Windows-based DBMS package.

45. A primary key of a table can consist of one or more fields which uniquely identify each record that is added to a table.

46. Each worksheet contains many workbooks in MS-EXCEL.

47. Corel Ventura is a DTP package.

48. Slides are the similar printed versions of the Handouts in PowerPoint Presentation.

49. Graphs cannot be included in a slide of PowerPoint presentation.

50. A 3 ½ inch floppy disk which stores upto 2.88 MB information has 80 tracks per side and 36 sectors per track.

51. NOS stands for “No Operating System”.

52. Ethernet is a bus-based Local Area Network.

53. Grant Chart and PERT Chart are two general scheduling techniques.

54. Computer based MIS has helped in better decision making in an organizational structure.

55. EFT is the transfer of structured data for processing from computer to computer using agreed formats and protocols.

56. Application service, Translation service and Communication service are the important components of EDI.

57. The file extension for an External format file of EDI is .IFF.

58. Authentication is restricting access to the information and processing capabilities of network to authorized entities.

59. The VE DES (Data Encryption Standard) has traditionally been the encryption algorithm used to secure EDI messages.

60. Public key crypt system such as RSA is acceptable for integrity of EDI.

61. GEDIS stands for Gateway Electronic Dynamic Intercharge Service.

62. ABC Analysis enables a better management of the inventory.

63. Production managers need information analyzing resource requirements and worked productivity provided by a variety of Marketing Information Systems.

64. MIS supports the decision making needs of strategic management, tactical management and operating management.

65. QIC 980 and QIC 3010 are 8-bit microprocessors.

66. In DBASE the numeric type field can be used to store any kind of data.

67. A database may consist of several tables in MS-ACCESS.

68. In MS-ACCESS, a filter cannot be saved with the table.

69. In MS-EXCEL, a workbook can have only 2 worksheets maximum by default.

70. An index is automatically created for a primary key in a table.