IGNOU Test Papers - CIC3 The Tools - June 2005

Certificate in Computing (CIC)

Term-End Examination

June, 2002

CIC-3: The Tools

Time: 2 Hrs
Maximum Marks: 70

Note: (i) Do not start answering until the invigilator asks you to start.
(ii) Question paper contains 70 questions. Student is required to answer all the questions. There is no choice.
(iii) All questions carry equal marks.
(iv) Each question must be given one answer only. If more than one answer is marked or given, zero mark will be awarded for that question.

A) Multiple Choice (Question numbers 1 to 30)

Note: Four choices are given for a question, out of which one choice may be correct. Mark correct answer in relevant column of the answer sheet given to you. In case you feel that none of the choices given in a question is correct, mark in column ‘0’.

1. Which command at DOS prompt activates LOTUS package ?

(1) 1-2-3 (2) Spreadsheet
(3) Lotus (4) Package 1-2-3

2. BASIC is a

(1) Machine Language (2) High-level Language
(3) Low-level Language (4) None of the above

3. What is the name of the output from either a compiler or an assembler ?

(1) OP-code (2) Object code
(3) program code (4) None of the above

4. The monochrome monitor can display upto

(1) 160 lines of characters (2) 80 lines of characters
(3) 25 x 60 characters (4) 25 column characters

5. In BASIC, the number of times the loop "FOR 1 =1 to 40 STER 2" will be executed is

(1) 20 (2) 19
(3) 18 (4) 40

6. A collection of logically related is called a

(1) field (2) record
(3) character (4) database

7. to end dbase session, we use the command

(1) Conclude (2) Quit
(3) Step (4) End

8. When a database file is modified, an additional file is created with an extension

(1) .dbt (2) .dbf
(3) .bak (3) .prg

9. The SAVE statement in BASIC transfers a program from

(1) Secondary storage to primary storage
(2) Binary storage to secondary storage
(3) ROM to RAM
(4) None of the above

10. Which of the following is not a system command ?

(1) RUN (2) LET
(3) SAVE (4) LIST

11. Which of the following commands is used to retrieve a program which was already there in the hard disk

(1) RETRIEVE (2) EDIT
(3) OPEN (4) None of the above

12. .OR. is a

(1) Mathematical operator (2) String operator
(3) Memo field (4) Logical operator

13. The file extension for an index file is __________ in dBase.

(1) .IND (2) .NDX
(3) .DBF (4) .PRG

14. ^OC in WordStar is used to

(1) Delete a line
(2) Copy a paragraph
(3) Delete a word
(4) Centre a line or word

15. To activate the 1-2-3 command menu, type ____________.

(1) * (2) \
(3) / (4) $

16. System monitor is also known as

(1) CPU (2) Keyboard
(3) VDU (4) Processor

17. Spellstar feture of WordSter is used to

(1) check spelling (2) do alignment
(3) do formatting (4) None of the above

18. A macro in Lotus 1-2-3 is a series of

(1) Values
(2) Data
(3) Logically related variables
(4) Series of 1-2-3 commands

19. The file extension to save a database file in DBASE is

(1) Compiler (2) Interpreter
(3) Assembler (4) Editor

20. ____________ translates the souce program line by line to object code.

(1) Compiler (2) Interpreter
(3) Assembler (4) Editor

21. 4GLs are mostly machine

(1) dependent (2) independent
(3) can't say (4) None of the above

22. Compiler is a

(1) Software (2) Hardware
(3) Firmware (4) None of the above

23. A BASIC program, subroutine ends with _____________ statement.

(1) GOTO (2) LET
(3) RETURN (4) PRINT

24. The built-in-function SGN( ) in BASIC returns 1 if

(1) x < 0 (2) x = 0
(3) x > 1 (4) x is infinity

25. Structured programming is a method of writing a computer program that use(s)

(1) top-down analysis for problem solving
(2) modularisdation for program structure and organisation
(3) structured code for the individual modules
(4) All of the above

26. A function calls within itself is called

(1) subroutine (2) sub-procedure
(3) recursion (4) None of the above

27. LISP stands for

(1) List Processing (2) List Programming
(3) Local Processing (4) Local Programming

28. PROLOG stands for

(1) Program Logic (2) rogramming in Logic
(3) Programming Logo (4) Programming Language

29. C++ is a __________ language.

(1) Procedural (2) OOPs
(3) AI (4) Non of the above

30. PASCAL is a ____________ language.

(1) Procedural (2) OOPs
(3) AI (4) None of the above

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

Note: In the following 40 questions, mark 1, if the statement given is true and 0 if the statement given is false.

31. Assembly language is a high level programming language.

32. In 1-2-3, ALT+F3 selects a named macro to execute.

33. Relative, Absolute and Mixed are the types of References that are supported by 1-2-3.

34. The file extension for a Spreadsheet file is .WSK.

35. to start help in 1-2-3, press F10.

36. System command temporarily involves DOS commands without going out of 1-2-3.

37. Assembly language program is specific to a particular machine architecture.

38. Most of the 3GLs are procedural programming languages.

39. Compiler is slow in debugging.

40. In BASIC a subroutine starts with a REM statement containing a phrase that identifies subroutine.

41. The built-in function FIX (X) returns the absolute value of X.

42. Top-down analysis simplifies or reduces the complexity of the rogress of problem solving.

43. Modular programming is a program divided into logically independent smaller sections which, therefore, can be written separately.

44. ATOM in USP programming is a symbol which is similar to a variable name in traditional programming language.

45. MORE command is used to transfer the label, values or formula from one part of the worksheet to another in 1-2-3.

46. ASCII stands for American Standard Code for Information Interchange.

47. In 1-2-3 the print file option directs the output to the disk file, which is given an extension name .PRI

48. Hyphenation can affect page breaks.

49. It is not possible to select two non-adjacent ranges at a time in 1-2-3.

50. DOS stands for Disk Operating System.

51. .BAT is the file extension for the Batch file of DOS.

52. To start WordStar, tye WORD at the command prompt of DOS.

53. CREATE command in DBase creates a database file.

54. SET PRINT ON is the command to give to set the printer on in DBase.

55. To modify the label file in DBase, give the command "CHANGE LABEL".

56. DATE and TIME commands in DOS are used to change the system date and system time respectively.

57. XY-graph, Line graph, Pie graph and Stacked bar graph are the types of graphs we use in DBASE.

58. CD-command of DOS is used to change drive.

59. MKDIR command of DOS is used to make a new directory.

60. DEL *.* deletes all the files in the current directory of DOS.

61. FORTRAN, the scientific language full form is "FORMULA TRANSLATION"

62. A program is set of logically related instructions that are arranged ina sequence that guides the computer to solve a problem.

63. Execution time is more in the Interpreter.

64. Errors are called as bugs.

65. Programming elements are the smallest components of the programming language.

66. Data type defines a set of related values/integers, numbers, characters etc.

67. NOT is an arithmetic operator.

68. In BASIC every statement is started with some number.

69. Varibale is a name of storage location in internal memory and the value may be changes during program execution.

70. OOPs stands form Object Oriented Programming.

Test Papers / Previous Question Papers of IGNOU CIC3 The Tools June 2005