1.

A multimedia resource may combine several elements such as:

A. Video and text only
B. Text and graphics only
C. Text, sound, graphics, animation and video
D. Text and sound only
2. Video conference is best described as a communication link used to conduct meetings between people
A. In different location, which may be international
B. In the same location
C. In the same enterprise
D. In different locations, which must be in the same country
3. Which of the following names designates an integrated software package?
A. Internet explorer
B. Microsoft word 2003
C. Microsoft office 2003
D. Microsoft windows 2003
4. Which of the following is an input device
A. Modem
B. Scanner
C. Loud speaker
D. Printer
5. The acronym LAN stands for
A. Local area network
B. Large area network
C. Local area networker
D. Logical area network
6. Which of the following is not a network topology
A. Ring
B. Token ring
C. Star
D. Bus
7. A collection of data which is store in a logical form is known as?
A. A field
B. Information
C. A database
D. A table
8. As far as database is concern, the Acronym DBMS Stands for
A. Datum base management system
B. Datum base management sub-system
C. Determined Base management system
D. Database management system
9. A company has a single table in a computer(e.g spreadsheet) in which is stored every information about each
worker including the transactions he/she does in the company. This table is
A. A table database
B. A spreadsheet
C. A flat file database
 D. A joint database
10. Which of the following statements corresponds to the second normal form for an entity-relationship model in a
relational database?
A. A relationship must have only one key and the attributes must have simple domains
B. A relationship must have a key, with simple domains for its attributes and all non-key attributes depend
entirely on the key
C. A relationship must have a key with static domains for its attributes which all depend on the key
D. A relationship must have only one key with all attributes dependent on the key
11. Which manual aims to tell you how to use a software
A. Technical manual
B. Documentation
C. User manual
D. Program
12. When is cache memory useful?
A. When the computer is connected to the internet
B. Only when the RAM is working
C. When information is transfer between hard disk and the processor
D. When a computer is booting
13. The octal equivalent of the hexadecimal code F3A1 is:
A. 173101
B. 176541
C. 176451
D. 178661
14. The decimal equivalent of the binary number 101001.1011 is:
A. 41.7875
B. 41.875
C. 41.6875
D. 41.1875
15. In the memory hierarchy the fastest memory is
A. RAM
B. Cache
C. CPU register
D. Virtual memory
16. In a token ring network:
A. Each node has to ‘grap’ the token at a designated time and send or receive a message
B. Message can be passed round the ring in either direction
C. Message tokens can simultaneously be passed around the ring
D. The message is passed to the correct recipient by a central computer
17. Which unit is responsible for converting the data received from the user into computer understandable format?
A. Memory unit
B. Arithmetic and Logic unit
C. Input unit
D. Output unit
18. Which of the following is not a function of the input unit
A. It reads instructions and data from the outside world
B. It convert data into computer acceptable format
 C. It makes the data into user understandable format
D. It supplies the data and instructions to the computer for further processing
19. Which of the following is non-volatile storage
A. Backup
B. Secondary
C. Primary
D. Cache
20. What is the name of the software that allows a user to view web pages
A. Browser
B. Mail client
C. FTP client
D. Messenger
21. Network uses star topology if
A. Computers are arrange in a close loop
B. All computers attach to a central point
C. All computers attach to a single long cable
D. Computers attach to multiple hierarchical cables
22. Keys to represent relationship between tables is called
A. Primary key
B. Secondary key
C. Foreign key
D. Candidate key
23. Which of the following normalization places the table that all the fields are dependent on the primary key and
are independent of each other
A. 1NF
B. 2NF
C. 3NF
D. BCNF
24. The ability of application to run on different platform is called
A. Reusability
B. Portability
C. Reliability
D. Flexibility
25. The word “attributes” in a database are properties of
A. A database
B. A field
C. A record
D. An entity
26. Which of the following scanners can be used to capture and convert hand-written text into editable text?
A. OMR
B. MICR
C. OC
D. Barcode reader
27. Which of the following has the same functions as RAM?
A. Flash memory
B. Read Only Memory
 C. Cache memory
D. Virtual memory
28. The i7 laptops that is mostly used today by students is classified as ____ computers
A. 5th generation
B. 4th generation
C. 3rd generation
D. 2nd generation
29. An office door that is opened through eye scan is said to use
A. Automatic system
B. Biometric system
C. Artificial system
D. CY scan
30. Which of the following does not implies the presence of a virus in a computer?
A. Special software
B. The speed of the computer
C. The virus activities
D. File extension
31. The quality of images in the computer can be improved by
A. Using a larger monitor
B. Changing the graphic card
C. Increasing the brightness
D. Increasing the RAM chips
32. The unit in the computer that performed binary operation is
A. Accumulation
B. Control unit
C. Arithmetic and logic unit
D. Input/output
33. Signals interference in data transmission is reduced by
A. Twisting of cable
B. Burying of cable on the ground
C. Using many ports
D. Using only coaxial cables
34. The amount of data that can flows in a network medium at a given time is defined by the
A. Switch
B. Server
C. Bandwidth
D. Cable
35. Instruction from the local storage get in the central processing unit through the
A. Operating system
B. Random access memory
C. Registers
D. Buffer
36. The organization of files in the local storage of a computer is carried out by the
A. Operating system
B. Central processing unit
C. File manager
 D. Windows explorer
SECTION B
1. Define the following as use in database
i. Partial dependency
ii. Transitive dependency
iii. Foreign key
iv. DBMS
2. I) suppose X is a register whose current contents:

1 0 0 0 0 1 1 1

What is the denary equivalent of Register X if

(a) It represent unsigned binary integer
(b) It store 2’s complement binary integer

II) convert the following numbers to binary numbers

a) 2148
b) 17F616

III) From the truth table below

a) Construct the corresponding logic gate

b) Deduce the Boolean expressions for sum and remainder

A B Sum Remainder
0 0 0 0
0 1 1 0
1 0 1 0
1 1 0 1

3. Consider the table below

orderid customeri cusaddress email orderdate itemcode itemname Order Unitprice

d qty
N12 C01 Obilli mark@gmail.cm 02/02/202 125 Beans 12 250
5 134 Garri 3 1500
154 Rice 1 15000
M14 C02 Mendong Claris@gmail.cm 02/05/202 125 Beans 8 250
4
K52 C03 Bali ndi@gmail.cm 14/12/202 154 Rice 5 15000
3

a) From the above table, Give

a. Number of attributes
b. Number of fields
c. Transform the table to 1NF
b) Draw the design view of the above table