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

Certificate in Computing (CIC)

Term-End Examination

June, 2007

CIC-4: The Applications

Time: 2 Hrs
Maximum Marks: 100

A) Multiple Choice (Question numbers 1 to 30)

1. The personal information manager does not contain
(1) Reference material
(2) Project details
(3) Document outlines
(4) Folders

2. Which of the following charts is useful for project scheduling, budgeting and resource planning ?
(1) GANTT
(2) PERT
(3) Line
(4) Radar

3. Which of the following files are not created by EDI ?
(1) Internal format file
(2) External format file
(3) Transmission file
(4) Executable fiIe

4. The external document standard nof supported by EDI is
(1) EDIFACT (2) TDCC
(3) X12 (4) X11

5. Which of the following is not a multimedia extension in Windows ?
(1) RIFF (2) MIDI
(3) MCI (4) RTF

6. Full form of MPEG is
(1) Moving Picture Expert Group
(2) Moving Picture Executable Group
(3) Media Player Expert Group
(4) Media Player Executable Group

7. Project Management Inforrration system is not required because of following reasons :
(1) keep track of progress of project
(2) help project manager to update his project periodically
(3) provides well defined breakdown structure
(4) predict the finance and time required to complete the project

8. The management information system that provides current status and projected trends is
(1) Decision support system
(2) Executive information system
(3) Information reporting system
(4) Operation information system

9. Which of the following is not a facility available in dBase III+ ?
(1) Creating a database (2) Compacting a database
(3) Indexing a database (4) Deleting a database

10. DTP packages in general, are better equipped in
(1) IBM computers
(2) Systems based on LINUX OS.
(3) Apple-Macintosh computers
(4) None of the above

11. What would an engineer use to assist in testing a new automobile before production ?
(1) CAE (2) CAD
(3) Morphing (4) Bit-mapping

12. The World Wide Web is a hypermedia system because it
(1) can be used only to bring video material
(2) links to other computer resources
(3) is hyperfast
(4) None of the above

13. YAHOO and GOOGLE are
(1) Search Engines (2) Browsers
(3) LAN connections (4) WAN connections

14. In MS-Word, to align the text to left and right margins, press
(1) Ctrl+J (2) Alt+J
(3) Shift+J (4) Esc

15. To scan a picture and put it in digitised form in the computer we use
(1) CD-ROM (2) Plotter
(3) Scanner (4) Bar-codes

16. QuickTime multimedia S/W is developed by
(1) Apple for Macintosh machines
(2) Microsoft for Windows based machines
(3) IBM for DOS based machines
(4) None of the above

17. Point-of-sale terminals have replaced what ?
(1) Bank tellers (2) MICR
(3) Credit cards (4) Cash registers

18. Which of the following tools helps to organise data on the disk ?
(1) Disk converter (2) Disk cleanup
(3) Scandisk (4) Disk defragmenter

19. A Telnet is
(1) Connecting telephones through Internet
(2) Terminal Emulation Program for TCP/IP networks
(3) Teleconferencing program
(4) Voice over Internet

20. 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) Confidentiality
(3) Access control
(4) Non-repudiation

21. The amount of data stored on a CD-ROM is equivalent to data stored in ___________ floppies.
(1) 475 (2) 300
(3) 50 (4) 100

22. VGA screen uses the resolution of
(1) 620 x 420 pixels
(2) 640 x 480 pixels
(3) 620 x 480 pixels
(4) 640 x 420 pixels

23. Which of the following is not an important principle for evaluating the raw data for decision-making ?
(1) Overflow (2) Selection
(3) Pattern (4) Leverage

24. NWP technique in weather forecasting was innovated by
(1) Richardson (2) Shamir
(3) Rivest (4) Navier Stokes

25. The command to create a new database file based on two open database files is
(1) Join (2) Uadate
(3) Insert (4) Create

26. A transaction file contains
(1) Permanent information
(2) Temporary information
(3) order change details
(4) All of the above

27. Which of the following is a monthly report ?
(1) Under Stock Report (2) ABC Analysis Report
(3) Stock Ledger Report (4) Categorywise Consumption Analysis Report

28. Critical path in the PERT chart is
(1) path which takes the longest time to complete the project
(2) path which takes the smallest time to complete the project
(3) both ofthe above
(4) the shortest path

29. Which of tlre following is/are functions of server ?
(1) To manage printer
(2) To manage fax and mails
(3) To manage files and run applications
(4) All of the above

30. Which of the following are the services of EFT ?
(1) File look up (2) Cheque verification and check guarantee
(3) Credit Authorisation (4) All of the above

31. An ISDN line allows digital transmission of
(1) 64 kbps (2) 128 kbPs
(3) 32 kbps (4) 16 kbPs

32. What is the address given to computer connected to a network called ?
(1) System address (2) Syrid
(3) Process id (4) IP address

33. Desktop video conferencing allows user to
(1) see each other
(2) work on the same Project
(3) hear each other
(4) All of the above

34. Lotus Organiser does not have the following section
(1) Notepad (2) WordPad
(3) Personal diary (4) Scheduler

35. If you want a shareware program that is available on a computer on the Internet, you could transfer the program to your computer by using
(1) FTP (2) Usenet
(3) Telnet (4) U.S. Mail

36. The command used to add a new field to an active database file is
(1) Modify label (2) Modify command
(3) Modify structure (4) Modify report

37. Which of the following is used to combine components of a multimedia presentation ?
(1) Authoring software (2) Hypertext
(3) Run-time program (4) MIDI

38. Symantec Act for Windows is a
(1) Contact management S/W
(2) S/W used to compress the files
(3) S/W used to unzip the files
(4) S/W used to encrypt the files

39. 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

40. Zero lead time of supplies means
(1) EOQ will have no relevance
(2) Reorder points will have no relevance
(3) We may not need to hold any inventory
(4) All of the above

41. Which of the following presentations comprise a series of background images and associated control scripts that add user interface controls, overlay images etc. to each slide ?
(1) ImageQ
(2) PowerPoint
(3) MacromediaDirector
(4) Authorware

42, Items with a higher investment value in ABC analysis of items comes in
(1) Class B (2) Class C
(3) Class A (4) Class D

43. Suite package does not include
(1) Word processing program (2) Presentation gaphics S/W
(3) Databases (4) DTP package

44. The arrangement of elements such as title and subtitle text, pictures, tables etc. is called
(1) Layout (2) Scheme
(3) Design (4) Presentation

45. Which type of file connot be navigated using ClipArt browser ?
(1) AVI (2) MP3
(3) WAV (4) BMP

46. OLE stands for
(1) Object Linking and Exchange
(2) Object Link and Exchange
(3) Object Linking and Exchanging
(4) None of the above

47. BISNET is computerised
(1) Online business information services
(2) Government network
(3) DBMS package
(4) None of the above

48. X.25 is a
(1) Private network
(2) Point-to-point protocol
(3) Packet switched data network
(4) ISDN line

49. Following can be categorised as inventory in an organisation :
(1) In-process materials (2) Dead stock
(3) Slow-moving items (4) All of the above

50. Data integrity refers to the
(1) simplicity of data (2) privacy of data
(3) validity of data (4) security of data

B) State whether True or False (Questions number 51 to 100)

Note : In the fottowing 50 questions, mark 7, if the statement given is true and 0 if the statement given is false.

51. A PC based multimedia conference allows us to exchange audio, text, image and even video information

52. ImageQ is a DBMS package.

53. Each workbook in MS-Excel can have maximum of 20 worksheets.

54. Video conferencing is also called as audio-graphic conferencing technology.

56. SVGA monitor has better resolution, thus the display will be of better quality for the graphics and pictures.

56. Executive information systems are tailored to the strategic inforrnation needs of the middle level management.

57. Twisted pair cable is rated very low on the reliability parameter.

58. The efficiency, reliability and accuracy of data transmission through WAN depends upon the medium.

59. Resource Interchange file format is a standard format for digital audio.

60. In cartridge tapes, both compressed and uncompressed files can be saved.

61. Two networks having different network,operating systems can be linked to each other.

62. A filter is used to create a database.

63. Communication service is a component of an EDI system.

64, Decision Support Systems provide information systems which are according to strategic information needs of top management.

65. Animation can be used to emphasize the three-dimensional nature of objects.

66. In TCP/IP connection, the user will get only textual matter of a web page.

67: The size of currency data type is 1 byte in MS-Access.

68. A hypertext browser is a program that can display a diagram of a network of nodes.

69. Security in computer networks is provided with the use of cryptographic techniques.

70. E-commerce has become feasible only due to the evolution of Internet.

71. All management inforrmation systems rely on the availability of a knowledge base to generate routine management reports.

72. TFB stands for Transaction File Builder.

73.GatewayAccess is also known as level-one connection.

74. Digital video as well as digital audio both are dependent on the type of frame sampling. Based on this sampling the quality of audio or video can be good or bad.

75. EFT system is used to replace currency in minimum possible time.

76. Object linking and embedding in Windows does not allow to combine video or audio clips.

77. HTML is platform independent.

78. MIDI data is in digitized forrn.

79. The index on primary key is explicitly created by user in MS-Access.

80. The materials that do not form part of product but are necessary to keep an organisation working comes under direct material category.

81. Mobile office requires only a cellular phone.

82. The trend line called polynomial is used in Excel for projections in graphics.

83. The text typed in closed shape (in PowerPoint) does not depend on the text wrap feature.

84. ISO is the model based on the proposal developed by International Standards Organisation.

85. A cache is a low-speed memory

86. Open GL is a graphics library.

87. USENET is the e-mail serrrice of Internet.

88. EDI requires no human intervention in acknowledging purchase orders.

89. The Translation Service makes the data in the IFF available in database so that the business application can fetch the document from EDI.

90. A CD can store data equivalent to 24 volumes of encyclopaedia.

91. The script language programs are readily transported to other hardware platforms.

92. A trail is a record of the nodes that a user has accessed in viewing a hypertext network.

98. Message processing is an important area where security is needed.

94. The file size of Bitmap images is smaller than the file size for vector images.

95. Interactive video does not fit in the category of multimedia

96. A decentralized data processing results in reduced interest and motivation at user levels.

97. Decision analysis is a three-phased process.

98. The file format for a Music only file is VOC.

99. Director has 48 separate sprite channels available in each frame.

100. Icon based programs are harder to learn than scripting programs.