CSC0595Questions.pdf
Document Details
Uploaded by WonHeliotrope8789
Full Transcript
CHAPTER 1: System/Classification of Computers GCE Paper 1 Questions (MCQ) 1. Vacuum tubes were used in the _____________ A. Medium Scale Integrated Circuits generation(s) of computers. B. Medium System Integrated...
CHAPTER 1: System/Classification of Computers GCE Paper 1 Questions (MCQ) 1. Vacuum tubes were used in the _____________ A. Medium Scale Integrated Circuits generation(s) of computers. B. Medium System Integrated Circuits A. First and second C. Medium Scale Intelligent Circuits B. First D. Medium system Intelligent Circuits C. Second 10. CAD stands for D. Second and third A. Computer Aided Design 2. The ___________ generation of computers used B. Computer Application in Design valves. C. Computer Algorithm for Design A. First D. Computer Analogue Design B. Second 11. What type of computers are client computers C. Third (most of the time) in a client server system? D. Fourth A. Mainframe 3. The fastest and most powerful computer category B. PDA is: C. Mini-Computer A. Personal computer D. Microcomputer B. Mini computer 12. A computer cannot 'boot' if it does not have the C. Mainframe A. Compiler D. Super computer B. Operating system 4. Desktop computers are examples of--- C. Loader A. Minicomputers D. Assembler B. Microcomputers 13. _________ represents raw facts, whereas ______ C. Supercomputers is data made meaningful D. Mainframe computers A. Information, Reporting 5. the type of computers that does most of the work in B. Data, Information a weather forecasting organization is most likely to be C. Record, Bytes a- D. Information, bits A. workstation 14. Which of the following is First Generation of B. minicomputer computer? C. mainframe computer A. EDSAC D. supercomputer B. IBM-1401 6. A key difference between the First and Second C. CDC-1604 generation of electronic computers is: D. ICL-2900 A. transistors replaced electronic circuits 15. Chief component of first-generation computer was B. transistors replaced vacuum tubes A. Transistors C. vacuum tubes replaced transistors B. Vacuum tubes and valves D. vacuum tubes replaced integrated circuits C. Integrated circuits 7. IBM 1401 is a _____________ D. Magnetic disk A. First Generation Computer 16. Second Generation Computers were developed B. Second Generation Computer during C. Third Generation Computer A. 1949 to 1955 D. Fourth Generation Computer B. 1965 to 1970 8. An application software used by Engineers to C. 1956 to 1965 design complex structures is D. 1970 t0 1990 A. CAM 17. The computer size was very large in B. CAD A. First Generation C. CAL B. Second Generation D. MIS C. Third Generation 9. MSI stands for ______ D. Fourth Generation 18. In Analogue computer C. Information A. Input is first converted to digital form D. Presentation B. Output is displayed in digital form 28. _______ Generation of computer is based on C. Input is never converted to digital form Artificial Intelligence D. None of the above 1. First 19. In latest generation computers, the instructions are 2. Second executed 3. Third A. parallel only 4. Fourth B. sequentially only 29. Computers process data into information by C. both sequentially and parallel working exclusively with D. all of the above A. Multimedia 20. The third generation computing uses-- B. Word - technology C. Numbers A. Transistor D. Characters B. Integrated circuit 30. Which is not a basic function of the computer? C. Valve A. Store data D. Artificial intelligence B. Accept input 21. modern computers are very reliable but they are C. Copy text not D. Process data A. fast 31. Help menu is available at which button? B. Powerful A. End C. Cheap B. Turnoff D. Infallible C. Start 22. What is meant by Dedicated Computers? D. Restart A. Computers used by one person only 32. Notebook, laptop, palm top, hand-held computers B. Which assigned one and only one task are coming under the category of-...-computer C. Which uses one kind of software A. Digital computer D. Which is meant for application software B. Hybrid computer 23. Which of the following is also known as the brain C. Mainframe computer of the computer D. Portable computer A. Central Processing Unit 33. Computers that combine both measuring and B. Control unit counting are called? C. Monitor A. Analog D. Arithmetic and language unit B. Digital 24. IBM stands for C. Hybrid A. International Business Machines D. All of the above B. Internal Business Management 34. In world today, most of the computers are: C. International Business Management A. Digital D. Internal Business Machines B. Analog 25. SMPS stands for C. Hybrid A. Switched Mode Power Supply D. Complex B. Start Mode Power Supply 35. PARAM is an example of C. Store Mode Power Supply A. Super computer D. Single Mode Power Supply B. Mainframe computer 26. The device used to carry Digital data on analogue C. Minicomputer lines is called D. Laptop A. Modem 36. Which of the following is available in the form of B. Modulator a PC now? C. Multiplexer A. Mainframe D. Demodulator B. Microcomputer 27. Data becomes _________ when it is presented in a C. Minicomputer format that people can understand D. Both B and C A. Processed 37. Which generation of computer is still under B. Graphs development? A. First generation A. All Time Machine B. Second generation B. Automated Teller Machine C. Third generation C. Automatic Typing Machine D. Fifth generation D. Any Time Money 38. The speed of mainframe computers is usually 43. An ATM can be used to measured in A. Load credit in some mobile phones A. Millions of instructions per second B. Open a bank account B. Instructions per second C. Top up money for transfer into a bank account C. Data per second D. Withdraw money from a bank account D. Per second 44. Keyboards and monitors were used during the 39. ___________ Is the science that attempts to ______ Generation of computers produce machines that display the same type of A. 1st intelligence that humans do B. 2nd A. Nanoscience C. 3rd B. Nanotechnology D. 4th B. Simulation 45. Which of the following statement is true? C. Artificial Intelligence A. Minicomputer works faster than 40. Computers in the 1s Generation were programmed Microcomputer using B. Microcomputer works faster than A. Object code Minicomputer B. Source code C. Speed of both the computers is the same C. Machine language D. The speeds of both computers cannot be D. Assembly language compared with the speed of advanced 41. UNIVAC is 46. The term computer is derived from _______ A. Universal Automatic Computer 1. Latin B. Unique Automatic Computer 2. Greek C. Universal Array Computer 3. French D. Unvalued Automatic Computer 4. Arabic 42. ATM stands for....... GCE Paper Two Questions 1. (i) What is computer Generation? (ii) State the main technology that characterizes the 2" and 3" computer generations. (Cam. GCE June 2019) 2. (i) State the four main categories of computers based on their size (ii) Give three examples of micro computers (iii) State the difference between an analog and a digital computer (Lycée. Boj. Mock 2019) 3. State the technology used in each of the following computer generations (i) First generation (ii) Second generation (iii)Third generation (iv) Fourth generation (Cam. GCE June 2016) 4. Complete the table below on computer generations Main Technology Generation Integrated circuit Vacuum tubes Very large integration (VLSI) Transistors Artificial Intelligence 5. Good information is one which is used and which creates values (i) State and explain 04 qualities of a good information (ii) Differentiate between primary and secondary source of data (iii)State 04 methods of collecting data 6. Expand the following acronyms as used in computing (i) NEC (v) MIPS (ix) HP (ii) UNIVAC (vi) PC (x) ENIAC (iii) VLSIC (vii) IC (xi) PDA (iv) EDSAC (viii) AI (xii) IBM 7. State two ways in which computers are used in each of the following (i) Business and commerce (ii) Banking and Finance (iii)Health Care (iv) Military (North West Regional Mock 2016) CHAPTER 2: Computer Arithmetic, Coding systems and Logic Gates 1. In the hexadecimal number system, there are 7. If the binary code for letter A is 01000001, then the ________ distinct symbols. binary code for letter C is A. 10 A 0 0 1 1 A. 010000111 B. 15 B 0 1 0 1 B. 01000011 C. 16 C. 01001101 X=A+B 0 1 1 1 D. 12 D. 01000101 2. The hexadecimal number 2E in binary is 8. The given logic gates from left to right are: _______ A. XOR and XNOR A. 101110 B. AND and NOT B. 110110 C. OR and XOR gate C. 101100 D. OR and NOT D. 111100 9. The hexadecimal number F5E in base 2 is- 3. The octal equivalence of the binary number A. 111101010111 11010110 is: ______ B. 111101011110 A. 234 C. 111101011101 B. 326 D. 111010011110 C. 624 10. What does a bit represent in computing? D. 462 A. A very small object 4. In a system in which 1 means TRUE and 0 B. A digit in base 2 means FASLE, what is the result of 1+1? C. A smallest storage unit of the computer A. 2 D. A group of 8 bytes B. 10 11. Text is stored in a computer as a sequence of C. 1 ______ D. 0 A. Decimal numbers 5. Which of the following gates is represented by B. Hexadecimal numbers the symbol on the right? C. Octal numbers A. AND gate D. Binary numbers B. OR gate 12. The decimal number 71 is written in base 2 as: C. NOR gate A. 100111 D. NOT gate B. 101111 6. Assuming that TRUE is equivalent to 1, and C. 10001 FALSE to 0, the truth table below is for the ____ gate. D. 1000111 A. NOT B. OR C. AND D. XOR 13. Which one of the following symbols represents an B. 4318 C. 2598 D. 2568 19. How many bits are there in the acronym ICT- 2019? A. 8 B. 7 C. 64 D. 56 20. If the ASCII code for letter b in binary is 01100010. Then the ASCI code for letter d in binary is: AND gate? A. 01101101 B. 01101010 14. The binary equivalent of the octal number 211 is: C. 01101100 A. 11101101 D. 01100100 B. 10110111 21. the octal number system is a system with _____ C. 10001001 symbols. D. 11110010 A. 8 B. 2 15. Simplify the expression 11001 + 1111 in the C. 16 binary system. D. 11 A. 101000 22. How many bytes are there in the word computer? B. 111000 A. 8 C. 100100 B. 16 D. 111011 C. 32 16. What does the abbreviation EBCDIC stand for? D. 4 A. Extended Binary Coded Decimal Interchange 23. The ASCII code uses _____ bits to represent Code 128 symbols. B. Extended Binary Coded Digital Interchange A. 7 Code B. 8 C. External Binary Coded Decimal Information C. 4 Code D. 6 D. Extended Binary Coded Digital Information 24. BCD stands for: Code A. Binary Coded Disk 17. The Denary number system is a number system B. Binary Coded Decimal with- C. Basic Coded Decimal A. 2 D. Bits Coded Decimal B. 10 25. There are ------ types of number systems used in C. 8 computer operations D. 16 A. 4 18. 0101011102 is represented in Octal as: B. 5 A. 2318 C. 2 D. 9 GCE Past Questions (Paper TWO) 1. a. State DeMorgan's Laws for a logic circuit with two inputs A and B b. Given the logic circuit Figure 1. Write down the logic expression for the output. Figure 1 (i) P in terms of inputs A and B (ii) Q in terms of inputs C and D (iii)R in terms of inputs A, B, C and D. c. Using binary arithmetic, evaluate (1000011)2 – (1110)2 (Cam GCE June. 2018 and 2019) 2. a. Given the logic circuit below: (i) Write the logic expression for F and G (ii) Write TWO logic expressions for H, first in terms of F and G, and then in terms of A, B, C and D. (iii)Given the following inputs to the logic circuits: A-TRUE, B-FALSE, C-FALSE, D=TRUE, determine the values for F, G and H. b. Use binary arithmetic to evaluate: (i) 11001101 – 1010 (ii) 1101011 + 1101 (Cam GCE June 2017) 3. Given the following Boolean Equation: Z = A.B + A. B a. Draw the Boolean circuit b. Complete the corresponding Truth Table below A B ̅ 𝑨 ̅ 𝑩 ̅𝑩 𝑨 ̅ 𝑨𝑩 Z 0 0 0 1 1 0 1 1 4. i. What do you understand by coding of information in computers? Assume that a coding scheme uses 8-bit binary codes to represent letters of the alphabet as shown below CODE 1000001 1000010 1000011 1000100 1000101 1000110 1000111 1001000 1001001 LETTER A B C D E F G H I ii. Observe the trend in the allocation of codes and thus determine the binary code that is coding scheme will use to represent the letter L? explain your answer iii. Using this coding scheme write the decimal code for the letter E. iv. Determine the letter which has a decimal code of 66? (Cam GCE June 2010) 5. i. What does the acronym ASCII stand for? ii. The ASCII code for letter A is 6510. Calculate the ASCII representation of letter A in binary. (Cam GCE June 2010) iii. sketch each of the following logic gates, clearly labelling inputs and outputs: NOT, AND, OR iv. Complete the following truth table (Cam GCE June 2016) A B 𝐴̅ 𝐴̅ 𝑂𝑅 𝐵 0 0 0 1 1 0 1 1 6. Convert the following binary numbers to decimal a. 1100l2 b. 00011101102 c. 111010l2 7. Convert the following Decimal to Binary i. 118 ii. 57 iii. 211 iv. 4631 8. Find the decimal equivalent of the following hexadecimal numbers i. AE34516 ii. AB10A16 iii. CE916 9. Convert the following hexadecimal number to octal i. AC01116 ii. AB0316 iii. AC20116 CHAPTER 3: INPUT AND INPUT DEVICES 1. ___________ is an input device capable of 6. The main input device required by a command line capturing hardcopy data into the computer system interface is: A. Keyboard A. Keyboard B. CD-ROM drive B. Mouse C. Flash memory stick C. Microphone D. Scanner D. joysticks 2. Which is the odd one out below? 7. Which of these devices is used to read printed A. Monitor material into a computer? B. Compiler A. Light pen C. Keyboard B. Graphics D. Printer C. Joy stick 3. A scanner is an example of a (an) D. scanner A. Optical device 8. What type of device the computer keyboard? B. Output device A. Memory C. Processing device B. Output D. Storage device C. Input 4. Which of the following input device can worsen the D. Storage condition referred toas Carpal Tunnel Syndrome? 9. A standard keyboard has ______ parts A. Mouse A. 4 B. Digital camera B. 3 C. Keyboard C. 7 D. Scanner D. 2 5. Which of the following sets constitutes input 10. What is a light pen? devices? A. A mechanical input device A. Keyboard, mouse, printer B. Optical input device B. Scanner, camera, touch screen C. Electronic input device C. Plasma screen, keyboard, joystick D. Optical output device D. Touch screen, mouse, monitor 11. Human beings are referred to as Homo sapiens, which device is called sillico sapiens? A. Monitor C. CP B. Robot D. Memory C. Computer 21. A device which is not connected to the CPU is D. Hardware called....... 12. Which of the following are input devices? A. Land-line device A. Keyboard B. On-line device B. Monitor C. Off-line device C. Mouse D. Device D. Any of these 22. You use a (n)......., such as keyboard, mouse to 13. Which of the following is also known as the brain input information of the computer? A. Output device A. Control unit B. Input device B. Central processing unit C. Storage device C. Arithmetic and language unit D. Processing device D. Monitor 23. ALU stands for 14. VDU is also called? A. Arithmetic and Logic Unit A. Screen B. Arnold logic Unit B. Monitor C. Arithmetic Universal Unit C. Both 1 and 2 D. Logic and Control Unit D. Printer 24. The CPU and memory are located on the: 15. BIOS stands for A. Expansion card A. Basic Input Output system B. Motherboard B. Binary Input Output System C. Storage device C. Basic Input Off System D. Output device D. All of the above 25. Cathode Ray Tube is a form of...... 16. ______ is the key to close selected drop-down list; A. Keyboard cancel a command and close a dialog box B. Mouse A. TAB C. Monitor B. SHIFT D. Mother board C. ESC 26. Trackball is a(n) ______ D. F10 A. Input device 17. ______ Is the key used to run the selected B. Output device command C. Programming language A. ENTER D. Software B. ESC 27. Touch screen is.... C. SHIFT A. Input device D. TAB B. Output device 18. ______ Is the functional key to display save-as C. Both A and B box D. None of the above A. F5 28. Light pen and joystick are B. F6 A. Algorithm C. F9 B. Input devices D. F12 C. Output devices 19. The term ______ designates equipment that might D. Portals be added to a computer system to enhance its 29. _______ printer is the cheapest in terms of price functionality and operating cost A. Digital device A. Inkjet B. System add-on B. Laser C. Disk pact C. Thermal D. Peripheral device D. Dot matrix 20. The primary function of the _____ Is to set up the 30........ are high end printers hardware and load and start an operating system A. Inkjet A. System programs B. Laser B. BIOS C. Thermal D. Dot matrix B. Laser 31.... C. Thermal.. are used to plot graphs and design on papers D. Dot matrix A. Trackball 31._____ are used to plot graphs and design on papers B. Arnold logic Unit A. Trackball C. Arithmetic Universal Unit B. Joystick D. Logic and Control Unit C. Light pen 24. The CPU and memory are located on the: D. Plotters A. Expansion card 32. Most keyboards use an arrangement of keys given B. Motherboard the name C. Storage device A. Dvork D. Output device B. QWERTY 25. Cathode Ray Tube is a form of...... C. CISC A. Keyboard D. MICE B. Mouse 33. LCs stands for........ C. Monitor A. Liquid Crystal Display D. Mother board B. Liquid Crystals 26. Trackball is a _____ C. Liquid Cathode A. Input device D. None B. Output device 34. Any data or instruction that are entered into the C. Programming language computer D. Software A. Input 27. Touch screen is.... B. Input device A. Input device C. Processing B. Output device D. Program C. Both A and B 35. Mr. Mbole is an English man and he wishes to D. None of the above buy a keyboard. Which type of keyboard 28. Light pen and joystick are will you advise him to buy? A. Algorithm A. QWERTZ B. Input devices B. QWERTY C. Output devices C. AZERTY D. Portals D. AWERTY 29. _____ printer is the cheapest in terms of price and 36. You are call upon by the examination board to operating cost choose a device that can be used to mark A. Laser multiple choice questions. Which of the following B. Inkjet will you choose? C. Thermal A. ATM D. Dot matrix B. OMR 30........ are high end printers C. OCR A. Inkjet D. MICR GCE past Paper Two Question 1. Define and give an example of a. Optical devices b. Audiovisual input devices c. Barcode 2. i. With the aid of suitable examples, state the meaning of input/ output device ii. Classify the following devices in a tabular manner under Input and output devices a. b. keyboard f. digital camera j. LCD c. microphone g. webcam k. CRT d. speaker h. mice l. IWB e. light pen i. monitor m. Internet telephone n. Touch screen p. trackball o. joystick q. Touch pad 3. What is Biometrics 4. Give any use of the following devices and an area in the society in which it is being used a. MICR d. ATM b. BCR e. IWB c. OMR CHAPTER 4: OUTPUT AND OUTPUT DEVICES 1. Which printer uses a combination of light beam and A. Keyboard electro photographic techniques? B. Mouse A. Dot matrix printer C. Visual Display Unit (VDU) B. Daisy wheel printer D. None of the above C. Line printer 9. VGA is D. Laser printer A. Video Graphics Array 2. Which of the following is an example of an impact B. Visual Graphic Array printer? C. Volatile Graphic Array A. Ink-jet printer D. Video Graphic Adapter B. Laser printer 10. The capacity of 3.5 inch floppy disk is C. Thermal printer A. 1.40MB D. Line printer B. 1.44GB 3. The resolution of a flat screen monitor is measured C. 1.40GB in D. 1.44MB A. Pictures per inch 11. Which of the following is a part of the Central B. Pixels Processing Unit? C. Dots per inch A. Printer D. Aspect ratio B. Keyboard 4. The characteristic feature of a VDU which C. Mouse determines image sharpness is D. Arithmetic and Logic unit A. Color 12. What does DMA stand for? B. Aspect Ratio A. Distinct Memory Access C. Resolution B. Direct Memory Access D. Dot pitch C. Direct Module Access 5. Which of the following is an example of input? D. Direct Memory Allocation A. Reports 13. The output quality of a printer is measured by B. Documents A. Dot per inch C. Memory B. Dot per seq. inch D. Music C. Dots printed per unit time 6. Every device that is attached to the computer is D. All of the above connected to 14. Human beings are referred to as Homo sapiens, A. System board which device is called sillico sapiens? B. Main board A. Monitor C. Mother board B. Robot D. Backboard C. Computer 7. When the computer is rebooted or lost power, the-- D. Hardware restore settings 15. Examples of output devices are A. BIOS A. Screen B. CMOS B. Printer C. Battery C. Speaker D. OS D. All of the above 8. A typical example of an output device is 16. Which of the following is also known as the brain A. CD of the computer? B. DVD A. Control unit C. ROM B. Central processing unit D. RW C. Arithmetic and language unit 26. Cathode Ray Tube is a form of...... D. Monitor A. Keyboard 17. VDU is also called? B. Mouse A. Screen C. Monitor B. Monitor D. Mother board C. Both 1 and 2 27. Trackball is a.. D. Printer A. Input device 18. BIOS stands for B. Output device A. Basic Input Output system C. Programming language B. Binary Input Output System D. Software C. Basic Input Off System 28. Touch screen is....... D. All of the above A. Input device 19. The term _____ designates equipment that might B. Output device be added to a computer system to enhance its C. Both A and B functionality D. None of the above A. Digital device 29. Light pen and joystick are B. System add-on A. Algorithm C. Disk pact B. Input devices D. Peripheral device C. Output devices 20. А _____ is a microprocessor-based computing Portals device 30. ______ printer is the cheapest in terms of price A. Personal computer and operating cost B. Mainframe A. Inkjet C. Workstation B. Laser D. Server C. Thermal 21. A device which is not connected to the CPU is D. Dot matrix called............. 31. ______ are high end printers A. Land-line device A. Inkjet B. On-line device B. Laser C. Off-line device C. Thermal D. Device D. Dot matrix 22. The ________ is the amount of data that a storage 32. _________ are used to plot graphs and design on device can move from the storage medium to the papers computer per second A. Trackball A. Data migration rate B. Joystick B. Data digitizing rate C. Light pen C. Data transfer rate D. Plotters D. Data access rate 33. Physical structure of a computer is called: 23. What is the other name for programmed chip? A. Software A. RAM B. Hardware B. ROM C. Human ware C. LSIC D. All of the above D. PROM 34. Most keyboards use an arrangement of keys given 24. The CPU and memory are located on the: the name A. Expansion card A. Dvork B. Motherboard B. QWERTY C. Storage device C. CISC D. Output device D. MICE 25. Reusable optical storage will typically have the 35. BIOS stands for acronym A. Basic Input Output System B. Basic Input and Output devices D. None of the above C. Basic Information and Output system GCE Paper Two Questions 1. i. Give two differences between impact printer and a non-impact printer. ii. Give an example of each type of printer in (i) above. (Cam GCE June 2019) 2. i. Explain the difference in the functioning of impact and non-impact printers. ii. Explain the functioning of dot matrix printers (Cam GCE June 2015) 3. State two advantages of LCD over CRT monitors. (Wouri mock 2018) 4. In a tabular format, outline 04 differences between a. Impact and Non-impact printers b. LCDs and CRTs 5. State two examples each of a. Impact b. Non-impact printers c. Output devices d. Hard copy information e. Softcopy information 6. A multifunction printer can be used for printing, photocopying, and scanning documents. Explain how it can function as: a. An output device b. An input device c. A shared resource in a network 7. Explain the functioning of dot matrix printer. List two advantages of a dot matrix printer over other printer types. (Cam GCE June2013, 2015) 8. Distinguish between: a. output and output devices b. Softcopy output and hardcopy output 9. With the aid of suitable example in each case, state in each case the meaning of a. Input device b. Output device c. Input/output device (МОСК 2015) 10. Draw and complete the table in your answer booklet TYPE FUNCTION Memory ROM CMOS ALU VDU UPS CHAPTER 5: STORAGE DEVICES 1. Which of these enables a computer to handle B. ROM programs that require more memory than available C. USB stick RAM? D. Hard disk A. virtual memory 3......... is an example of a solid-state storage device? B. Cache memory A. Diskette drive C. ROM B. CD-ROM drive D. Register C. Hard disc drive 2. Which of the following is a primary storage D. USB flash drive device? 4. Given that a computer uses one byte to represent a A. RAM character, how many bits are used to represent 20 characters? 14. RAM is also called A. 160 A. Primary memory B. 20 B. Long memory C. 1600 C. Permanent memory D. 200 D. Read/ Write memory 5. Which of the following storage devices has the 15. What kind of memory is both static and non- fastest storage speed? volatile? A. RAM A. RAM B. ROM B. ROM C. Cache C. BIOS D. Hard disc D. CACHE 6. One gigabyte is equivalent to.... 16. A device which is not connected to the System A. 1024 bytes unit is called..... B. 1024 kilobytes A. Land-line device C. 1024 Megabytes B. On-line device D. 1024 Terabytes C. Off-line device 7. Given that 4KB is equivalent to 4096 bytes, how D. Device much is 2KB? 17. The........ is the amount of data that a storage A. 1024 device can move from storage medium to the B. 3072 computer per second C. 2048 A. Data migration rate D. 2000 B. Data digitizing rate 8. RAM is also called C. Data transfer rate A. Primary memory D. Data access rate B. Long memory 18. What is the other name for programmed chip? C. Permanent memory A. RAM D. Read/ Write memory B. ROM 9. All of the following are examples of storage C. LSIC devices except: D. PROM A. Printers 19. Which of the following is not connected directly B. Hard disk drives to the motherboard? C. Floppy disk drives A. Keyboard D. CD drives B. CMOS battery 10. The CPU and memory are located on the: C. RAM A. Expansion card D. Processor B. Motherboard 20. ROM programmed using electronic impulse is C. Storage device known as... D. Output device A. EEPROM 11. Reusable optical storage will typically have the B. EPROM acronym C. EEEPROM A. CD D. PREROM B. DVD 21. The primary storage device in a computer is. C. ROM A. RAM and hard disk D. RW B. Hard disk and ROM 12. The most common type of storage device is C. Flash drive and RAM A. Steel D. RAM and Cache B. Optical 22. _____ Are the smallest accessible unit in a hard C. Magnetic disk? D. Flash A. Tracks 13. Which of the following is not a storage medium? B. Sectors A. Hard disk C. Cylinder B. Flash drive D. Record C. DVD D. Scanner 23. The portion of a hard disk reserve for temporal 24. Given that 4KB is equivalent to 4096 bytes, how storage of data as an extension of main memory much is 2KB? is known as.............memory A. 1024 A. Digital B. 3072 B. Virtual C. 2048 C. Access D. 2000 D. Reserved GCE Paper Two Questions 1. A folder in a computer contains files with total size of 7GB. In order to backup the files, a number of CDs of size 700 MB are provided. a. What do you understand by file back up? b. Give two reasons for file back up. c. Convert 7GB to MB d. How many CDs are required to backup all the files in the folder? (Cam. GCE June. 2019) 2. How many CD of 700MB capacity can contain 100 newsletters from a digital library assuming that the average number of characters of each newsletter is 1000. Assume one character occupies 8bytes. 3. a. Briefly describe, giving examples, the roles of the following: i. primary storage ii. secondary storage b. i. What is the difference between volatile and non-volatile memory? ii. Give an example of each type of memory iii. What does VDU stand for? (North West Regional MOCK 2012) 4. a. Given the following characteristics of a hard disk. Number of platters 2 Number of tracks per platters 100 Sectors per track 10 Bytes per sector 512 Calculate: i. The storage capacity of the hard disk in Bytes ii. The exact storage capacity of the hard disk in kilobytes iii. The approximate storage capacity (Cam. GCE June. 2009) b. In relation to computer storage, explain the functions of the following components Read Only Memory Random Access Memory Hard Disk (Cam GCE June. 2018) 5. Outline the difference between the following i. Volatile and non-volatile memory ii. DVD and CD ROM Discs (North West Regional MOCK 2015) 6. State two differences between a floppy disk and a compact disc as storage media (Cam GCE June. 2013) 7. Assume that Microprocessor A has a processing speed of 300 MHz and can executes instructions in each cycle. Microprocessor B has a processing speed of 250 MHz and can execute 5 instructions in each cycle. Which of the two microprocessors will result in fast computations? State the reason (Cam GCE June. 2016) 8. Fully expand each of the acronyms i. CMOS vii. TB xiii. DRAM ii. RAM viii. UPS xiv. MROM iii. ROM ix. CD xv. PROM iv. KB x. DVD xvi. EEPROM v. GB xi. CD-R xvii. EPROM vi. MB xii. CD-RW 9. Differentiate between a. Hard disk and compact disk b. Tracks and records CHAPTER 6: COMPUTER SOFTWARE 1. Before a program is run, it must be loaded in the: B. That application a user needs for the computer A. ROM to work B. Hard disk C. That software a user needs on the computer C. RAM D. That which can perform many specific D. Virtual memory computer tasks 2. The process that checks the functionality of 10. A program like Microsoft Office Access 2007 is hardware and copies the operating system onto the an example of RAM is referred to as: A. Freeware A. Booting B. A software suite B. Input C. A database management system C. Processing D. A system software D. Storage 11. When using a command line interface, the signal 3. Android is a(n) indicating that the computer is waiting for input from A. Operating system the user is known as a (an)____ B. A generation of young people A. Event C. Application software B. Prompt D. Type of smartphone C. Interrupt 4. Software commonly used to open web pages is D. Delay called: 12. _______ are specific to users' needs A. Search engine A. System software B. Homepage B. Application software C. Browser C. Compilers D. URL D. Assemblers 5. SOFTWARE that manages hardware and other 13. A set of programs that work together to control installed software is called? the operations of the computer A. Device driver A. Software B. Application software B. Command line interface C. Operating system C. Hardware D. Utility software D. Components 6. An open-source software is one that: 14. NOS stands for A. Has no license 1. Node operating system B. Can be modified, distributed freely. 2. Network Operating System C. Is downloaded from the internet 3. Non-open software D. Is not protected from viruses 4. Non-Operating software 7. A set of instructions that a computer executes is 15. ___________ are system software to facilitate called? editing of text and data A. An application A. MS word B. A program B. Editors C. An algorithm C. Power point D. A software D. MS publisher 8. Drivers are: 16. Operating systems, device drivers, programming A. Software that enables hardware to function language comes under B. Software that runs applications A. System software C. Hardware that controls software B. Application software D. Application software program C. Utilities 9. The basic definition of application software is: D. All of the above A. That which can primarily perform useful 17. _________ software enables people who are computer work for the user geographically dispersed to have an online meeting A. Video taping B. Videoconferencing B. Connecting the computer to the electric switch C. Teleworking C. Increasing the memory of the computer D. Multimedia messaging service D. The process of shutting down the computer 18. Software designed to carry out specific end user 27. Software that allows a team to have an electronic task such as calculation of payroll is known as “face-to-face” meeting when members are A. Specialist software geographically dispersed is B. Bespoke software A. E-mail software C. Company software B. Chat room software D. Utility software C. E-messaging software 19. The term video conferencing means D. Videoconferencing software A. Running a conference using a video projector 28. Copyright laws to facilitate discussion A. Prevent and punish people who duplicate B. Holding meetings using both audio and video open-source software links to connect participants remotely B. Compensate authors for an intellectual part C. Use of video and audio facilities to run a C. Protect authors of their intellectual property conference in a large hall D. Define principles in the field of authorship D. Use a large computer screen to manage an 29. which of the following is performed by an outdoor conference application software? 20. The acronym pdf stands for A. Memory management A. Picture document format B. Providing user interface B. Portable document format C. Information system management C. Picture document file D. Scheduling of computer processes D. Portable document file 30. The software that is used to locate websites on the 21. Operating systems, editors and debuggers comes internet using key words in files and documents is under: called A. System software A. Internet browser B. Application software B. Search engine C. Utilities C. Spyware D. All of the above D. Uniform Resource Locator (URL) 22. A program 31. The ability of software to translate voice into text A. Is a device that performs a sequence of is known as operations specified by instructions in memory A. Speech recording B. Is a sequence of instructions B. Speech recognition C. Is the device where information is stored C. Speech translation D. None of the above D. Speech digitization 23. What is an Excel 32. Portability of software refers to its ability to A. A Graphic program A. Work on different platforms B. A spread sheet B. Maximize the use of time and space C. A presentation software C. Easily recover from minor errors D. A hardware D. Be understood with little or no training 24. The primary purpose of software is to turn data 33. An operating system that permits many people to into- perform many operations at the same time is called A. Information A. Multi-tasking B. Programs B. Multi-threading C. Objects C. Multi-users D. Websites D. Multi-operations 25. What does DOS stands for 34. A graphical representation of software or file is A. Dynamic Operating System known as: B. Disk Originating System A. Icon C. Disk Operating System B. File D. Default Operating System C. Folder 26. What do you understand by the term booting? D. Picture A. The process of starting a computer from the 35. An unauthorized duplicating and selling of music power off position is a breached of A. Human right 41. The Graphical User Interface is also known as the B. Copyright act WIMP system. WIMP stands for C. Protection act A. Windows operating system D. Privacy act B. Windows icons menus and pointers 36. Software used to create and modify text is known C. Windows inputs nark-up as? D. None of the above A. Text editor 42. Software stored in ROM is known as B. Text manager A. Firmware C. Text creator B. Freeware D. Text modifier C. Shareware 37. The process of loading the operating system into a D. WIMP computer's memory is called ----- 43. A computer window can be defined as A. Dual loading A. A rectangular area that contains a document B. Boot-strapping B. The window of the computer C. Multi-threading C. The window of a laptop and desktop D. Simulation D. The window of a house 38. The central part of an operating system is known 44. The main difference between a spread sheet and a as word processing program is that A. Hub A. Spreadsheets are user friendly than word B. Kernel B. Word is an application program C. Command interpreter C. Word is used for typing text wile spreadsheets D. Device driver are used for calculation 39. The part of an operating system that understands D. None of the above and executes commands that are entered interactively 45. A program at the time of execution is known as a by a human being (n)..... A. Kernel A. Thread B. Command interpreter B. Process C. System call C. Algorithm D. Directory D. Instruction set 40. The length of time it takes to run a process from 46. The length of time it takes to run a process from initialization to termination is known as- initialization to termination, including all the waiting A. Action time time. B. System time A. Latency Time C. Turnaround Time B. Turnaround Time D. Calling C. I-Time D. E-Time GCE Paper Two Questions 1. Explain what you understand by the following: a. System software b. Operating system c. Device drivers d. Utility software (Cam GCE June. 2019) 2. Define the following software attributes a. Portability b. Efficiency c. Usability d. Scalability e. Reliability f. Security 3. a. What are the features of a good software that you would consider when buying software? b. What is productivity software? Give any two examples. (Cam GCE June 2013) 4. A multimedia center in Bamenda got some forty (40) new computers and contacted Mrs. Mighty to buy some software in which they will need to train individuals on the following creating and editing text documents organizing and managing large quantity of data designing cards working with numbers, calculation or graph doing presentation Mrs. Mighty goes to Miracle Informatique to buy the application (s). a. list the application software needed to train these individuals b. Enumerate for criteria she would consider in selecting a good software. c. In addition to the application software above, which type of software is needed to be bought to be installed on the computer for it to work? Explain 4 functions of this software 5. Differentiate between the following giving an example in each case a. application software and custom written software b. database software and spreadsheet software c. system software and application software 6. The management of a hospital wants to introduce a computerized system for staff and patients a. What category of application software would you recommend for handling data in the above case? b. Give two examples of this category of application software 7. Describe the following types of human computer interfaces a. Command Line Interface b. Graphical User Interface c. Menu-driven Interface (Cam GCE June.2017) 8. John wants to set up a company to train people on Computer Literacy. Some of the people to train only want to know about using machines running the Microsoft Windows Operating System. While others only want to know about using machines running the Linux operating system. John decides to set up two personal computer laboratories: Lab A with Microsoft Windows computers and Lab B with Linux Computers. Answer the following questions in relation to the scenario presented above. a. What do you understand by the term computer literacy? b. state FOUR functions of an operating system c. Answer the questions in this section o explain the types of training that John should provide his trainees. i. List FIVE hardware components that trainees need to know about so that they can understand what happens from the time they type in a document to the time a hard copy is produced. ii. Name ONE hardware device, and the most relevant kind of application software that can be used to improve the typing skills of the trainees. iii. State the category of network application software that must be installed on each computer to enable easy access to the web. Give two examples of this category of software. iv. List FOUR important categories of application software that John should include in the training. For each of them, state what it is used for. Your list should NOT include your answer in (iii) above. (Cam GCE June.2017) 9. a. State the difference between the following pairs of terms. Give an example in each case i. System software and application software ii. Primary storage and secondary storage b. What is an operating system? c. Give two Examples of operating Systems d. Outline four functions of an operating system e. State the meaning of the following terms i. Human-computer interface ii. Command Line interface iii. Graphical User interface (Cam GCE June. 2016) 10. Fully expand the following acronyms a. GUI d. MS-DOS g. UNIX b. CLI e. DOS h. DBMS c. WIMP f. OS 14. a. What do you understand by a user interface? b. Give one characteristic of each of the following user interface types: i. Graphical User Interface ii. Voice interface iii. Command Line Interface CHAPTER 7: COMMUNICATIONS AND NETWORK DEVICES 1. Data can be transmitted between device A and B B. Computer networking is a group of inter simultaneously. This mode of data transmission is connected systems that provide sharing referred to as: services and interacting by means of a A. Half duplex shared communication link B. Simplex C. Computer networking is a collection of C. Full duplex computers and devices connected to the D. Multiplex super, mainframe and microcomputer to 2. In networking, the abbreviation MODEM stands facilitate the sharing of information for: D. Computer networking is a collection of A. Modular and Demodulator computers and devices connected to each B. Modulator and Demodulator other C. Modulation and Demodulation 8. A set of computers in an office building are D. Moderation and Demoderation connected together so that staff can share files, 3. For signal s to travel long distances, their strength printers and other resources. What is this needs to be boosted by a device called a: arrangement of computers called? A. Modem A. WAN B. Repeater B. LAN C. Router C. www D. Multiplexer D. PAN 4. SIM stands for: 9. "MAN" stands for..... A. Software Identity Module card A. Maximum Area Network B. Simulation Identity Module card B. Minimum Area Network C. Single Inline Module C. Main Area Network D. Software Installation Module card D. Metropolitan Area Network 5. In a certain computer laboratory, the server is 10. Which of the following is a network topology? placed at one corner of the room and connected A. LAN directly to each of the other computers through a B. WAN switch. This is an example of a ________ C. MAN topology D. BUS A. Star 11. Which of the following is a type of Network B. Bus A. Ring C. Peer-to-peer B. Bus D. Ring C. Star 6. A transmission mode that allows data to move in D. PAN both directions at the same time is called _____ 12. VOIP stands for..... transmissions A. Voice Over IP A. half- duplex transmission B. Video Over IP B. full-duplex transmission C. Viruses Over IP C. simplex transmission D. Virtual Over IP D. synchronous transmission 13. LAN stands for...... 7. Which of the following is NOT the correct A. Limited Area Network definition of computer networking? B. Logical Area Network A. A computer networking is a group of two or C. Local Area Network more computers that are connected to one D. Large Area Network another for the purpose of exchanging and 14. ______ are set of rules and procedures to control sharing resources data transmission over the internet A. IP Address B. Domains B. Link two segments of a large network C. Protocol C. Connect two similar network links or channels D. Gateway D. Ensure that two network has a repeated set of 15. NOS stands for _________ signals A. Node Operating System 23. Which of the following is an arrangement of B. Non-Open Software physical transmission media in order of increasing C. Network Operating System ability to maintain high quality signals over a long D. Non-Operating System distance? 16. In networking terminology, UTP stands for A. Twisted pair, Coaxial, Fibre Optic Cables A. Unshielded T-connector port B. Coaxial, Twisted Pair, Fibre Optic cables B. Unsheiled Twisted Pair C. Twisted pair, Fibre optic, coaxial cables C. Uniformly Terminating Port D. Twisted, fibre optic, coaxial cables D. Ubiquitous T-connector Port 24. Which of the following protocol is used to transfer 17. It is the process by which two devices initiate Multimedia information? communication A. ftp A. Protocol B. http B. Polling C. smtp C. Initiation D. TCP/P D. Handshaking 25. Social networking means to. 18. The acronym MODEM as a networking device A. Paste your picture on Facebook on the internet stands for B. Send and receive social sites freely on the A. Modular Demodulator internet B. Modulator Demodulator C. Interact with internet sites to share and gain C. Modulation Demodulation information D. Moderation Demodulator D. Have a relation between two or more persons 19. Transmission of signals between a Television set 26. _______ is a measure of information or carrying and its remote control is na example of capacity of a signal A. Infrared transmission A. Bandwidth B. Optic-Fibre transmission B. Bit rate C. Full-Duplex Transmission C. Baseband D. Radio Wave Transmission D. Baud rate 20. In a client-server network 27. The role of multiplexer in a data communication is A. The server responds to the requests of the client A. Multiply the number of communication B. The server initiates communication with the channels client B. To channel signal form different sources C. The client provides resources to the server through a single path D. Both the client and the server can provide C. To separate signals into its original components resources as need arises D. Link the CPU to the different peripheral devices 21. The main reason for the twisting of a twisted pair 28. The transmission of signal in which each data bit is cable is transmitted under the control of a clock is known as A. Allow for much cable within a short distance A. Time transmission B. To reduce the effect of electromagnetic B. Synchronous transmission interference C. Asynchronous transmission C. For convenience or policy of the company D. Bit wise transmission D. Increase the quantity of signals/data to be 29. The acronym MMS in communication stands for..... transmitted A. Multimedia Management System 22. The main role of a repeater as a networking device B. Multimedia Messaging Service is to C. Multiple Messaging Service A. Amplify weakened signal D. Multiple Management Service GCE Paper Two Questions 1. State the role of each of the following in relation to data transmission. a. Receiver b. Transmitter c. Protocol (Cam GCE June. 2019) 2. i. What do you understand by a Network Topology? ii. With the aid of well labeled diagrams briefly explain the following a. star topology b. ring topology c. bus topology iii. Outline 03advantages and 02 disadvantages of the above topologies (North West Regional Mock 2016) 3. i. what is a computer network? ii. Name any two advantages and disadvantages of a network 4. a. With the aid of diagram, explain the following operational modes of communication channel i. Full-duplex ii. Broadcast iii. Multiplexing and Demultiplexing b. What is a computer network? c. Give any two differences between a Local Area Network and a Wide Area Network. d. What do you understand by the term network topology? e. With the aid of a sketch in each case state and describe two network topologies. (Cam GCE June.2014) 5. a. Distinguish between intranet and Extranet b. Explain with the aid of an illustration the function of a modem in a Wide Area Network 6. With the help of a sketch in each case, briefly explain each of the following a. computer network b. Client-server network c. peer-to-peer network (Cam GCE June.2013) 7. a. Define the term: Communication Channel, protocol and Node b. Explain the meaning of the following modes of transmission i. Serial transmission ii. Synchronous transmission iii. Asynchronous transmission (Cam GCE June. 2016) 8. What are the roles of TCP/IP and HTTP protocols? (Cam GCE June. 2016) 9. a. State two advantages of fibre optic over shielded twisted pair cables b. Briefly explain the following as use in computer network i. Bandwidth ii. Optic fibre (Cam GCE June. 2016) 10. Explain the difference between Synchronous and Asynchronous data transmission. (Cam GCE June.2017) 11. a. A school has decided to create a LAN to facilitate data and information flow. The school also intends to connect the LAN to the internet. Describe with diagrams TWO different topologies that the LAN can have. b. Define: i. Computer network ii. Network protocol iii. Bandwidth c. Briefly describe the functions of each of the following networking devices: i. Router ii. Multiplexer iii. Network Interface Card (Cam GCE June.2015) 12. Briefly describe the role of the following networking devices a. Network Interface Card b. Modem c. Router (Cam GCE June. 2018) 13. Complete the table below on wireless networks by giving an example of wireless technology used Type of network Example of wireless technology used Wireless PAN Wireless LAN Wireless MAN Wireless WAN 14. What do you understand by a microwave ink? 15. Give one similarity and one difference between Wi-Fi and WiMAX 16. Distinguish between an uplink and downlink CHAPTER 8: THE INTERNET 1. The abbreviation URL stands for: 8. A set of standardized rules that communicating A. Unified Resources Location devices use to share information and resources is B. Uniform Resource Location called: C. Uniform Resource Locator A. Language D. Unified Resource Locator B. Protocol 2. Software commonly used to open web pages is C. Address called: D. handshaking A. Homepage 9. ________ is the largest network B. Search engine A. LAN C. Browser B. Intranet D. URL C. Extranet 3. Sending a file from your computer to a server is D. Internet called: 10. The first Web browser is A. Downloading A. Mosaic B. Uploading B. Netscape C. Reading C. Internet explorer D. Writing D. Collabra 4. The internet is a gigantic network but the World 11. The software that is used to locate websites on the Wide Web is a (an) internet using keywords in files and documents is A. Gigantic database called B. Gigantic interconnection of computers A. Internet browser C. Service that lets users access a gigantic B. Search engine collection of documents C. Spyware D. Internet protocol D. Uniform Resource Locator (URL) 5. Which one of the following protocol is used to 12. A web site's main page is called its: manage the transfer of Web pages? A. Home page A. FTP B. Browser page B. НТТР C. Search page C. SMTP D. Bookmark D. TCP/IP 13. What is an E-mail 6. Which one of the following protocols is responsible A. An electronic mail that established person to for addressing packets so that they can be routed to person connectivity their destinations? B. It enables us to communicate at any time of A. Internet protocol the day or night from any location B. Transmission control protocol C. Both A and B C. File Transfer Protocol D. Either A or B D. Post office Protocol 14. What do you need to put your web pages on the 7. Facebook is a web service offered for users all www: around the world. What best describes its use among A. A connection to the internet the options below? B. A web browser A. Computer network C. A web server B. Facebook account D. All of the above C. Computer account 15. SIM means D. Social network A. Speed in Mobile B. Special Identity Module C. Subscriber Identity Module D. Standard Identity Module D. None of the above 16. Which of the following refers to a special type of 26. Which among the following is not an internet video camera used for broadcasting images on the browser: internet: A. Netscape Navigator A. webcam B. Chrome B. icam C. Drupal C. camera D. Opera D. none of the above 27. WWW provides standardized access to: 17. the founder of E-Mail A. GOPHER A. James Gosling B. TELNET B. shiva Ayyadurai C. FTP C. Ajay V. Bhatt D. All of the above D. None 28. World Wide Web (WWW) was proposed by 18. Which is a valid program to access the internet? A. Bill Gates A. Access B. Bill Rogers B. Front Page C. Tim Berners Lee C. Netscape D. None of these D. None of the above 29. URL stands for: 19. ARPANET means ________ A. Uniform Resource Locator A. Advanced Research Project Agency Network B. Uniform Resource Library B. Advanced Routine Project Network Agency C. United Resource Locators C. America Research Project Agency Network D. None of the above D. None of the above 30. net domain is used for 20. ISP means __________ A. Educational institution A. Internet service Providers B. Internet Infrastructure and service provider B. Internet source Providers C. International organization C. Internet System Providers D. None of theses D. None 31. OSI stands for _______ 21. NAT stands for: A. Open System Interconnection A. Network Address Translator B. Open-Source Internet B. Network Access Translator C. Open System Interaction C. Network Acquired Translator D. Operating System Interconnection D. None of the above 32. The OSI reference model is 22. Role of IP addressing is: A. Worthless A. A name indicates what we seek B. A protocol B. An address indicates where it is C. Not a protocol C. A route indicates how to get there D. None of the above D. All of the above 33. The OSI model divides network communications 23. An internet Protocol Address (IP address) is into.........Layers A. A numerical label assigned to each device (e. A. 7 computer, printer) participating in a computer B. 4 network C. 9 B. It working for the communication D. 3 C. Both of the above 34. Which layer of the OSI represents data in a D. None of the above particular format? 24. IP stands for.... A. Presentation Layer A. Internet Protocol B. Transport Layer B. Internal Protocol C. Session Layer C. Interior Protocol D. Physical Layer D. None of the above 35. To view a web page, we use a ________ 25. TCP stands for ____________ A. Web processing application A. Tools Control Protocol B. Browser software B. Transmission Control Protocol C. Web authoring C. Transfer Control Protocol D. System software 36. The internet can be defined as D. Modem A. World Wide Web 40. In communication satellite, multiple repeaters are B. Network of computer networks that share known as resources A. Detector C. Interconnection of computers that share B. Modulator resources across regions C. Stations D. World Wide network of computers that share D. Transponders resources 41. The protocol used to receive Electronic Mail over 37. In OSI network architecture, the dialogue control the internet is and token management are responsibility of A. TCP/IP A. Session layer B. SMTP B. Network layer C. FTP C. Transport layer D. VOIP D. Data link layer 42. The buying and selling of stocks over the internet 38. In OSI network architecture, the routing is is called performed by A. E-commerce A. Network layer B. E-shopping B. Data link layer C. E-banking C. Transport layer D. E-trading D. Session layer 43. ______ are used to identify a user who returns 39. Which of the following performs modulation and from a website demodulation? A. Cookies A. Fiber optic B. Plug-in B. Satellite C. Scripts C. Coaxial cable D. ASPs GCE Paper Two Questions 1. Briefly explain the major use of the internet in each of the following fields: i. Health care and Medicine ii. Education iii. Recreation (Cam GCE June.2015) 2. i. Give the difference between a. Intranet and extranet b. The internet and World Wide Web (WWW) c. Browser and search engine ii. Give two advantages and two disadvantages of using social media in a school. iii. State any two social media platforms (Cam GCE June.2019) 3. a. Define Netiquette b. State 04 Netiquette with the use of E-Mails 4. Distinguish between the following terms used in relation to computer software and files a. Updating and upgrading b. Uploading and downloading (Cam GCE June.2013) 5. a. What is Cybercrime? b. Name any TWO common Cybercrimes (Cam GCE June.2018) 4. a. Write down the abbreviation WWW in full b. Give the difference between WWW and the internet (Cam GCE June. 2018) 5. Distinguish Between a. Internet Telephony and Videoconferencing c. E-commerce and E-learning b. Cyberspace and Cybercrime d. E-Mail and E-Commerce 6. a. What is an Electronic Mail? b. How is an Electronic Mail commonly called? c. Give 03 advantages and 03 disadvantage s of using an E-Mail 7. Define the following terms giving an example in each case 1. ISP 2. Search Engine 3. Internet Explorer 8. The paragraph below contains five (05) abbreviations. "Most ISPs in Cameroon provide internet connectivity to major banks. Internet connectivity requires the TCP/IP protocol, while web use requires the HTTP protocol. Interesting how some banks prefer DSL, some go for ADSL and some others for broadband connections." a. Write the 05 highlighted abbreviations in full b. What are the roles of the TCP/IP and HTTP protocols? (Cam GCE June. 2016) 9. Define the following terms of online internet services giving TWO advantages and ONE disadvantages of each a. E-commerce b. E-banking c. E-health 31. Fully expand the following acronyms as used in the Internet i. ARPANET iv. VOIP vii. HTTP ii. EFT v. TCP iii. WWW vi. ISP 32. a. What is the name of the symbol @? b. How is the part after @ called in an email address? c. How is the part before @ called? Chapter 9: DATABASE 1. in a database, a field that can be used to uniquely A. Stack identify a record is: B. Queue A. key field C. Harsh table B. secondary field D. Binary tree C. foreign key 7. The rule that helps to ensure quality of D. optional key field information in a database is 2. In a database, a field of type integer can: A. Party check A. also accept a real number B. Entity-Relationship B. accept any alphanumeric character C. Primary key C. accept only whole numbers D. Data integrity D. also accept a currency symbol 8. The data manipulation subsystem of DBMS 3. A well-designed database of employees in a consists of company would place all the information for a A. Database Forms single employee in: B. Report Generators A. a table C. Query by examples B. a field D. All of the above C. a record 9. The word "attributes" in a database are properties D. a cell of 4. ________ is used to retrieve specific information A. A database from a database? B. A field A. Data dictionary C. A record B. Query D. An entity C. Report generator 10. The key in a database that uniquely identifies D. form a record in a table is 5. You organized files by storing them in A. Secondary key A. Folders B. Foreign key B. Archives C. Primary key C. Indexes D. Unique key D. Lists 11. The relational database environment has all of 6. A linear list whose elements are inserted in a the following components except Last-in-First-Out order is a A. Users B. Separate files A. Spreadsheet program C. Database B. Word processing program D. Query languages C. Graphics program 12. Database Management Systems are intended D. All of the above to 21. Which of the following fields in a student file A. Eliminate data redundancy can be used as a primary key? B. Establish relationship among records in A. Class different files B. Social security Number C. Manage file access C. GPA D. Maintain data integrity D. Major E. All of the above 22. In the DBMS approach, the application 13. Choose the RDBMS which supports full- programs perform the fledged client server application development A. Storage function A. dBase V B. Processing function B. Oracle 7.1 C. Access control C. FoxPro 2.1 D. All of the above D. Ingress 23. A set of programs that handle a firm's database 14. A Form defined responsibilities is called? A. Where data is placed on the screen A. Database Management System (DBMS) B. The width of each field B. Database Processing System (DBPS) C. Both A and B C. Data Management System (DMS) D. None of the above D. All of the above 15. A top-to-Bottom relationship among the items 24. A command that lets you change one or more in a database is established by a fields in a record is A. Hierarchical Schema A. Insert B. Network schema B. Modify C. Relational schema C. Lookup D. All of the above D. None of the above 16. The function of a database is... 25. Large collection of files are called....... A. To check all input data A. Records B. To check all spelling B. Database C. To collect and organize input data C. Fields D. To output data D. Sectors 17. What is the language used by most of the 26. A transparent DBMS DBMSs for helping users access data? A. Cannot hide sensitive information from users A. High level language B. Keeps its logical structure hidden from users B. SQL C. Keeps its physical structure hidden from users C. Query Language D. Both B and C D. 4GL 27. If a piece of data is stored in two places in the 18. The model for a record management system database, then might be A. The storage space is wasted A. Handwritten list B. Changing the data in one spot will caused data B. A Rolodex card file inconsistency C. A business form C. It can be more easily accessed D. All of the above D. Both A and B 19. In a large DBMS 28. In database, ______ is the term use to describe A. Each user can "see" only a small part of the the correctness of data entire database